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;
Thanks for reply. We don't have DI Studio License. We only have SAS/Base and SAS EG.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.