I need help in:
I need to create a variable - and keep it as missing as it is not present in my dataset. However to make it standard and if that variable comes back in future.
Now i am using in the data step.
data inc;
set sashelp.class;
mhelp=" ";
run;
But in the above case if my mhelp variable comes back in future then it makes it as missing which i do not want to.
Any help
Create a template dataset which is what you want to be present, then set that with the data you get, best of both worlds:
proc sql; create table TEMPLATE (var1 char(200),var2 num,var3 char(50)); quit; data data_in; var1="Abc"; var3="Def"; run; data want; set template data_in; run;
Create a template dataset which is what you want to be present, then set that with the data you get, best of both worlds:
proc sql; create table TEMPLATE (var1 char(200),var2 num,var3 char(50)); quit; data data_in; var1="Abc"; var3="Def"; run; data want; set template data_in; 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.