Hello,
Please, I want to do these actions on SAS Entreprise guide interface :
Action 1:
Proc sql;
create table m1 as
select distinct v
from toto;
quit;
Action 2:
proc sql;
create table m2 as
select *
from test
where g in('5','6') and h>1 and j=1;
quit;
Action 3:
using : left join, inner join, full join in SAS EG
Action 4:
Compare two data (d1, d2) are not in the same folder without opening any data or allocating the libraries
I do not want to make
{ ==> Libname lb1 "c:/m";
libname lb2 "c:/n";
==> data-- >compare
}
Thank you
Any documantion for using SAS EG are welcomed
Actions 1 to 3 can be done in a code window.
Action 4 is impossible, one cannot access SAS datasets without defined libraries. That is very basic SAS knowledge.
Ah, yes, and the documentation is here:
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.