I am new to DS2 and want to test a few things. In the below example, hoe can I create a package for proc sql step (table3) and use it further in the program? data table1;
input id name $;
cards;
1 name1
2 name2
3 name3
4 name4
;
run;
data table2;
input id city $;
cards;
1 city1
2 city2
3 city3
5 city5
;
run;
proc sql;
create table table3 as
select a.id, a.name, b.city
from table1 a
left join table2 as b
on a.id = b.id
order by 1;
quit;
... View more