topic subsets in SAS Programming

subsets

okb12886 — Sat, 29 Feb 2020 19:12:12 GMT

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.

Re: subsets

okb12886 — Sat, 29 Feb 2020 19:12:41 GMT

what would be the code

please & thank you

Re: subsets

Reeza — Sat, 29 Feb 2020 19:34:33 GMT

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