Hi, I am working with a dataset that already has existing format names added to it. I would like to know if there is a possibility of renaming the format names.   For example, currently the format name is XX_SEG and I would like the format name to only be SEG.   I found this information online, but I am not quite sure if it is what I am looking for: http://support.sas.com/kb/22/189.html     ... View more

Hi, I am creating a table with 4 columns labeled 'Term', 'T1', 'T2' and 'T3', but for some reason the rowlabel 'Term' prints on the next line instead of in line with the other rowlabels. I have been having some issues trying to figure out why this is happening. Here is my below proc report statement, any help is much appreciated!   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 ("T1^(N=&N1)" col1) ("T2^(N=&N2)" col2) ("T3^(N=&N3)" col3) ;    define _PB_page/group noprint;    define vorder/group noprint;    define roworder/group noprint;    define rowlabel/display  ' ' left style(column)=[width=5.0in ] 'Term';    define col1/display ' '  style(column)=[width=1.0in textalign=c] ;    define col2/display ' ' style(column)=[width=1.0in textalign=c] ;    define col3/display ' ' style(column)=[width=1.0in textalign=c]  ;    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 'Version';    endcomp;   run; ods _all_ close; ods listing; ... View more

Hi,   I have this line of code that is calculating the mean of a variable. For a couple variables, the mean is a very high negative number (-0.00001) and because I only want one decimal place, SAS ends up printing the mean as -0.0. Is there a way to get rid of this negative sign   This is the code that I am using:   data statall (keep=trt_dec row1 row2 row3 row4 vid); merge sesstat(in=a) median; by vid trt_dec; if a; row1=strip(put(n,8.0)); if mean ne . then row2=strip(put(mean, 8.1))||' ('||strip(put(std, 8.2))||')'; if mean =. then row2='-'; if median ne . then row3=strip(put(round(median, .1), 8.1))||' ('||strip(put(min, 8.0))||', '||strip(put(max, 8.0))||')'; if median =. then row3='-'; row4='('||strip(put(uclm, 8.1))||', '||strip(put(lclm, 8.1))||')'; run;   Thank you, any help is appreciated! ... View more