PROC SQL - Left Join Not Working

[SuryaKiran]

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;

[Kurt_Bremser]

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.