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.
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;
MISSING()?
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.