SAS Macro

SAS83 — Thu, 10 Mar 2011 14:47:40 GMT

Data x;
input num;
cards;
1
2
3
4
;
Run;

I want the following output :

%put =&y;

OUTPUT:

y=1,2,3,4

(Using ONLY with SAS Macro Statements)

Re: SAS Macro

SPR — Thu, 10 Mar 2011 15:21:31 GMT

Hello SAS83,

What do you mean "Using ONLY with SAS Macro Statements"?

The easiest and straitforward way to do it is this:
[pre]proc SQL;
select num into :y separated "," from x
;quit;
%put y=&y;
[/pre]
"Using ONLY with SAS Macro Statements" approach results in
[pre]%macro a;
proc SQL noprint;
select COUNT(*) into :n from x
;quit;
proc transpose data=x out=t prefix=c;
run;
%do i=1 %to &n;
proc SQL noprint;
select c&i into :c&i from t
;quit;
%end;
%let y=%TRIM(&c1),%TRIM(&c2),%TRIM(&c3),%TRIM(&c4);
%put y=&y;
%mend;
%a[/pre]
Is this what you need?
Sincerely,
SPR

Re: SAS Macro

SAS83 — Thu, 10 Mar 2011 17:16:26 GMT

Perfect !! Thanks SPR.

topic SAS Macro in SAS Procedures

SAS Macro

Re: SAS Macro

Re: SAS Macro