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;
