Hi, I am trying to figure out how to get the delta symbol and a superscript for one of my column headers to display in my proc report output, but I can't seem to get this to work. This is what I have so far. Any help is greatly appreciated!   options nodate nonumber center Orientation=landscape topmargin=.5in bottommargin=.4in leftmargin=.5in rightmargin=.5in; ods listing close; protectspecialchars=off; 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);    define _PB_page/group noprint; ... View more

Hi, I am working with two datasets (x and y) and I would like to exclude all observations that are in dataset Y from dataset X. For example, my datasets look like this   Dataset X                        Dataset Y ID     Value                        IDNUM 1         25                               2 2         30 3         50   I would like to find a way where I can tell SAS that I want observations for ID 2 to be deleted from dataset X, but the ID variables are also named differently. Any advice on where to start and how to go about this would be very helpful! Thank you! ... View more

I am trying to upload an excel file that is located in the Input folder on a server. For some reason though, every time I try to import it, it remaps the path to the Prog folder instead. Any help is greatly appreciated. Thank you!         91   %let input1=&root\data\Input; 92   %put input1=&input1; input1=\\SERVER.XX.COM\E\PROJECT WORK\FULL SERVICE\YY\STAT\data\Input 93   libname input1 "&input1"; NOTE: Libref INPUT1 was successfully assigned as follows:       Engine:        V9       Physical Name: \\SERVER.XX.COM\E\PROJECT WORK\FULL SERVICE\YY\STAT\data\Input 94   proc import out=input1.PP datafile='E\Project Work\Full Service\YY\STAT\Blinded\TFL\Data\Input\PP.xlsx' dbms=xlsx replace; 95       getnames=yes; 96   run; ERROR: Physical file does not exist, \\server.xx.com\E\Project Work\Full Service\YY\STAT\Prog\E\Project Work\Full Service\YY\STAT\Data\Input\PP.xlsx. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time):       real time           0.17 seconds       cpu time            0.00 seconds ... View more

Hi, I am working with a dataset that looks like this   Subject    Base1 Base2 CHG1 CHG2   VisitID 1                4           5                                  1 1                4           5         2            3         2 2                4           5                                  1 3                4           5                                  1   I'd like to create a new dataset from this data where I can isolate the CHG variables without losing Subject 1 VisitID 1 observation, so that it would look like this   Subject    Base1 Base2 CHG1 CHG2   VisitID 1                4           5                                  1 1                4           5         2            3         2   Any help would be much appreciated. Thank you! ... View more