I am trying to use ods layout with ods region as a way to show the output instead of title approach. However not sure if we can use byvar/byval option as in title for proc report .secondly how can we print the output side by side on a same page . ... View more

Have an interesting SAS Question and if it can be done in proc report . The input dataset looks like this : name col1  percent1 col2  percent2 abc 45 0.12 56 0.32 def 34 0.25 45 0.80    Output report needed on a pdf  document with the name variable as by variable on separate pages  like this : used byvalue() option on the title but columns are not getting transposed to desired format. Any help is highly appreciated. thanks in advance title >>>>>  byname - abc   page1   column_header percent_header     col1 45 12%     col2 56 25%       title >>>>>  byname - def   page2   column_header percent_header     col1 34 25%     col2 45 80%       Basically I am trying to align columns as rows with description. ... View more

Not making this more complicated , just trying to learn all possible scenarios in which a data problem can be addressed. Thanks so much for sharing your approach to this problem.   ... View more

Another interesting situation: if data looks like this and first row has no data but want to fill it based on info from next row Then how hash logic will change, Example as below HAVE--> patid   date      team     action 1111 24-jan  1111 25-jan-2016 medical added 1111 27-jan-2016 surgical added 1111 29-Jan-2016 medical removed 1111 31-Jan-2016 surgical   removed 1111 04-feb         WANT -->  patid        date      team1     team2 1111        24-jan  medical            (Populating this row based on next non missing observation from 25th jan data) 1111        25-jan medical   1111        26-jan  medical   1111        27-jan medical   surgical 1111        28-jan medical   surgical 1111        29-jan    surgical 1111        30-jan    surgical 1111        31-jan    1111        01-feb    1111        02-feb                               1111        03-feb                              1111        04-feb                            no data basically for last rows with no info on team and action, they are populated based on data  from 31 st jan data row ?   Thanks   ... View more

Thanks so much, this solution is very innovative . Declare and hash are so useful in sas programs.. ... View more

Very Innovative approach especially for handling dates part .. ... View more

data row is not showing up for 31st jan .i.e last row is not showing up in the output dataset... It stops at 30th jan populating that row only.. Logic is correct !!! and code is giving right results till 2nd last row only !!.   ... View more

Yes obgyn actually should be in 31st Jan row along with surgical. You're right. Thanks for noticing it and thanks for your useful innovative response.   ... View more

I am Sorry it got posted 3 times by mistake as I wasn't sure which category is right to post in. Will avoid this duplicate submission in future. Thanks for the response and sharing your approach to this data management problem. ... View more