topic Re: separate list by quotes in SAS Programming

separate list by quotes

deleted_user — Tue, 01 Apr 2008 13:07:12 GMT

I have a macro variable:

%let x = a b c d e f;

I want to use this in a couple of ways:

1: In the Keep statement - Data test; set indata(keep=&x.);

2. In the subset: Data test; set indata; if quest in(&x.);

for the scenario 2 I would need the string in %let x quoted, so it should be
%let x="a" "b" "c" "d" "e" "f";

Is there a way in SAS, I can place the quotes in datastep around the list of these macro variable values.

thanks for your help

Re: separate list by quotes

deleted_user — Tue, 01 Apr 2008 14:59:18 GMT

Hi,

prepare 2. macro variable

e.g.:

%let x =CUST BAB2 BAB3;

%let x2 = %sysFunC(compress(%BQUOTE(") %sysFunC(tranwrd(&x, %str( ), ",")) %BQUOTE(")));
%PUT &x2;

result:

"CUST","BAB2","BAB3"

M.

Re: separate list by quotes

deleted_user — Tue, 01 Apr 2008 19:41:19 GMT

Thank you very much. The solution you provided worked perfect.