BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Phaneendra
Fluorite | Level 6

How do i assign the SINGLE output of an step to a variable inside a macro?

 

E.G: There is only one distinct value of a character variable in a dataset. I want to assign that Distinct Value to 't';

Please Help, How Can We Do It?

 

It's like i want:

%Let t = %Eval(Proc Sql; Select Distinct(XYZ) From Prq; Quit;)

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User
proc sql;
Select Distinct(XYZ) into : T
 From Prq;
Quit;

%put &T ;

View solution in original post

2 REPLIES 2
Ksharp
Super User
proc sql;
Select Distinct(XYZ) into : T
 From Prq;
Quit;

%put &T ;
Astounding
PROC Star

SQL will do that for you.  Include a separator, just in case there is more than one possible value for XYZ:

 

proc sql;

select distinct xyz into : t separated by ' ' from Prq;

quit;

 

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 4922 views
  • 2 likes
  • 3 in conversation