I removed value 0 records from data and it got resolved. ... View more

If the files already exist then use non-SAS tools to combine them.  Excel or powershell probably have ways to do this via programming.   But if you are making the files you could make the single file to start with.  Or if you need both the individual files and the combined file make them both at the same time.   ods excel (id=multiple) file='bigfile.xlsx' ; ods excel (id=single) file='single_file1.xlsx'; proc print data=file1; run; ods excel (id=single) close; ods excel (id=single) file='single_file2.xlsx'; proc print data=file2; run; ods excel (id=single) close; ods execl (id=multiple) close; ... View more

Hi Kurt, I'm late to replay and I hope by now you have figured it out about the shift table.  Here is a link how others talk about shift table: https://www.lexjansen.com/cgi-bin/saspapers_query.php title search for "shift table".  Shift table is important only because it was not easy to get for some important parameters in clinical trials.  We have done change from Baseline for continuous variables all the time, but for a very long time people haven't figure it out that we can do the same for categorical variables as we did for continuous variables.  In the case of 4 possible categorical outcomes, a 4 by 4 table (shift table) is used to present the result.  It takes a lot of space, and most of those 16 cells have no values. A little bit more complicated when you compare tables.  A simplified and short-handed shift table is proposed.  See the attached.    Best Regards Jianmin Long PS: the data in the attached is openly available on https://www.cdisc.org/sdtmadam-pilot-project   ... View more