topic DATA Step to create 3 new datasets in SAS Programming

DATA Step to create 3 new datasets

sambasiva_ravuri_tcs_com — Wed, 14 Mar 2012 09:25:44 GMT

Dear All,

Am having the following fields in a Dataset (Rollnumber, Name,Age, Mark and Dept). Using this , would like to create 3 New Datasets based on Age<20, 20<age>30 and Age ge 30.

Appreciate for the help.

Regards,

S Ravuri.

DATA Step to create 3 new datasets

manojinpec — Wed, 14 Mar 2012 09:57:02 GMT

data one two three;

set have;

if age < 20 then output one;

if 20< = age <30 then output two;

if age >= 30 then output three;

run;

I have taken into account the equal condition as well. Incase you don't want you can omit.

DATA Step to create 3 new datasets

Haikuo — Wed, 14 Mar 2012 11:09:57 GMT

Or more efficiently,

data one two three;

set have;

if age < 20 then output one;

ELSE if 20< = age <30 then output two;

ELSE if age >= 30 then output three;

run;

Regards,

Haikuo