DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 41

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

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!

    

        

Super User
Super User
Posts: 7,039

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

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;

Super User
Posts: 10,020

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

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

Ksharp

Ask a Question
Discussion stats
  • 2 replies
  • 148 views
  • 0 likes
  • 3 in conversation