I'm glad that you found the solution. But note that this will keep only one value in the macro variable when you have multiple values.
Check this two approaches where there are multiple values to be accounted.
proc sql noprint;
select name into: Name
from sashelp.class;
quit;
proc sql;
select * from sashelp.class
where name="&Name"
;
Quit;
proc sql noprint;
select quote(strip(name)) into:Name separated by ','
from sashelp.class;
quit;
proc sql;
select * from sashelp.class
where name in (&name)
;
Quit;
The situation seems to be like that:
Each new dataset only contains data for a specific group in the existing dataset. From that, I think that adding the
a.'Profile Application'n = b.appname
to the on clause of the left join should also work. But taking the appname from the first obs of the incoming file and using that in the where will also work, as the "solved" message shows.
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.