| %unistats, %unicatrep: 03Aug08: font_weight_stats=medium is now the
default
%unicatrep: 31Jul08: Checking added for font weights, font style and rules value %complibs: 15Jul08: Major enhancement to allow full comparison of text field differences %partialdates: 07Jul08: New macro added for handling partial dates %agedec, %mtype: 06Jun08: New macros added %unistats, %unicatrep: 02Jun08: spanrows= parameter added %unistats, %unicatrep: 18May08: Extra compskip= parameters added %unicatrep: 14May08: cellwidth applied to "indent" column %unistats, %unicatrep: 13May08: More ODS parameters added %unipvals: 12May08: Syntax error in "ods listing close" fixed %unipvals, %unistats: 12May08: byvars2= parameter added %unistats, %unicatrep: 12May08: More ODS parameters added %unistats, %unicatrep: 11May08: More ODS parameters added %unistats, %unicatrep, %npcttab: 09May08: font=face_stats=, font_face_other= and font_weight_other= parameters added %unistats: 07May08: filtercode= parameter added %nobs and %nlobs: 07May08: A where clause modifier is now accepted and %nobs and %nlobs will now work on views %npcttab: 02May08: dsdenom= , denomshow= , pctcompress= and byrow= parameters added for v8.0 %popfmt: 02May08: Variable name "total" changed to "_total" %unistats: 02May08: dsdenom= and denomshow= parameters added and glmopdest= replaced by statsopdest= %npcttab: 26Apr08: Duplicate style 3 label parameter removed %unistats and %npcttab: 26Apr08: Notice is given that these macros (and their sister macros) are NO LONGER SUPPORTED for free users %popfmt: 26Apr08: freesuff= parameter added %unicatrep: 26Apr08: "flow" option added to byrow columns %npcttab: 26Apr08: A new style (style=3) has been added and this is now the default %scanlog: 20Apr08: New macro added %unistats: 20Mar08: Where paired stats are both missing then change to a space and show no delimiters %nodata: 19Mar08: "nowd" option added to "proc report" call %unistats and %unicatrep: 19Mar08: trtvarlist= parameter added %unistats, %unicatrep, %npcttab: 15Mar08: odslisting= parameter added to allow user to specify file= %unistats: 13Mar08: Mispelling of SKEWNESS corrected in code %rannomac: 11Mar08: New annotate macro %fillbar added %rannomac: 06Mar08: New annotate macros %drawline and %bigbox added %rannomac: 05Mar08: Defaults changed to font=' ', color=' ' and height=. for %text macro %rannomac: 04Mar08: Keep list added to %dclannovars macro %rannomac: 01Mar08: New macro added that works like %annomac but suitable for patient profiles %unistats: 24Feb08: byvars= list generated if this is null yet byrow*= parameters used. Numeric pvalue merged on the first of a paired stat rather than the second %unistats: 15Feb08: Paired stats spaces now controlled by "^" character in the delimiter which will be translated into a space %unistats: 10Feb08: mincolw= parameter added %unicatrep: 10Feb08: Column layout bug fixed %unicatrep and %unistats: 09Feb08: compskip=no is now the default %unicatrep and %unistats: 03Feb08: More byrow*= parameters added %unicatrep: 02Feb08: byrow*= parameters added plus other changes %unistats: 02Feb08: Paired stats labels such as "Min;Max" allowed and other parameters added for this v5.0 release %xl2sas: 02Feb08: New macro added for reading html spreadsheets %unimap: 27Jan08: Upgraded to handle "paired" stats labels such as Min;Max %npcttab: 27Jan08: print=no logic changed so that other ods outputs are still available %unistats, %unipvals and %npcttab: 27Jan08: trtlabel= set to null by default and odshtmlcss= and odscsv= parameters added %unistats: 26Jan08: Bug fixed for handling formats such as $3. in %cat call %unipvals: 26Jan08: Wrong p-value displayed for centre effect bug fixed and Fisher or chisq settings now override adjcntrvar= %removew: 26Jan08: compbl bug fixed where string is null %unistats: 20Jan08: Decimal places shown for kurtosis and skewness made the same as for STD. %unistats and %unipvals; 19Jan08: All variables in input dataset are kept and passed to %unipvals %unipvals and %unistats: 19Jan08: GLM override parameter values can be enclosed in single quotes to reference macro variables such as &trtvar (will resolve to the treatment variable) and &respvar (will resolve to the response variable) %unistats and %unipvals: 14Jan08: GLM override parameters added (more to do) %unistats and %unipvals: 13Jan08: CMH processing added for categorical variables to compensate for centre effects %unistats and %unipvals: 13Jan08: cntrwarn=processing changed %unistats and %unipvals: 08Jan08: Added parameters for warning of centre effects %unistats and %unipvals: 07Jan08: Added parameters to test for the homogeneity of variances and to use the Welch test %unistats and %unipvals: 06Jan08: Added parameters errortype= , modelform= and dsmodelanova= for adjustment for centre effects %unistats and %unipvals: 06Jan08: Added parameters adjcntrvar= and glmopdest= for adjustment for centre effects for t-test and F-test calculations %unistats: 05Jan08: Decimal point alignment bug fixed in "fillstr:" routine %unistats: 31Dec07: Bug with NMISS format where decimal points adjusted by variable "/--" modification fixed %unistats: 31Dec07: Mapping of statistic labels to keywords and formats displayed in log. All keywords starting STD will have the stdfmt= format applied. %unimap: 31Dec07: Extended list of statistics keywords to match all those listed in sas v9.1.3 documentation %unimap: 30Dec07: Added "MISSING" to map to NMISS keyword %unistats: 30Dec07: NMISS now uses the same format used by N %unistats: 30Dec07: Bug with _popfmt_ always being used as a label for transposed treatment arm variable fixed. %npcttab: 10Nov07: Bug in handling non-user formats (such as $200.) assigned to level variables fixed %unistats and %npcttab: 30Sep07: Default changed to topline=no to suit ODS output %unistats: 24Sep07: Added parameters tfmacro= and pvalues=yes to allow user to define a macro to create titles and footnotes able to use the p-values set up in global macro variables. %unistats and %unicatrep: 21Sep07: Added parameters odsrtf=, odshtml=, odspdf= and odsother= parameters to pass through ODS statements to the "proc report" step. %unistats: 18Sep07: Added unicatstyle= parameter so that when unicatstyle=2 you get a column report rather than an indented report plus a varw= parameter to define width of the first column for this style of report %unistats and %unicat2word: 16Sep07: New macro %unicat2word added plus added wordtabdest= and wordtabdlim= parameters in %unistats for creating cell tables for inclusion into a word processor to be converted into in-text tables %unistats and %npcttab: 16Sep07: Added out= parameter to allow keeping the output dataset created by "proc report" %now: 07Sep07: Simple macro added that returns the current timestamp added %unistats and %npcttab: 01Sep07: pctwarn= parameter added to check for percentages > 100.01 %removew: 10Aug07: New macro added many macros added: 31Jul07: All macros have been consolidated into the macro library stored on the Spectre web site many macros: 30Jul07: Header tidy and commercial macro versions now free versions alltitles: 29Jul07: Explanation of how to edit it to fit your program naming conventions added %dosfileinfo, %dosfilesize: 22Jul07: Two sasautos macros added for extracting DOS file information prefix: 22Jul07: New script added to prefix all the items in a list. Works the same way as the script "suffix" crtitlesds, crtitlesds_win: 20Jul07: Added calls to "lisremap" and "lisremap_win" lisremap, lisremap_win: 20Jul07: New scripts added to list the output file name remapping specified in "lisfile:" .titles entries alltitles: 20Jul07: If there are no *.titles files then assume ALL.TITLES was created by another means and exit crtitlestmpl: 20Jul07: Mention "label:" and "lisfile:" in the generated header for the titles template %closerep: 19Jul07: Fixed the free version 4.0 of %closerep so it can pick up different donelist temporary file names as set up in "makerun" and "makexrun" by reading the environment variable DONELIST makerun, makexrun: 19Jul07: Set up system environment variable DONELIST to contain the name of the donelist temporary file so that %closerep can use it %crtitlesds, %proginfo, %closerep: 19Jul07: Added handling for the lisfile output lis name alltitles: 19Jul07: Updated to copy across "lisfile:" lines in titles members to ALL.TITLES showtitles, showtitles_win: 19Jul07: Updated to display lisfile name as stored in titles dataset otherwise as derived if "lisfile" variable is blank or missing makerun, makexrun, makemyrun: 19Jul07: Updated to use the "intitlis" script instead of the "intitlabels" script intitlis, intitlis_win: 19Jul07: New scripts added to replace "intitlabels" and "intitlabels_win" makexrun, bigxps, bigxlis: 15Jul07: New scripts added to handle "extra analysis" program run and output collection makerun, alltitles: 15Jul07: Added ability to store titles of "extra analysis" programs that start with "x" in the titles dataset but to exclude them from the script "runreports" created by "makerun". %lcralign: 01Jul07: New macro added crprottmpl: 25Jun07: Extra "Pagemac : pagexofy" line added to define the macro used to add "Page x of Y" labels %crprotds, %protinfo, %closerep: 25Jun07: Allows you to define a replacement for the %pagexofy macro for special handling of the output file to enable you to add extra titles and footnotes and so break the 10 titles, 10 footnotes limit. %unistats: 28May07: Version 4.6 Allows you to define variable labels to the varlist= parameter and allows you to force numeric processing on numeric variables with a user format applied by specifying the /n flag. %noquotes, %quotescan and %quotecnt: 28May07: Added to macro library for %unistats variable label processing 26MAY2007 - SPECTRE 2.2 RELEASED %npcttab and %unistats: 17May07: further checking of pctfmt= value added pagexofy: 16May07: "A0"x and not "FE"x substituted with a space %unicatrep and %pagexofy: 16May07: "FE"x no longer treated as a space %npcttab and %unistats: 16May07: pctfmt=5.1 added so percent format can be changed %windex: 10May07: added break-loop-on-match processing %npcttab: 03May07: pctsign=no added so display of percent sign can be forced %unistats: 02May07: pctsign=no added so display of percent sign can be forced %popfmt: 02May07: brackets=yes parameter added so users can suppress (N=xxx) round brackets %npcttab: 30Mar07: Bug fixed in handling trtlabel and toplabel 24MAR2007 - SPECTRE 2.1 RELEASED (THE WINDOWS UPDATE RELEASE) %unistats, %unicatrep and %pagexofy: 24Mar07: "A0"x used instead of "FE"x for decimal point alignment so no more "þ" characters will appear in %unistats output. %unistats and %unicatrep: 23Mar07: Removed 3 character limit for catnfmt= so that a category "n" of thousands or greater can be used %npcttab: 21Mar07: Added support for the "nocenter" option %unicatrep: 21Mar07: Added support for the "nocenter" option %unipvals: 21Mar07: Updated to cancel format attached to the _pvalue variable %unimap: 21Mar907: Added mapping of S.E.M. (standard error of the mean) %unistats: 21Mar07: Fixed "extra line" problem of merging pvalues on top of categories plus added support for S.E.M. (standard error of the mean) %unistats: 20Mar07: Handling of character treatment arms debugged %popfmt: 20Mar07: Creation of _nX_ variables dropped as being too messy %pagexofy: 19Mar07: macro now allows for two part page labels such as "Seite x" and "(SEITE X)" %unistats: 19Mar07: parameter dpalign=yes added to make it possible to disable the addition of the special character that the macro uses for decimal point alignment 19Mar07: %mkformat, %hasvars, %match, %hasvarsc and %hasvarsn added to macro library in preparation for CDISC reporting %pagexofy: 15Mar07: Now checks to make sure "Page x of Y" style has 4 parts showme: 15Mar07: Made a bit more Wordpad friendly %unistats: 12Mar07: Default now pctcalc=pop instead of pctcalc=cat due to the macro's strong connection with %popfmt 10MAR2007 - SPECTRE 2.0 RELEASED (THE WINDOWS RELEASE) pagexofy: 07Mar07: This script has now been replaced by the %pagexofy macro so is now just a utility script getfields: 04Mar07: This script added to display client/office/drug/study/increment that must be tailored for each site All: 02Mar07: many scripts and macros changed so that "der." is replaced by "&_ptlibref_.." _ptlibref_ must be set up in the allocation macros to say which libref the "protocol" and "titles" datasets are located. This makes the installation process for both Unix and Windows easier as edits are avoided. makerun: 27Feb07: Cygwin emailing fixed (ssmtp must be installed) SPECTRE ON WINDOWS: 25Feb07: Initial release. Uses Cygwin. PDF creation and emailing from Spectre scripts not done yet. makerun: 25Feb07: generation of "runreports" script changed to use "rm" for deleting report program output instead of the safer "rem" to look for group permission before deletion. %proginfo: 21Feb07: made Windows compliant %layout2lsps: 21Feb07: new macro added for Windows compliancy dirtree: 18Feb07: new script to display directory structure with indents from current directory downwards sasb: 17Feb07: Made Windows compliant and now calls "scanlogs" instead of "sc" due to Cygwin command conflict sc: 17Feb07: "sc" has been renamed to "scanlogs" due to Cygwin command conflict %openrep: 16Feb07: Made Windows compliant %closerep: 16Feb07: Now writes to "donelist.tmp" rather than "donelist.txt". Made Windows compliant makerun: 16Feb07: "donelist.tmp" processing added and updated for "donepages" script donepages: 16Feb07: Changed to take a donelist file as the first parameter %jobinfo: 13Feb2007: Made Windows compliant. All Macros: 13Feb2007: "MACRO CALLED" messages added before macro definition for all sas macros to put name of macro called and the version of the macro in the sas log. SPECTRE ON WINDOWS: 05Feb07: Start of project to port Spectre onto Windows Phase I (uses Cygwin Linux emulator). ddiff: 24Nov2006: A check was added to make sure a file of the same name exists in the target directory and no comparison will be done unless that is the case. Fixed on 24Nov2006. ddiff: 13Nov2006: File permissions can prevent temporary files from being overwritten so these are now deleted at end of every iteration. Fixed on 13Nov2006 %unistats: 09Oct2006: Problem detected with fmtord. not found messages. Fixed on 09Oct2006 %unipvals and %unistats: Sometimes a p-value can not be calculated due to unusual circumstances and to avoid macro crashes if these datasets are not found then %unipvals now sets up dummy p-value datasets. %unistats has a pvalmisstxt=" n/a" added so that missing p-values from the dummy datasets can be given a suitable text form. Updated 23Sep06 %unistats: 26Aug2006: nopctcatlist= parameter added. Version incremented from 3.0 to 3.1 %unistats: 21July2006: bug associated with lowercasing _statlabel when set to &misstxt. Fixed on 22Jul06 %unistats: 11July2006: _statord=1 instead of _statord=5 used to match p-value to category. Search for "RRB002" in the code to see where change was made. Fixed on 11Jul06 %unipvals: 10Jul06: "missing" option added to "proc freq" tables statements so it could calculate p-values based on missing values passed to it by the %unistats macro. %unistats: 10Jul06: misspct=yes was having its displayed percentage blanked out. Fixed on 10Jul06. %unistats: 06Jul06: catn= setting caused macro to crash. Fixed on 07Jul06. 16MAY2006 - SPECTRE RELEASED |