Welcome to RunSubmit.com

Question

2

Hi, I have the following sample data:

custid 
100 
200 
300 
400 
500 
. 
. 
etc.

I want to build the following string:

where custid in (100, 200, 300, 400, 500.....)

I have SAS 8.21 installed at my location. What is the best way to accomplish this? Thanks.

flag	asked Oct 31 at 13:09 SAS-L♦♦ 375●5

jay.l.stevens · Accepted Answer · 2009-11-04 16:33:00Z UTC

6

/*- Setup your data -*/
Data start; 
input custid; 
cards; 
100 
200 
300 
400 
500 
run; 

proc sql noprint;
/*- Get the List into a Macro Var --*/
select distinct custID
into :IDList separated by ','
from Start;
/*-- now put it into your code gen template --*/
create table String
as select "Where CustID in (&IDList)" as String_You_Want
from Start (obs=1);
quit;

edited Nov 4 at 16:33

answered Oct 31 at 13:16

jay.l.stevens♦
783●8

	I'd also suggest adding a distinct clause into the select statement in case there are duplicate values. – cmjohns Nov 4 at 15:58
	done. good catch. – jay.l.stevens♦ Nov 4 at 16:33

Building a character string?

Remember to vote up questions/answers you find interesting or helpful (requires 15 reputation points)

1 Answer