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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: