topic Re: Split data into different sub datasets in New SAS User

Split data into different sub datasets

beekee — Mon, 16 Aug 2021 15:40:26 GMT

Hi All,

I'm new to SAS programming. Want to know how I can split my data into three sub-datasets: data before 1970, data
between 1970 to 1979 and data from 1980 onwards.

This is my current dataset:

This is my current code:

data ANL351.tourism;
infile "/home/u59111097/TMA/tourism.csv" dlm=',' FIRSTOBS = 2;
input year vsp pdi puk exuk pop cpisp exsp;
run;

proc contents data=ANL351.tourism;
run;

proc print data=ANL351.tourism;
run;

Thank you.

Re: Split data into different sub datasets

Kurt_Bremser — Mon, 16 Aug 2021 16:06:37 GMT

data
  before
  inbetween
  after
;
set have;
if year lt 1970 then output before;
else if .... /* add other conditional outputs */
run;

Re: Split data into different sub datasets

PaigeMiller — Mon, 16 Aug 2021 16:14:24 GMT

The easiest solution, which is also the best solution in my opinion, is the leave the data set as one large data set and do not split it.

What is your need to have this data split? How would splitting the data set provide benefits? What can you do with split data sets that you can't do with the un-split data set?

Re: Split data into different sub datasets

Reeza — Mon, 16 Aug 2021 19:08:40 GMT

Usually it isn't useful to do that in SAS, instead you would create a new variable that indicated the decade and then use BY group processing.