I am having issues with one of my order variables. I see that the roworder variable works perfectly fine in the final dataset that I am then using for proc report. But as soon as this dataset runs in proc report, the roworder variable doesn't seem to be working anymore. I have written out some examples along with what my current proc report statements is. I would like my final dataset to look like the "all" dataset Thank you! Any advice is greatly appreciated!   Final dataset: all rowlabel     col_1      roworder   vorder n                   12          1                  1 median          5           2                  1 mean             8           3                  1 n                    10         1                  2 median           5          2                  2 mean              8          3                  2   Output from proc report: rowlabel     col_1      roworder   vorder n                   12          1                  1 n                   10          1                  2 median          5           2                  1 median          5           2                  2 mean             8           3                  1 mean             8           3                  2     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 roworder rowlabel ("X^(N=&N1.)" col_1 col_12) ("Y^(N=&N2)" col_2 col_22) ("Total^(N=&N3)" col_3 col_32) ("p-value LS Means (95% CI)" col_4);    define _PB_page/group noprint;    define vorder/order noprint;    define vid/order noprint;    define roworder/order noprint;    define rowlabel/display '' style(column)=[width=1.5in] flow;    define col_1/display  'OBS' style(column)=[width=1in] center flow;    define col_12/display 'CHG' style(column)=[width=1in] center flow;    define col_2/display 'OBS'  style(column)=[width=1in] center flow;    define col_22/display 'CHG'  style(column)=[width=1in] center flow;    define col_3/display 'OBS' style(column)=[width=1in] center flow;    define col_32/display 'CHG'  style(column)=[width=1in] center flow;    define col_4/  style(column)=[width=1in] center flow;       break after _PB_page/page ;     compute after vorder;       line '^S={font_face=arial font_size=1pt}';    endcomp;    compute after _page_/ style={bordertopcolor=black bordertopwidth=1 just=l font_face='Courier New' font_size=8pt};     line "&foot1.";     line "&foot2.";    endcomp;   run; ods _all_ close; ods listing; ... View more

Hi, I am creating a report for a table I made and I can't seem to figure out how to customize it so that the margins on either side of the table are smaller. As of now, the columns are not fitting on one page because the table is so small sitting in the middle of the page. My current code is this:   options nodate nonumber center Orientation=landscape topmargin=.5in bottommargin=.4in leftmargin=.5in rightmargin=.5in; ods listing close; ods escapechar='^'; ods rtf file="C:\Users\Kristina.Mardinian\Desktop\TABLE2.1.1KM.pdf"  ; 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)=[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 roworder rowlabel ("X^(N=&N1.)" col_1 col_12) ("Y^(N=&N2)" col_2 col_22) ("Total^(N=&N3)" col_3 col_32);    define _PB_page/group noprint;    define vorder/order noprint;    *define visorder/order noprint;    define roworder/order noprint;    define rowlabel/display '' style(column)=[width=1.5in] flow;    define col_1/display  'OBS' style(column)=[width=1.4in] center flow;    define col_12/display 'CHG' style(column)=[width=1.4in] center flow;    define col_2/display 'OBS'  style(column)=[width=1.4in] center flow;    define col_22/display 'CHG'  style(column)=[width=1.4in] center flow;    define col_3/display 'OBS' style(column)=[width=1.4in] center flow;    define col_32/display 'CHG'  style(column)=[width=1.4in] center flow;       break after _PB_page/page ;     compute after vorder;       line '^S={font_face=arial font_size=1pt}';    endcomp;    compute after _page_/ style={bordertopcolor=black bordertopwidth=1 just=l font_face='Courier New' font_size=8pt};     line "&foot1.";     line "&foot2.";    endcomp;   run; ods _all_ close; ods listing;   Any help is greatly appreciated! ... View more

Hi, I have a pretty dense dataset that I would like to organize so I can run proc univariate or proc freq reports on it. I would like to the first report to find the number of reads (obs) per machine per Mode. And the second report to find the number of reads per Machine per Mode per Study. So I would like to try to create a dummy variable to make that easier, I put two columns to show what I think the dummy variables should look like, but I am not sure whether this is the best way. Any advice is much appreciated!   A sample of the dataset is below:   Mode    Study   Machine             Dummy1??       Dummy2?? EN          A          M1                       EN-M1            EN-M1-A EN          A          M2                       EN-M2            EN-M1-A EN          B          M1                       EN-M1            EN-M1-B HIS         A          M3                       HIS-M3           HIS-M3-A HIS         C          M3                       HIS-M3          HIS-M3-C HIS         C          M2                       HIS-M2          HIS-M3-C MR         B          M1                        MR-M1           MR-M1-B MR         D          M2                       MR-M2          MR-M2-D MR         D          M2                       MR-M2            MR-M2-D MR         D          M3                       MR-M3           MR-M3-D ... View more

Hi, I am trying to import a csv file and this error keeps on popping up.   238  proc import out= input.x datafile= "&root\data\Input\x.csv" dbms=csv replace; 239       getnames=yes; 240       datarow=2; 241       guessingrows=200; ERROR: Import cancelled. The dataset INPUT.X is being used and cannot be replaced.   but i have been able to successfully upload other csv files with the same line of code. I've checked multiple times, the file isn't open or in use. Any help is appreciated, thank you! ... View more

I am not sure why I continue to get this error, as I have checked each dataset from Histo1 to Histo18 and ACR is numeric in all the datasets. Any help is much appreciated, thank you!   1461  Data Histo; 1462      length CR ID $12; 1463      Set HISTO1-HISTO18; ERROR: Variable ACR has been defined as both character and numeric. 1464      CR = strip(CAT("CR",strip(put(ACR,best.)))); 1465      Drop ACR; 1466  Run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.HISTO may be incomplete.  When this step was stopped there were 0          observations and 6 variables. WARNING: Data set WORK.HISTO was not replaced because this step was stopped. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.03 seconds ... View more

Hi, I am trying to create a report with specific headers. And earlier in my code I had created a variable called bigN that stored the frequencies in each group. I wanted to know whether there was a possibility in Proc Report to add that variable as a header along with the name of the treatment group. I have this so far, I am only trying it for column 1 but it isn't working correctly. Any advice is appreciated! Thank you!   proc report nowd center spanrows missing split='^' data=all      list out=test                                                                                                     style(report)=[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 roworder rowlabel col_1 col_2 col_3 col_4;    define _PB_page/group noprint;    define vorder/order noprint;    define roworder/order noprint;    define rowlabel/display id  ' ' style(column)=[width=3in] flow;    define col_1/display 'Group 1 (N = ',bign,')' style(column)=[width=1.5in] center flow;    define col_2/display style(column)=[width=1.5in] center flow;    define col_3/display style(column)=[width=1.5in] center flow;    define col_4/display style(column)=[width=1.5in] center flow; ... View more