Split data into different sub datasets

[beekee]

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.

[Kurt_Bremser]

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

[PaigeMiller]

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?

[Reeza]

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.