BookmarkSubscribeRSS Feed
SAS83
Fluorite | Level 6
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)
2 REPLIES 2
SPR
Quartz | Level 8 SPR
Quartz | Level 8
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
SAS83
Fluorite | Level 6
Perfect !! Thanks SPR.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 1021 views
  • 0 likes
  • 2 in conversation