BookmarkSubscribeRSS Feed
araz
Fluorite | Level 6

Hi Every one, 

 

I am trying to document to crour process flow, and to do that I am using EG 5.1 to create the process flow. Ideally I want to see the join sign (task ) for joining two datasets that are created earlier in the ocde, but EG just show that Dataset1, Dataset2 and now data set3 is created. 

The view that would help me is to have the join sign that would show that Datasset3 is teh result of the joining of Dataset1 and Dataset2. 

Is this possible ?

 

So many thanks,

Araz

data Scores(label='Recorded Scores at Visits' drop=j c);
length Subject_ID $8 Visit 8 A1-A10 8 B1-B10 $20 ; /* B fields made intentionally */
array A[10]; array B[10]; /* longer than they needed to be */
do c=1 to 3000;
if c le 1500 then subject_id=compress('100-'||put(c,z4.));
else subject_id=compress('200-'||put(c, z4.));
do Visit=1 to 20;
do j=1 to 10;
a[j]=j*ranuni(j);
b[j]=left(put(.5+j**2*ranuni(j),7.3));
end;
output;
end;
end;
format a: 5.2;
run;

data Surgery;
length SID $8 Visit 8 case 8;
do k=5 to 3000 by 197;
if k lt 1500 then SID=compress('100-'||put(k,z4.));
else SID=compress('200-'||put(k, z4.));
Visit=10+int(10*ranuni(971156)); /* only one visit per subject */
case+1;
drop k;
output;
end;
run;

proc sql /*feedback _method*/;
create table Scores_Surg1 as
select *
from Scores T1, Surgery T2
where T1.subject_id=T2.sid and
T1.visit=T2.visit;
quit;

2 REPLIES 2
LinusH
Tourmaline | Level 20
Not sure if you can.
If you have the need to document and maintain jobs/programs over time, I wonder if you are using the "wrong" tool. DI Studio is developed for such cases.
Data never sleeps
araz
Fluorite | Level 6

Thanks for reply. We don't have DI Studio License. We only have SAS/Base and SAS EG. 

sas-innovate-2024.png

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.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 933 views
  • 0 likes
  • 2 in conversation