base programming

[shahparth260]

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 

[Reeza]

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

[shahparth260]

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

[Reeza]

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.

---

[shahparth260]

I suppose to get ans like this for new example 

1 5

5 5

8 8

8 10

[shahparth260]

which ever day missing should be represent as single 

[Patrick]

@shahparth260

Please help us to help you. Here some tips how this could work.

https://communities.sas.com/t5/Getting-Started/How-to-get-fast-helpful-answers/ta-p/226133

[Reeza]

Here's one way:

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