Hi All Apologies for the semi-descriptive title...if any one can suggest a better one and I can change it then please let me know! OK, to the problem, sounds an easy one but can;t think of an easy solution. I have a dataset of subject and timepoint info.   001     Screening 001     Visit 1 001     Visit 2 002     Screening 002     Visit 1 002     Visit 3 I need to create a new dataset where each subject in the output dataset has 4 records per timepoint? They have 4 tests done at each timepoint Test1 Test2 Test3 Test4 So final dataset should look something like 001     Screening     Test1 001     Screening     Test2 001     Screening     Test3 001     Screening     Test4 001     Visit 1          Test1 001     Visit 1          Test2 001     Visit 1          Test3 001     Visit 1          Test4 .... .... .... Thanks! Steve The output data will be exported to excel and then filled in by hand ... View more

Hi Is it possible to assign values to missing without knowing the variable's type? A function that would assign a '' or . itself and I do not have to explicitily type it.  I have some variables and do not want to have to find out which each type is  and then assign them either '' or . myself. Something like      textvar=missing;      numvar=missing; ie set it to the appropriate missing value Thanks in advance Steve ... View more

Hi All I create a dataset by setting many datasets together.  Is it possible to find out which dataset contributed the observation? eg Data Health;      set one            two            threee            four; run; I need to mark where each obs came from Thanks Steve ... View more