topic Re: create dataset in SAS Procedures

create dataset

rak123 — Thu, 24 Oct 2013 14:44:48 GMT

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!

Re: create dataset

LinusH — Thu, 24 Oct 2013 14:54:18 GMT

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?).

Re: create dataset

art297 — Thu, 24 Oct 2013 15:06:18 GMT

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?

Re: create dataset

ballardw — Thu, 24 Oct 2013 15:06:46 GMT

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;

Re: create dataset

rak123 — Thu, 24 Oct 2013 15:16:20 GMT

Thank you all ! That additional statement works!