BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
peiy5920
Calcite | Level 5

Hello all,

 

My data including variable SEX(Female and Male), variable WHITE(White and Not White), But in my table, I just need Male(N(%)) and White(N(%), how can I write my codes, like this:

if SEX=Female then delete;

if WHITE=Not White then delete;

Are there some problems with this codes? Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20

You could consider making it more easily readable with a subsetting-if statement i.e

 

data want;
 set have;
 if white='White' and sex='Male';
run;

 /*or  Using Where */

where white='White' and sex='Male';

View solution in original post

1 REPLY 1
novinosrin
Tourmaline | Level 20

You could consider making it more easily readable with a subsetting-if statement i.e

 

data want;
 set have;
 if white='White' and sex='Male';
run;

 /*or  Using Where */

where white='White' and sex='Male';