| %npcttab: 24Jan10: compskip= and associated parameters added from %unicatrep
%npcttab, %unicatrep: 24Jan10: PDF output created separately due to problems with column width control %npcttab: 24Jan10: Variable _combtext2 added for better style=3 ODS indentation of the combined categories %unicatrep: 23Jan10: ODS column width adjusted and font_face_stats changed to Times %npcttab: 23Jan10: A few %unistats ODS parameters now implemented in %npcttab %unistats: 23Jan10: font_face_stats changed to Times %unicatrep: 13Jan10: Call to tfmacro made earlier in the macro so that the addition of a pvalue variable can be detected %fixnames: 24Nov09: New macro added to fix UTF-8 characters in peoples names %vwlist, %liblist: 24Nov09: New macros to list views in a library and to list libraries added %npcttab: 15Nov09: Warning message about BY variable length avoided and truncation of high level term avoided for ODS output %compvars: 14Nov09: New macro added to report on the differences between the presence of variables in two datasets %missvars: 11Nov09: Global macro variable names for list of variables now fixed as _nmiss_ and _nonmiss_ %npcttab: 08Nov09: New parameter pageon= added to allow paging to be incremented based on the highest level variable and its values %unistats: 07Nov09: New parameter pageon= added to allow paging to be incremented based on byrowvar= values %unistats, %unicatrep: 04Nov09: odsdpalign= parameter added such that ODS non-listing output no longer aligned on the decimal point.. Stats font changed to Arial from Courier %unistats: 03Nov09: Paging now achieved using <p> or <pg> in variable list. Parameters page1vars-page9vars removed. %lstattrib: 24Oct09: New utility macro added that writes the attributes of a dataset as LENGTH and ATTRIB code %dosfilesize: 12Oct09: Macro %qdosfileinfo called instead of %dosfileinfo %unistats, %unipvals, %scanlog,%pagexofy, %npcttab, %openrep, %closerep: 12Oct09: Calls to %dequote changed to calls to %qdequote due to macro renaming %proginfo, %jobinfo, %openrep, %closerep: 12Oct09: Call to %readpipe changed to call to %qreadpipe due to macro renaming %qdosfileinfo: 12Oct09: Name changed from %dosfileinfo to %qdosfileinfo %qreadpipe: 12Oct09: Name changed from %readpipe to %qreadpipe %qgetenv: 12Oct09: Name changed from %getenv to %qgetenv %qdequote: 12Oct09: Name changed from %dequote to %qdequote %unicatrep: 10Sep09: asis=on put into effect for columns %unistats, %npcttab: 10Sep09: %unquote() used with %dequote() %words: 01Sep09: Use of countw() function discontinued %npcttab, %unistats, %unicatrep: 30Aug09: odsescapechar= parameter added %unistats, %unicatrep: 27Aug09: statstfmacro= and odstrtvarlist= parameters added. compskip=yes is now the default (for ascii output compskip=no is enforced) %unistats, %unipvals: 23Aug09: statsopdest= processing changed to ODS style, moved into %unistats and removed from %unipvals %unipvals: 21Aug09: Bug while using missing character response variables with CHI/Fisher test fixed %unistats, %unicatrep: 02Aug09: pvalcolw=8 parameter added %unipvals: 15Jul09: If total treatment arms for a by group is less than two then do not calculate p-values %unistats, %npcttab: 13Jul09: New parameter listallparams= added %unistats, %npcttab: 12Jul09: New parameter dsparam= added %npcttab, %unistats, %unicatrep: 11Jul09: odstfmacro= parameter added %unipvals: 10Jul09: Bug with CHI/Fisher test selection in case when missing values are present fixed %unicatrep: 10Jul09: topline=yes now activated in macro code if not specified %npcttab: 10Jul09: Ascii output always created separately from ODS output and new parameter odstrtlabel= added. prerepcode= and postrepcode= renamed to odsprerepcode= and odspostrepcode= %unipvals, %unistats: 06Jul09: Bug with misspct=no not being passed through to %unipvals for correct handling fixed %unicatrep, %unistats: 04Jul09: New parameter odstrtlabel= added %unicatrep: 03Jul09: Ascii output always created separately from ODS output %unistats, %unicatrep: 22Jun09: prerepcode= and postrepcode= renamed to odsprerepcode= and odspostrepcode= %unicatrep: 22Jun09: topline processing changed %npcttab: 18Jun09: tfmacro= parameter added %unistats, %unipvals: 18Jun09: tfmacro= parameter now passed through to %unicatrep if called %unipvals: 17Jun09: Stats procs now not called if treatment arm count < 2 in all cases %unipvals: 12Jun09: Incorrect variables in _dummypval fixed %mvarvalues: 11Jun09: New macro to accept a list of macro variable names and to display each with its resolved value on a separate line in the log %mvarlist: 11Jun09: New macro to return a list of macro variables with a given scope %globlist: 10Jun09: Changed to a shell macro %unistats, %unicatrep: 01Jun09: prerepcode= and postrepcode= parameters added %npcttab: 11May09: prerepcode= and postrepcode= parameters added %unistats, %unipvals: 05Mar09: Changes made to avoid "uninitialized" messages %unistats, %unipvals: 03Mar09: glmlsmeans= and odstblname= parameters added %rannomac: 02Jan09: All filled-shape macros now do a two pass draw and %box now works like the other filled-shape macros for version 2.0 %scanlog: 01Jan09: %unquote() the %dequote()ed filename %dequote: 01Jan09: Use %qtrim() instead of %quote() %rannomac: 01Jan09: %text macro changed to allow a sas variable name for the font= parameter %npcttab: 16Nov08: Default style changed from 3 to 1 and some variables increased in length. Truncation of terms for style=3 bug fixed. %getenv: 01Nov08: New macro added to get contents of environment variable %readpipe: 31Oct08: Major update for version 2.0 %unistats, %unicat2word: 12Oct08: _varlabel and _tempstr2 length increased to 256 %words: 26Sep08: Sysfunc call to "countw" used for sas version 9 or later %npcttab: 11Sep08: Bug with font parameters not being resolved fixed %unicatrep: 11Sep08: font_weight_stats=medium is now the default set in the code %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 |