About rafaldow

rafaldow · ‎03-08-2019

Thanks so much for your help! The report layout is a limiting factor, but SAS's abbreviation algorithm that generates effect labels usually produces comprehensible abbreviations, so I am trying to take advantage of it. The macro initially generates a set of verbose effect labels based on full variable names expressed in the GLM model statement, along with positioning codes that describe where in the report they should be placed. It tries to then emulate SAS's abbreviated effect labels to match with the abbreviated effect labels in the SAS ODS output datasets in order to extract the associated values (parameter estimates, SEs, test statistics, pvals). The abbreviated effect labels and an extensively reformatted set of statistical values are then added to the body of the report in appropriate places (designated by the positioning codes). A comprehensive list of verbose effect descriptions and abbreviated effect names are added at the end of the report, but the abbreviated effect names are still needed in the body of the report. Also, it may not have been clear, but dependent and predictor variables for the Proc GLM Class and Model statements cannot be predicted in advance. They are input as part of the macro call.

rafaldow · ‎03-08-2019

Yes... Thank you, Paige. I realized that and setting the length to the maximum value is the interim solution I am using. It is not viable as a general solution, though, because the report layouts do not support very long effect names without incomprehensible wrapping occurring. For formatting purposes, the abbreviated effect names have substantial advantages, although I do have flexibility to adjust lengths up to about 40 or 50 characters.

rafaldow · ‎03-08-2019

I am writing a macro to create customized reports by combining output from Proc GLM ODS tables (ParameterEstimates and ModelANOVA). The report needs to accommodate not only varying numbers of main effects, but also interactions of varying orders. Processing is conditional based on effect labels for each model term, which are extracted from the ODS datasets. I realize that the Proc GLM option NAMELEN= can be used to specify the length of effect names in tables and output datasets (default=20); however, in no SAS manuals, online FAQs, or other documentation have I found a description of the algorithm used by SAS to abbreviate variable names into effect labels of the specified length. For main effect terms, the effect labels appear to be a simple truncation of the variable name if it exceeds the specified length. For interactions, though, effect labels do not appear to be simple, equal truncations of the constituent variable names; but it is not obvious what algorithm is being using to abbreviate the constituent variable names, joined by '*'s, into effect labels. This seems like such a simple problem that I must be overlooking something obvious. Any thoughts or insights would be greatly appreciated! ~ Richard

Online Status	Offline
Date Last Visited	‎10-28-2020 09:33 AM

Re: How does SAS create abbreviated ANOVA table labels?

Re: How does SAS create abbreviated ANOVA table labels?

How does SAS create abbreviated ANOVA table labels?

Re: How does SAS create abbreviated ANOVA table labels?

Re: How does SAS create abbreviated ANOVA table labels?

How does SAS create abbreviated ANOVA table labels?