BookmarkSubscribeRSS Feed
ybz12003
Rhodochrosite | Level 12

Hello:

 

I have a proc sql to create a macro variable list.  However, some names I don't want them in that macro list.   For example, the '&varlist' includes 'apple1', 'pear2', 'grape3' and 'cherry4'.  However, 'apple1' and 'pear2' should not be in the list.   Please advice how to remove them.  Also, is there a way create a masterlist for removing list? 

Thanks.

 

%let removelist1=apple1;

%let removelist2=pear2;

 

proc sql noprint;

select name into :varlist separated by ' '

from test

where anydigit(name) ge 1;

quit;

 

%put &varlist;

2 REPLIES 2
slchen
Lapis Lazuli | Level 10

proc sql noprint;
select name into :varlist separated by ' '
from test where name not in ('apple', 'pear') ;
quit;

LinusH
Tourmaline | Level 20
Just add them to your WHERE clause.
And yes, you can create a look up data set containing those values (one per row) and then use the
NOT IN (SELECT name FROM Lookupdataset)
construct in the WHERE clause as well.
Data never sleeps

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 914 views
  • 2 likes
  • 3 in conversation