topic Re: SAS Entreprise guide interface in SAS Enterprise Guide

SAS Entreprise guide interface

LineMoon — Sat, 30 Jan 2016 09:10:43 GMT

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

Re: SAS Entreprise guide interface

Kurt_Bremser — Sat, 30 Jan 2016 11:06:18 GMT

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/

Re: SAS Entreprise guide interface

Reeza — Mon, 01 Feb 2016 02:01:36 GMT

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;