DATA Step, Macro, Functions and more

base programming

Reply
Occasional Contributor
Posts: 15

base programming

 

day 

1

4

10 

 

need to have : 

    stdt      enddt       label

1)   1              4       came to see hospital

2)   4              4       miss date 

3)   4             10      came hospital

 

FYI : record 2) represent missing day when pt not come to hospital. 

 

what if I have more days missing ? 

such as 

days 

 

1

5

8

10 

 

 

 

 

PS
Super User
Posts: 23,771

Re: base programming

Posted in reply to shahparth260

I'm assuming you have some other variables that tell you 'miss' versus visit? Otherwise, how is that known?

Occasional Contributor
Posts: 15

Re: base programming

Yes I have missing flag but I already subset it so that's why I got this days.
PS
Super User
Posts: 23,771

Re: base programming

Posted in reply to shahparth260

Ok. How are we supposed to know that this is a miss:

 

2)   4              4       miss date 

 

In your new example would both those middle records be missing?

 

1

5

8

10 

 

Would this be which of the following and how are we supposed to tell the computer that?

 

1 5

5 5

5 8

8 8

8 10

 

or 

1 5

5 8

8 10

 

or 

1 5

5 5

5 8

8 10

 

or 

1 5 

5 8

8 8

8 10

 


@shahparth260 wrote:
Yes I have missing flag but I already subset it so that's why I got this days.



 

 

Occasional Contributor
Posts: 15

Re: base programming

I suppose to get ans like this for new example 

 

1 5

5 5

8 8

8 10

 

PS
Occasional Contributor
Posts: 15

Re: base programming

Posted in reply to shahparth260

which ever day missing should be represent as single 

 

PS
Respected Advisor
Posts: 4,736

Re: base programming

Posted in reply to shahparth260
Super User
Posts: 23,771

Re: base programming

Posted in reply to shahparth260

Here's one way:

Screen Shot 2018-03-16 at 7.20.09 PM.png

 

I suspect you have other variables present that would make this much simpler.

 

 

 

 

Ask a Question
Discussion stats
  • 7 replies
  • 139 views
  • 1 like
  • 3 in conversation