Another way to do this...
proc sql;select x1, y1 into :x2, :y2 from havewhere group=2;select x1, y1 into :x3, :y3 from havewhere group=6;quit;
data want;set have;x2=&x2;y2=&y2;x3=&x3;y3=&y3;run;
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.