I have some patients' medication data, need to convert it to binary table. Anyone has the solution?   what I have: Patient Medication1 Medication2 Medication3 ID1 A B C ID2 C E F ID3 E G H   what I want: Patient A B C D E F G H ID1 1 1 1           ID2     1   1 1     ID3         1   1 1 ... View more

I have a numeric version of datetime, like13DEC2021:10:28:00. I would like to convert it to character format like yyyy-mm-dd:hh:mm. Thanks for your help   ... View more

I have dataset as below: I need to add a page variable to break dataset into different pages for proc report. In the final report, each group in their own page, each page can only show 5 records, so one group may have one or more pages.      group     subgroup    count     1                A             8     1                B            6     1                C            4     1                D            3     2                 E          10     2                 A             9     2                B            8     2                D            7    2                 F             6    2                 G             5   ...                 ...             ... ... View more

I need to group the dataset by different ways. (1) within the same test, visitnum 101 and 108 should be in the same group,  other visitnums in their own group. (2) every different test + visitnum in a group. (3) every test in a group. These 3 ways can be done separately.  Sample dataset as below:  data have; input test$ visitnum ord seq; datalines; aa 101 0 0 aa 101 0 1 aa 101 0 2 aa 101 0 3 aa 101 0 4 aa 108 1 0 aa 108 1 1 aa 108 1 2 aa 108 1 3 aa 108 1 4 aa 108 2 0 aa 108 2 1 aa 108 2 2 aa 108 2 3 aa 108 2 4 aa 115 1 0 aa 115 1 1 aa 115 1 2 aa 115 1 3 aa 115 1 4 aa 115 2 0 aa 115 2 1 aa 115 2 2 aa 115 2 3 aa 115 2 4 bb 101 0 0 bb 101 0 1 bb 101 0 2 bb 101 0 3 bb 101 0 4 bb 108 1 0 bb 108 1 1 bb 108 1 2 bb 108 1 3 bb 108 1 4 bb 108 2 0 bb 108 2 1 bb 108 2 2 bb 108 2 3 bb 108 2 4 bb 115 1 0 bb 115 1 1 bb 115 1 2 bb 115 1 3 bb 115 1 4 bb 115 2 0 bb 115 2 1 bb 115 2 2 bb 115 2 3 bb 115 2 4 ; run; ... View more

I have the dataset as below: Student   Group   Class   Grade    001            7           2           A    002           7            1           B    003            5            3           A    004           5            4           C     005          6             2          B I want to use proc freq to get total count for each group according to  each grade, also for each class under each group. And proc transpose to get the final dataset will look like as below:  (n is the count for each class, N is the count for each Group) Group                       Grade      class                   A               B            C 7                             N               N            N       1                        n               n             n       2                        n               n             n 5                             N               N            N       3                        n               n             n       4                        n               n             n 6                             N               N            N       1                        n               n             n       2                        n               n             n ... View more

I have some dates in character format: UN/UNK/2020 14/JUN/2021 UN/APR/2019 I would need to convert them to the format yyyy-mm-dd. If day and month missing, output will be yyyy only, if day missing, output will be yyyy-mm.  Thanks   ... View more