BookmarkSubscribeRSS Feed
LineMoon
Lapis Lazuli | Level 10

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

 

 

 

 

 

2 REPLIES 2
Kurt_Bremser
Super User

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:

https://support.sas.com/documentation/onlinedoc/guide/

Reeza
Super User
Action 1-3 use query builder which generates SAS SQL code in the background. You can view the code and customize it as well. Or you can include a code node and paste your code into a window.

Action 4. Use a merge with relevant BY.
You can post the full path in your set statements.

Data compare;
Merge 'c:\path\mysasdataset1.sas7bdat'
'c:\path\mysasdataset2.sas7bdat';
By id;

Run;

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

SAS Enterprise Guide vs. SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 912 views
  • 1 like
  • 3 in conversation