topic Re: Determine whether a cell is populated or not then do something in SAS Programming

Determine whether a cell is populated or not then do something

spcoman — Wed, 31 Jan 2018 14:21:34 GMT

I'm trying to find code that, in the PROC or DATA step, will create a new variable 1 for each row where the city variable contains data. I've found lots of examples on how to look for specifics within the data using IN or CONTAINS but I can't find an example of a code that looks to see, like a binary, if it is populated or not. I can create the new numeric variable easily enough, it's identifying the correct cells I am having issues with.

Re: Determine whether a cell is populated or not then do something

Reeza — Tue, 30 Jan 2018 21:31:24 GMT

MISSING()?

Re: Determine whether a cell is populated or not then do something

novinosrin — Tue, 30 Jan 2018 21:38:05 GMT

That's when you use boolean expressions. Simply take advantage of it-

data have;
set sashelp.class;
if _n_ in (1,3,5,7,9) then city='Chicago';
run;

data want;
set have;
missing_check=missing(city);
run;