Clinical trial publications frequently allocate at least one of the allotted tables to summarize the demographics, stratification factors, and other variables of interest of the patients involved with the study. These tables generally include basic distribution information such as frequencies, means, medians, and ranges while also comparing these distributions across a key factor, such as treatment arm, to determine whether there was any imbalance in patient populations when doing analysis. These distributions are not difficult to compute and combine into a table, but as treatments become more specific to patient characteristics such as genetic biomarkers and tumor stages there is a need to be able to display the distributions in subgroups. The macro %TABLEN is a tool developed to compute distribution statistics for continuous variables, date variables, discrete variables, univariate survival time-to-event variables, and univariate logistic regression variables and combine them into a table for publication. %TABLEN has multiple features for comparisons, subgrouping, and outputting to multiple destinations such as RTF and PDF. The macro %TABLEN is a valuable tool for any programmer summarizing patient level data. ... View more

I am running some codes repeatedly. It was OK. Somehow somewhere it pops out a warning " Unable to restore 'Stat.Reg.NObs' from template store!“.   Anyone knows how to deal with this? I donot like to reboot the SAS, and too much need to redone.    16203 %put "between &stind.+&stoff. and &endind.-&endrange."; "between 5050+50 and 5583-40" 16204 ods exclude all; 16205 ods output ParameterEstimates = _index_avg_parms; 16206 proc reg data=&ds.(where=(ind between &stind.+&stoff. and &endind.-&endrange.)); 16207 by tick; 16208 model _ret_t=ind; 16209 run; ERROR: Unable to restore 'Stat.Reg.NObs' from template store! NOTE: The SAS System stopped processing this step because of errors. WARNING: Output 'ParameterEstimates' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. NOTE: PROCEDURE REG used (Total process time): real time 0.07 seconds cpu time 0.03 seconds 16209! quit; 16210 ods exclude none;   ... View more

In SAS Viya, when running code in SAS Studio, the automatic macro variable _SASPROGRAMFILE contains the full path (or URI) of the program file. However, when running the same program using the VS Code SAS extension, _SASPROGRAMFILE resolves to the filename only, without the directory path. Is there a way to determine the full path of the program file when running from VS Code? Does SAS Viya expose this information through any existing environment variable, or other macro variable? Any hints or recommended approaches? ... View more

A new update is available for Base SAS , version 9.4_M9 : Hot Fix: P7F014 - Published 05JAN1926 , Download link for P7F014 Component name: Base SAS Related SAS release: SAS 9.4   Issues addressed in P7F014 KB0043945 The data step EXIST() function might return incorrect results when you test for views This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for P7F014   Note: A comprehensive list of all SAS hot fixes is available from support.sas.com. You can use the SAS Hot Fix Analysis, Download, and Deployment (SASHFADD) tool to manage your SAS hot fixes. ... View more