create dataset

[rak123]

Hi,

I have used array statement to change the wide format to long format for  a dataset. I created a dataset excluding the missing values of hwt variable. In addition, I want to output the list of subjects missing variable hwt as a separate dataset.

data patient1;

set patrecord;

array cal(i):smileyinfo: hwt1 hwt2 hwt3 hwt4;

do over cal;

   day = i;

  hwt=cal;

IF missing(cal) THEN delete;

output;

end;

keep ID day hwt;

run;

Any suggestions, please!        

[LinusH]

A sample of desired output would help. And how do you define "subject".

But it shoulnd't much more than having a second data set defined in the data statement, and have two different output statements (rather than the delete?).

[art297]

I agree with Linus: a sample of the desired output would definitely help.

Do you realize that your current code stops working on a record as soon as it finds a missing value?

[ballardw · Accepted solution]

Is something like this what you are looking for?

data patient1

       missinghwt (keep= PatienIdVariable day)

;

set patrecord;

array cal(i) hwt1 hwt2 hwt3 hwt4;

do over cal;

   day = i;

  hwt=cal;

IF missing(cal) THEN output missinghwt;

else output patient1;

end;

keep ID day hwt;

run;

[rak123]

Thank you all ! That additional statement works!