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;)
proc sql;
Select Distinct(XYZ) into : T
From Prq;
Quit;
%put &T ;
proc sql;
Select Distinct(XYZ) into : T
From Prq;
Quit;
%put &T ;
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;
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!
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.