Prev: Macro variable and do loop
Next: How to get the last non-missing variable value
From: Abebe Gashaw on 21 Feb 2010 09:46
Hi friends.



I have a dataset which contains records with variables with contents and
missing values as follow:



Data Test1;

Input Name $ Action1 $ data1 $ Action2 $ Date2 $ Action3 $ data3 $ action4
$ date4$;



Cards;

Name1 read 02Feb10 write 03Feb10

name2 read 01Feb10 write 05Feb10 walk 10Feb10 Jump 12Feb10

Name3 read 03Feb10 eat 08Feb10 Run 13fEB10 ;



Run;



In order to find the duration; I need to know the last day so that I will
subtract last data minus data1.



Since there could be some missing variable such as date3 for NAME1 or Data4
for NAME3, I am having problem finding or identifying the last non-missing
date for each record.

Can someone help me doing that please?



Regards,

Abebe
 | 
Pages: 1
Prev: Macro variable and do loop
Next: How to get the last non-missing variable value