proc sql; select x1, y1 into :x2, :y2 from have where group=2; select x1, y1 into :x3, :y3 from have where group=6; quit;
data want; set have; x2=&x2; y2=&y2; x3=&x3; y3=&y3; run;
Missed SAS Innovate in Orlando?
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
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.