DATA Step, Macro, Functions and more

Need to create NEW dataset from dataset2 if salary>10000 using DATA Step?

Reply
Contributor
Posts: 42

Need to create NEW dataset from dataset2 if salary>10000 using DATA Step?

Dear All,

I would like to create NEW dataset from dataset2 if salary >10000 using DATA Step ?

Dataset2:

Roll numberDobSalaryexperience
111/12/8725002
512/04/5634003
303/06/7912004
204/05/94445604
403/07/99129083
603/07/99129087

Thanks a lot in advance for your help.

Regards,

S Ravuri.

Super User
Posts: 10,516

Need to create NEW dataset from dataset2 if salary>10000 using DATA Step?

data newdata;

     set dataset2 (where=(salary>10000));

run;

You may not actually need to create a new dataset as you can use the where clause with procedures as well;

proc freq data=dataset2 (where=(salary>10000));

table <variables>;

run;

Ask a Question
Discussion stats
  • 1 reply
  • 121 views
  • 0 likes
  • 2 in conversation