Say y = %scan(&list, &k., ",") Now if you need character output in double quotes, you just need to make the following change: y = "%scan(&list, &k., ",")" Also use %scan in a loop only
... View more
Hello @vkabdwal
There should be no error as long as table2 exists. The code would obviously fail if table2 does not exist.
Please see the code below.
data table1;
input fy sub_new;
datalines;
2010 5
2012 6
2013 3
2014 4
2017 2
;
run;
proc sql;
create table table2(Rename=(sub_new=sub_left)) like table1;
quit;
proc sql;
create table final_table as
select a.*,b.* , (coalesce(sub_left,0)+coalesce(sub_new,0)) as Total_year
from table1 a
full outer join table2 b on
a.fy=b.fy;
quit;
The output will be as follows
... View more
