Prev: PROC NLMIXED: finite gaussian mixture distribution of latent exogenous variables in a structural equation model
Next: 30 Days Free Trial Project Management Software
From: Al on 15 Jun 2010 23:11
Dear All:

These are the data sets i have ..

data lab;
input pat lab $ day;
cards;
1 BUN 1
1 BUN 23
1 BUN 30
1 BUN 46
1 BUN 56

run;
data ae;
input pat seq day_ae daysp;
cards;
1 1 19 25
1 2 29 .
1 3 40 45
1 4 20 29
1 5 50 52
run;


This is the output i am trying to get ..

Pat Seq Day23 Day30 Day46 Day56
1 1 x x
1 2 x x x
1 3 x x
1 4 x x
1 5
x


This is what I am trying to do .. I am trying to create a dataset
with
columns Day1 Day23 Day20 Day46 Day56 (The names of these columns are
the values of Day column in Lab data) and under these columns I
should be able to have the values of Day_ae and Daysp from AE data
in such a
way that

1<Day_AE<=23 must fall under Day 23 column and x must be assinged
under Day 23 column
and should be going across the rest of the columns if daysp is missing
and if daysp is not
missing x must be placed uder the range of columns ..

Hope this is clear..


Thanks in advance
Al
 | 
Pages: 1
Prev: PROC NLMIXED: finite gaussian mixture distribution of latent exogenous variables in a structural equation model
Next: 30 Days Free Trial Project Management Software