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!
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;
Plus, If grp is character ,then don't forget to add quote around it.
Ksharp
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.