BookmarkSubscribeRSS Feed
AsSASsin
Quartz | Level 8

Hello,

 

I wanto create a CAS View with a left join on the first table.

How can I do this?

My code:

 

cas;
libname public cas caslib=public;
libname casuser cas caslib=casuser;


data casuser.t1;
a=2;id=1;output;
a=4;id=2;output;
a=5;id=3;output;
run;
data casuser.t1;
e=2;id=1;output;
e=4;id=22;output;
e=5;id=23;output;
run;


proc cas;
table.view /
name="myview"
caslib="casuser"
replace=true
tables={{name="t1" caslib="casuser" keys={"id"}},{name="t2" caslib="casuser" keys={"e"}}}
;
run;
quit;

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Discussion stats
  • 0 replies
  • 1046 views
  • 0 likes
  • 1 in conversation