Help using Base SAS procedures

SAS Macro

Reply
Contributor
Posts: 32

SAS Macro

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)
Super Contributor
Super Contributor
Posts: 365

Re: SAS Macro

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
Contributor
Posts: 32

Re: SAS Macro

Perfect !! Thanks SPR.
Ask a Question
Discussion stats
  • 2 replies
  • 181 views
  • 0 likes
  • 2 in conversation