topic Re: ng COlumn to Existing Data Table in a Macro STep in SAS Programming

ng COlumn to Existing Data Table in a Macro STep

dwilliams1 — Wed, 13 Mar 2019 14:30:39 GMT

I want to add a column to an existing data table in a macro step. I've already connected to a database and extracted the files of interest. The filename contains the specific lot ID but it is no where in the data table itself. So, I want to create a new column that contains the lot designation. In the snippet below, the sql portion works fine but the subsequent data step doesn't. More specifically, the part that fails is passing the macro variable in the data steps. Any help would be greatly appreciated.

options symbolgen mprint;

%macro loop;

%do i=1 %to 10;

proc sql;

create table &&ParamList&i.._data as

select *

from Prod.&&ParamList&i.._DATA;

quit;

data &&ParamList&i.._data;

set &&ParamList&i.._data;

Lot_ID=%str(%'&&ParamList&i%'); /* Here's where the issue is */

%end;

%mend;

%loop;

The following works but it's comp[lately manual...

data xyz_data;

set xyz_data;

runs='xyz';

run;

Re: ng COlumn to Existing Data Table in a Macro STep

ballardw — Wed, 13 Mar 2019 14:38:02 GMT

Here's an example of reading the current data set name and parsing a value from that. You should set length for the SETNAME variable for what you expect.

data example;
   
   set sashelp.class indsname=dsn;
   setname = scan(dsn,2,'.');
run;

and from multiple datasets when combining them. Not a particularly useful set but shows an example:

data example;
   
   set sashelp.class sashelp.cars indsname=dsn;
   setname = scan(dsn,2,'.');
run;

Re: ng COlumn to Existing Data Table in a Macro STep

dwilliams1 — Wed, 13 Mar 2019 14:47:08 GMT

ballardw,

THANK YOU! I really appreciate your help.

Dave

Re: ng COlumn to Existing Data Table in a Macro STep

dwilliams1 — Wed, 13 Mar 2019 14:50:01 GMT

Your response was quicker than me trying to edit my post to account for the sloppy cut/paste that I did!