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

[sambasiva_ravuri_tcs_com]

Dear All,

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

Dataset2:

Roll number	Dob	Salary	experience
1	11/12/87	2500	2
5	12/04/56	3400	3
3	03/06/79	1200	4
2	04/05/94	44560	4
4	03/07/99	12908	3
6	03/07/99	12908	7

Thanks a lot in advance for your help.

Regards,

S Ravuri.

[ballardw]

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;