subsets

[okb12886]

how do i create a subset of my sample?

for example i  have a sample of 1500, and want to look at those with only certain  characteristics; 

i would like get the proc freq for those only with the characteristics as well. 

[okb12886]

what would be the code

please & thank you 

[Reeza]

You can add in WHERE statements to filter your results as needed. Almost any PROC's in SAS will take a WHERE statement. 

/*filter a numeric value*/
proc freq data=sashelp.class;
where age = 13;
table sex;
run;

/*filter multiple numeric values*/
proc freq data=sashelp.class;
where age  in (10, 11);
table sex;
run;

/*filter a character values*/
proc freq data=sashelp.class;
where sex = 'F';
table age;
run;

/*filter multiple character values*/
proc freq data=sashelp.class;
where name in ('Jane', 'Alfred');
table age;
run;

---

@okb12886 wrote:

what would be the code

please & thank you 

---