|
hi,
how is it that we have to filter by week33 value when we can not
compare to month vaules?
I mean you should have time-period variable converted to only one
dimension (weeks, or months or hours....)
Daniel
2009/10/13 SAS_learner <proccontents@gmail.com>:
> Data test ;
> Input Usubjid $4. visit Visitnum week33YN;
> datalines ;
> 1001 month48 37 N
> 1001 month48 37 N
>
> 1002 Week25 26 N
> 1002 Week29 27 N
> 1002 Week33 28 N
> 1002 month12 29 N
>
> 1003 week13 15 N
> 1003 week13 15 N
>
> 1004 Week25 26 Y
> 1004 Week26 27 Y
> 1004 month12 29 Y
> 1004 month15 31 Y
> ;
> Run;
>
>
> Hello all,
>
> In the above data I need to look into visits and need to get a flag variable
>
> First case is when subject has no week33 but all the visits are less than
> visit 33 then week33YN = "N"
> second case is when Subject has week33 and visit more than Week 33 here
> Usubjid = 1001 then Week33YN = "N"
> Third case is when Subject has no Week33 but visits more than Week33 here
> Usubjid = 1004 then week33YN = "Y"
>
>
> I am trying to something without using arrays as I am not good using arrays.
> Can any body show me how get the flag values ??
>
> thanks
> SL
>
|
