topic Re: Add new variable in dataset and have word for all records in SAS Programming

Add new variable in dataset and have word for all records

jeremy4 — Fri, 07 Jun 2019 15:23:39 GMT

Hi,

Is there a way of creating a new variable e.g Checked and having all of the records have Y as the result in the checked variable, because I want this 'Y' flag to be apparent (for all records in this ac.list_Jan_Nov dataset) when I left join this dataset onto another dataset? Thanks!

data test;

set ac.list_Jan_Nov;

[What code to include here so that all records in ac.list_Jan_Nov dataset are selected?] .... then Checked='Y';

run;

Re: Add new variable in dataset and have word for all records

PeterClemmensen — Fri, 07 Jun 2019 15:34:16 GMT

Is this what you want?

data want;
   set sashelp.class;
   retain Checked 'Y';
run;

Re: Add new variable in dataset and have word for all records

jeremy4 — Fri, 07 Jun 2019 15:40:43 GMT

Hi,

Thanks for the reply. 'Checked' is currently not a variable in my ac.list_Jan_Nov dataset, but I would like to create the new 'Checked' variable (that is why I wrote then Checked = 'Y'; in the code above) and have all of the records in the ac.list_Jan_Nov dataset have Y for the 'Checked' variable, as all of the records have been checked and when I left join this dataset, I will know that the records in this dataset have been checked. Would the RETAIN statement help to do this?

Re: Add new variable in dataset and have word for all records

PeterClemmensen — Fri, 07 Jun 2019 15:40:20 GMT

Have you tried my code?

The variable checked is not in the SASHELP.CLASS data set either. The retain statement ensures that it has the value 'Y' for each record

Re: Add new variable in dataset and have word for all records

Reeza — Fri, 07 Jun 2019 15:41:35 GMT

Did you try the code? Pretty sure that's what it does.

If you want it in SQL, its like this;

proc sql;
create table want as
select *, 'Y' as checked
from sashelp.class;
quit;

Re: Add new variable in dataset and have word for all records

jeremy4 — Fri, 07 Jun 2019 15:44:11 GMT

Perfect, thanks a lot for your help!