DATA Step, Macro, Functions and more

what is the best way to create a variable and keep it as missing

Accepted Solution Solved
Reply
New User
Posts: 1
Accepted Solution

what is the best way to create a variable and keep it as missing

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


Accepted Solutions
Solution
‎01-31-2017 06:06 AM
Super User
Super User
Posts: 7,997

Re: what is the best way to create a variable and keep it as missing

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;

View solution in original post


All Replies
Solution
‎01-31-2017 06:06 AM
Super User
Super User
Posts: 7,997

Re: what is the best way to create a variable and keep it as missing

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;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 102 views
  • 0 likes
  • 2 in conversation