topic storing a list of values from a field in a file in a macro variable... in SAS Programming

storing a list of values from a field in a file in a macro variable...

teg_76 — Mon, 19 Mar 2012 22:07:04 GMT

Hi,

I'd like to store a a list of values from a file in a file in a macro variable. I then would like to select all the rows from a dataset that do not have a value stored in the macro variable. HEre's what I have so far:

proc sql;

select grp sum(total)

from claims

where grp not in (&list);

quit;

How do I get the variables in to the "list" macro variable? The values that should populate the "list" macro variable are from a column in a csv file.

Thank you!

storing a list of values from a field in a file in a macro variable...

Tom — Mon, 19 Mar 2012 22:14:58 GMT

First put it in a dataset.

data exclude ;

infile 'exclude.csv' dsd firstobs=2;

input grp;

run;

Then ... Since you have it in a dataset forget about the macro variable and just use the dataset in the query.

If you must put it into a macro variable use the INTO clause in PROC SQL select statement.

proc sql noprint ;

select distinct grp into :list separated by ' '

from exclude

;

quit;

storing a list of values from a field in a file in a macro variable...

Ksharp — Tue, 20 Mar 2012 04:18:45 GMT

Plus, If grp is character ,then don't forget to add quote around it.

Ksharp