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
I'm assuming you have some other variables that tell you 'miss' versus visit? Otherwise, how is that known?
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.
I suppose to get ans like this for new example
1 5
5 5
8 8
8 10
which ever day missing should be represent as single
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
Here's one way:
I suspect you have other variables present that would make this much simpler.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.