topic Create new variable in SAS Programming

Create new variable

yichentian226 — Thu, 24 Sep 2020 17:00:30 GMT

Hello,

There are two datasets, lets say dataset abc and dataset def

First I am trying to create a new string variable named: openflag in dataset abc, and the value to be 1 for the records. Can anyone check if my steps are right?

data abc;
set abc;
openflag = 1;
run;

Second I want to right join dataset abc with dataset def (keep all the records from def and those matching values from abc), let's say the new dataset after join steps is NEW. Now I have openflag in NEW, I wonder how to replace the missing values into 0? Thanks very much.

Re: Create new variable

PaigeMiller — Thu, 24 Sep 2020 17:17:49 GMT

@yichentian226 wrote:

Hello,

There are two datasets, lets say dataset abc and dataset def

First I am trying to create a new string variable named: openflag in dataset abc, and the value to be 1 for the records. Can anyone check if my steps are right?

data abc;
set abc;
openflag = 1;
run;

You can check this yourself. Just run the code and see if you get the desired results.

Second I want to right join dataset abc with dataset def (keep all the records from def and those matching values from abc), let's say the new dataset after join steps is NEW. Now I have openflag in NEW, I wonder how to replace the missing values into 0?

Are you referring to missing values because the join found no records in the left data set? Then something like this

proc sql;
    create table new as select *.
    case when missing(abc.openflag) then 0 else abc.openflag as openflag1
    from abc right join def on
     /* you have to specify the ON condition as your text didn't really mention what it was */
        abc.something=def.something;
quit;

Re: Create new variable

yichentian226 — Thu, 24 Sep 2020 17:50:36 GMT

This is very helpful thank you 🙂