cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BruceBrad
‎10-14-2025
  • 248 Posts
  • 21 Likes Given
  • 4 Solutions
  • 50 Likes Received

Re: proc model f-test standard error

by Lapis Lazuli | Level 10 in SAS Procedures
‎11-12-2014 07:02 PM
‎11-12-2014 07:02 PM
The test statement in proc model (as in other SAS procs) is for testing constraints on the parameters of the model - not for testing characteristics of the variables themselves. The most straightforward way to test for the equality of standard deviations would be with proc ttest. ... View more

Re: Missing Values in significant Variable in Model

by Lapis Lazuli | Level 10 in SAS Procedures
‎11-11-2014 11:37 PM
‎11-11-2014 11:37 PM
There is no agreed threshold. If you are doing a regression-type model, and the missing value is a RHS variable, then one common work-around is to add 'missing' as a separate variable. More specifically, if your missing variable is categorical, you will be adding in dummy variables for each category. You can then just have another category 'missing'. If the missing varialbe is continuous, then you can code missing values to some arbitrary value (eg zero) and also include an additional dummy variable equal to one if the variable is missing. ... View more

Re: Native Excel output?

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎10-30-2014 07:02 PM
‎10-30-2014 07:02 PM
Any comments on how it works in 9.4M1 (or M2)? Is it worth upgrading from 9.4M0? ... View more

Native Excel output?

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎10-30-2014 12:37 AM
‎10-30-2014 12:37 AM
Are there any routines for outputting native Excel files yet? I'm running SAS 64 bit. Currently I'm using ods markup tagset=ExcelXP file="File.xls"; to send procedure output to an XML file. Is there a way to actually create a native xls and/or xlsx file from SAS? ... View more

Reporting summarised data with Proc Tabulate

by Lapis Lazuli | Level 10 in SAS Procedures
‎10-16-2014 03:06 AM
‎10-16-2014 03:06 AM
I often find that I'm drawing on the formatting features of Proc Tabulate to neatly present data which have already been summarised. That is, I just want to report single values in the table cells rather than summary statistics like the mean. I can, of course, do this by just presenting the mean (or the min, or the max etc) of the value. However, I would like to be able to double-check that I do indeed only have one value in the cell. Any suggestions on how to do this? More concretely, consider the following program which tabulates average income by sex and age. The first table works fine as a way to present these data. I'm using 'min' not because I want the minimum, but simply to report the (single) cell value. In the second table, I've introduced a mistake. I'm only tabulating by age, but there are two records in every cell in this case. What I would like would be some way to flag that the second table is not valid for my data. A crude way is to tabulate the N function for each cell and check this for all 1 s - but this produces an additional ugly table. Ideally I would like to do with an 'only' function. This would return a missing value if the values in the cell had a positive variance (or range), and would return the mean (or min or max) if the variance was zero. I don't think this is possible in SAS. Any other suggestions? Or should I use some totally different approach to tabulating already summarised data. Proc report is naturally oriented towards listing cases, but my understanding is that it doesn't have the flexibility of tabulate for rearranging row and columns. data test; input sex $ age $ avg_income; cards; M Y 100 M O 210 F Y 66 F O 33 ; run; proc tabulate data=test;   class sex age;   var income;   table min=""*avg_income*sex,age;   table min=""*avg_income*age; run; ... View more

Re: "Could not locate style reference" error

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎10-15-2014 07:30 AM
‎10-15-2014 07:30 AM
Thanks Cynthia. All sorted now. I was following an old example (from a SUGI paper I think). ... View more

Re: "Could not locate style reference" error

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎10-14-2014 10:19 PM
‎10-14-2014 10:19 PM
No. I get the same result if I add these lines. ... View more

"Could not locate style reference" error

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎10-14-2014 08:49 PM
‎10-14-2014 08:49 PM
I'm trying to define my own template. However, I'm getting some warnings when I run it. What am I doing wrong? The code and selected log output is below. Thanks CODE proc template;   define style Styles.BB1;   parent = Styles.Journal;     replace fonts /     'TitleFont'= ("Times Roman",12pt,Bold)     'TitleFont2'= ("Times Roman",12pt,Bold)     'StrongFont'= ("Times Roman",10pt,Bold)     'EmphasisFont'= ("Times Roman",10pt,Bold)     'HeadingEmphasisFont' = ("Times Roman",10pt,Bold)     'HeadingFont' = ("Times Roman",10pt)     'DocFont'  = ("Times Roman",10pt)     'footfont' = ("Times Roman",10pt)     'FixedEmphasisFont' = ("Courier",10pt,Bold)     'FixedStrongFont' = ("Courier",10pt,Bold)     'FixedHeadingFont' = ("Courier",10pt,Bold)     'BatchFixedFont' = ("Courier",10pt)     'FixedFont' = ("Courier",10pt)     ;     replace color_list /     'link' = black     'bgH' = white     'bgT' = white     'bgD' = white     'fg' = black     ;      replace Table from Output /     cellpadding = 2pt     cellspacing = 0pt     ;     replace Pages from Document /       marginleft = 16       marginright = 16       backgroundcolor = colors('bg')       pagebreakhtml = html('break')       tagattr = " onload=""expandAll()"""       liststyletype = "decimal"      ;   end; run; ods rtf file="&wealth\Wealth_trends.rtf" style=BB1; LOG OUTPUT NOTE: Overwriting existing template/link: Styles.Bb1 NOTE: STYLE 'Styles.Bb1' has been saved to: SASUSER.TEMPLAT 249  run; NOTE: PROCEDURE TEMPLATE used (Total process time):       real time           0.03 seconds       cpu time            0.01 seconds 250 251  ods rtf file="&wealth\Wealth_trends.rtf" style=BB1; WARNING: Could not locate style reference 'BB1.colors("notebg")'. WARNING: Could not locate style reference 'BB1.colors("notefg")'. WARNING: Could not locate style reference 'BB1.colors("bg")'. ... View more

Re: Formats between 32/64 bit and running without a error/warning mess...

by Lapis Lazuli | Level 10 in SAS Procedures
‎10-11-2014 12:08 AM
2 Likes
‎10-11-2014 12:08 AM
2 Likes
The method we used to manage 32 and 64 bit on windows is as follows: autoexec.sas includes the line %ProjectLocations; The ProjectLocations.sas file in the sasautos library includes code %if %sys64bit %then %let sys64bit=64; %else %let sys64bit=; Then it defines macro variables for each project folder which end in &sys64bit. These macro variables are used to the define the libnames and so we then end up with duplicate data folders for every project like K:\project1\sas K:\project1\sas64 The 32 bit users use the first folder and the 64 bit the second. When both 32 and 64 bit users are working on the same project (rare for us), they need to both run the setup programs which establish the working datasets and formats. ... View more

Re: Removing row headers in tabulate

by Lapis Lazuli | Level 10 in SAS Procedures
‎10-10-2014 07:06 PM
‎10-10-2014 07:06 PM
Thanks all. The responses which suggest using the within table statement =' ' formatting work (with or without the space in between). I thought I had tried this, but obviously not. ... View more

Re: Removing row headers in tabulate

by Lapis Lazuli | Level 10 in SAS Procedures
‎10-10-2014 05:20 AM
‎10-10-2014 05:20 AM
Tried that. If I do that, I get the variable name appearing. ... View more

Removing row headers in tabulate

by Lapis Lazuli | Level 10 in SAS Procedures
‎10-10-2014 02:07 AM
‎10-10-2014 02:07 AM
(Related to - but not the same as my other question on headers). I have data test; input v1 v2 v3; cards; 1 1 1 2 2 4 3 4 10 ; proc tabulate;   class v1 v2;   var v3;   label v1='';  /* two single quotes */   label v3='';   table min*v3*v1,v2;   run; The output I get is in the attached screenshot. In short, I get single quotes appearing for the labels for v1 and v2. How do I remove them altogether? I'm using 9.4. (If use ' ' (a space between the quotes) the variable names appear instead. I get the same result if I use double quotes). ... View more

Wrapping long row headers in tabulate

by Lapis Lazuli | Level 10 in SAS Procedures
‎10-10-2014 01:38 AM
‎10-10-2014 01:38 AM
I'm tabulating something like: class catvar1 catvar2; var contvar; label contvar "A very very very very long label"; table mean*contvar*catvar1,catvar2; Can I get the long label to wrap? I'm currently outputing to ODS RTF, where it doesn't wrap. I know that I can output to ODS markup tagset=excelXP and open the sheet up in Excel (where the labels will wrap). However, I have a lot of tables, and would prefer to go (almost) straight from SAS to a Word (or RTF) file. ... View more

Re: SAS Help configuration

by Lapis Lazuli | Level 10 in SAS Programming
‎10-09-2014 11:06 PM
‎10-09-2014 11:06 PM
I have Help and Documentation installed on the PC. ... View more

Re: SAS Help configuration

by Lapis Lazuli | Level 10 in SAS Programming
‎10-09-2014 07:01 PM
‎10-09-2014 07:01 PM
I'm using the full 9.4 (EG is installed but I'm not using it). For example, if I type 'max' (without quotes) into the quick search box in help, it is not until the 11th item that you find the basic reference to the max function. The previous references are for all sorts of subsidiary products, some of which I don't (think) I have installed. I do have a few of them installed (OR, IML, DS2) so I guess my request is really that the SAS foundation (or even Base SAS) items get precedence. Google is actually much better. Typing 'sas max 9.4' gives me the item on the max function as the first item. (4th item in Bing). ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-14-2025 05:31 PM
Likes from
Quick links