I have some footnote text that I want to add to a table, but I am using at least 1 of 5 set footnotes as follows: %let note1=Adverse event monitoring for treatment-emergent ~{super 99m}Tc-etarfolatide adverse events commences with dosing of ~{super 99m}Tc-etarfolatide and continues for 4 days.; %let note2=Adverse events reported as 'possibly', 'probably' or 'definitely' related to investigational agent that occur beyond the 4-day reporting window are included in the ~{super 99m}Tc-etarfolatide safety reporting analyses.; %let note3=Patients are counted once for each system organ class and for each preferred term.; %let note4=Drug-related adverse events include those possibly, probably or definitely related.; %let note5=Adverse events are coded in accordance with MedDRA v.15.1 Dictionary.; I then use the footnotes in a macro call as follows: %aeoutput(file=DR_SER, tnum=14.3.5, ttitle=%str(Frequency Table of Drug-Related Serious Adverse Events), foot1=%str(&note1.), foot2=%str(&note3.), foot3=%str(&note4.), foot4=%str($note5.), whr=%str(ec20ae=1 & serious=1 & relate in (3,4,5)), label=%str(Drug-Related Serious Adverse Event)); I have noticed that whenever I reference notes 2 or 4 that I get an error message in the log. ERROR: all positional parameters must precede keyword parameters. I have a feeling that it has something to do with the word "or" that occurs in each of those notes.  Is SAS trying to interpret that as an or ("|") operator?  If so, does anyone know of a work-around method to avoid this error message? ... View more

I have 2 tables that have nothing in common, but I want to merge them together.  I think an illustration will work better than trying to explain it: Table 1 ID 0001 0002 0003 0004 0005 0006 Table 2 Color Red Yellow Green Desired Table ID Color 0001 Red 0001 Yellow 0001 Green 0002 Red 0002 Yellow 0002 Green 0003 Red 0003 Yellow 0003 Green 0004 Red 0004 Yellow 0004 Green 0005 Red 0005 Yellow 0005 Green 0006 Red 0006 Yellow 0006 Green ... View more

I have two libraries that I want to combine into a single library.  I completed this task as follows: proc datasets;       copy in=safety out=dsur; quit; proc datasets;       copy in=demog out=dsur; quit; All the datasets copied over just fine.  However, I noticed that after running the first PROC, all the formats in the DSUR library are present.  Then when I run the second PROC, all the formats from SAFETY are replaced by all the formats in DEMOG.  In other words, I am getting all the desired datasets, but I am only getting formats from the last library copied over.  Is there some kind of option that will not overwrite existing formats? The formats are not even named the same, by the way.  SAFETY has Action, Ctcgrd, Outcome, Relate, and Serious.  DEMOG as Cancertp, Ctry, Ethnic, Gender, and Race.  If that information helps at all. ... View more

I am trying to add a simple summary line to my report.  I am sure this will be an easy fix. I have a list of races and counts per race.  I want to add a line that says "Total" in the race column and the sum of the counts in the count column.  I also want that total line to be bold.  Here is what I have attempted.  I can't get the "Total" text to appear, and I don't know where to start to make it bold. data race;       input race $ count;    flag='x';       cards; White    1006 Asian    28 Black    98 Other    4 Unknown  20 ; run; proc report data=race nowindows;       column flag race count;       define flag / group noprint;       define race / display left 'Racial Group';       define count / sum 'Number of Subjects';       break after flag / summarize;       compute after flag;        race='Total';       endcomp; run; Desired outcome: Racial Group Number of Subjects White 1006 Asian 28 Black 98 Other 4 Unknown 20 Total 1156 ... View more

If I were to run the following code: libname data1 'C:\mydata\data1'; libname data2 'C:\mydata\data2'; options fmtsearch=(data1.formats data2.formats); then I can open any tables within the DATA1 or DATA2 libraries that have pre-defined formats assigned to variables. However, if I were to later run a different program with the following code: libname data3 'C:\mydata\data3'; options fmtsearch=(data3.formats); and then attempt to go back to open a table from either DATA1 or DATA2, then I would get the following error message in a pop-up box: "ERROR: Unable to open the table DATA1.TABLE1. Data1.Table1 cannot be opened.  Do you want to select a different table to open?" Is there a way to quickly see which library format catalogs are active without taking the time to open the desired table, get the error message, close the empty table that appears, resubmit the FMTSEARCH= options, and reopen the table?  It would be much easier to view active library format catalogs, resubmit the FMTSEARCH= options if needed, and open the desired table.  I hope this makes sense! ... View more

I am using the ROUND() function.  Is there a way to get SAS to display the trailing zeros to the specified number of decimals?  For example, if I were to use ROUND(var,.01) and the value of var is 10.999, then I would hope to see 11.00 rather than just 11. ... View more