SAS splitting input file logic you need

Split dataset

I want to share two things one is splitting your input dataset or file into multiple files or datasets using SAS. And, you can delete particular records from input dataset and write remaining into output file.You can apply the logic in your SAS macros.

Since file handling in SAS is very much important, if you want to work as data science developer in financial analytics.

Your input observations are critical in data analysis

Splitting dataset

The below example is having one input dataset and two output datasets. Your input file contain many observations. The requirement is you need to split into multiple files or datasets.

DATA New-Dataset-Name-1 (OPTIONS) New-Dataset-Name-2 (OPTIONS);
    SET Old-Dataset-Name (OPTIONS);
    IF (insert conditions for Dataset1) THEN OUTPUT New-Dataset-Name-1;
    IF (insert conditions for Dataset2) THEN OUTPUT New-Dataset-Name-2;

The ‘SET’ option in SAS is to read input files. To understand options just read here full details.

Real time example in SAS to split a files into multiple files.

DATA freshmen sophomores juniors seniors;
    SET sample;
    IF (Rank = 1) THEN OUTPUT freshmen;
    IF (Rank = 2) THEN OUTPUT sophomores;
    IF (Rank = 3) THEN OUTPUT juniors;
    IF (Rank = 4) THEN OUTPUT seniors;

In the above example, different rank holders (1, 2, 3,and 4) will have different files. Total four output files you can see in the above example.

DELETE records from input file

Here, you can delete matching records from input dataset. It is also called self updating files in SAS. The keyword ‘OUTPUT’, if you do not mention, then your input file will be updated.

DATA New-Dataset-Name (OPTIONS);
    SET Old-Dataset-Name (OPTIONS);
    IF (insert conditions) THEN DELETE;

You can see real time best example to delete matching records in input file using SAS.

DATA sample_small;
    SET sample;
    IF (Rank = 1) THEN DELETE;

Now, the ‘sample’ file does not contain records matching to Rank=1


Also read


Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.