The output I would like would look like this:     ID          Time                   CScore     Visit           1       2016-07-20             180            2 1       2016-08-02             120            3 2       2017-01-02             109            2 2       2017-01-05             110            3 3      2016-05-12              110            2 3      2016-05-20              120            3   How would I go about doing that with a data step? Thank you! ... View more

Thank you! This was what I was looking for. I apologize for not having been clear in my previous posts. I'll make sure to include a data step the next time I have a question. Thank you all for your help! ... View more

I have many other variables in the dataset too, would proc transpose mess with them? Thank you! ... View more

Sorry, I misspoke, I did not merge the datasets, but set all the datasets into one, because I do not want to lose any observations   data t1; set d1-d10; ... View more

I created this dataset, it is multiple datasets that have been merged together into one dataset ... View more

Yes, here is a simplified example of my dataset   ID       CR      CR1        x           1           2  x           4           5  y           1           3  z           1           4   and I would like the final variable to be   ID       CR2 x          1 x          4 x          2 x          5 y          1 y          3 z         1 z         4   Thank you! ... View more

Yes, the variables are the same type. Just wanted to make sure the merge would work correctly. Thank you for checking that for me ... View more

Thank you! It was the split option that was definitely throwing everything off ... View more

I added the ODS escapechar and ('p-value^{super 1} LS Means^{unicode delta} (95% CI)' col_4);   and it still is only printing "unicode delta" and "super 1"   I am not sure what else could be going wrong   options nodate nonumber center Orientation=landscape topmargin=.5in bottommargin=.4in leftmargin=.5in rightmargin=.5in; ods listing close; ods escapechar='^'; ods rtf file="&outpath&saveWordDoc..rtf" ; title1 j=l font='Courier New' h=8pt "&titlename1 ^n &titlename2 ^n &titlename3" j=r "&sysdate9. &systime"; title2 j=l font='Courier New' h=8pt "&titleName4"; footnote j=l font='Courier New' h=8pt "&saveWordDoc..rtf" j=r  "Page ^{thispage} of ^{lastpage}" ; proc report nowd center spanrows missing split='^' data=all      list out=test                                                                                                     style(report)=[width=100% frame=void rules=none cellspacing=0 padding=1pt font=('Courier New', 8pt)] style(header)=[bordertopcolor=balck bordertopwidth=1                borderbottomcolor=black borderbottomwidth=1                background=white font=('Courier New', 8pt) textalign=c ] style(column)=[font=('Courier New', 8pt)  ASIS=ON ] ;    columns _PB_page vorder vid roworder rowlabel ('p-value^{super 1} LS Means^{unicode delta} (95% CI)' col_4); ... View more

Sorry, I put the ??? to show where I was confused on what I should be adding there. I have tried it without the ???, but all it prints is the actual text"unicode delta". Am I supposed to define the unicode before or in my proc report statement? Thank you so much for your help! ... View more