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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.