Help using Base SAS procedures

create dataset

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

create dataset

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!        


Accepted Solutions
Solution
‎10-24-2013 11:06 AM
Super User
Posts: 10,516

Re: create dataset

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;

View solution in original post


All Replies
Super User
Posts: 5,257

Re: create dataset

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

Data never sleeps
PROC Star
Posts: 7,363

Re: create dataset

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?

Solution
‎10-24-2013 11:06 AM
Super User
Posts: 10,516

Re: create dataset

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;

Occasional Contributor
Posts: 10

Re: create dataset

Thank you all ! That additional statement works!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 295 views
  • 6 likes
  • 4 in conversation