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;
April 27 - 30 | GAYLORD TEXAN
Register now to lock in early bird pricing through February 25!
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.