|Date: ||Fri, 20 Jul 2001 11:04:41 -0400|
|Reply-To: ||Travis Folk <travisfolk@HOTMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Travis Folk <travisfolk@HOTMAIL.COM>|
|Subject: ||output file structure|
Sorry if this is a repeat (I wasn't sure if the first one went through).
I have a problem writing code to output a file so I can deal with it easily.
My knowledge in this area is sorely deficient.
I am running a multiple regression in PROC REG and am outputting the
parameter betas and the associated SE for that beta for each model. I have
7 explanatory variables and running every combination of them.
So, my SAS code looks like this (just a part of it, only one of the models):
proc reg data=const outest=parms outseb noprint;
model constr = XLOGDIST INCINIT PREFHABR/ ADJRSQ AIC;
proc append out=aicout new=parms force;
and at the very end I have:
FILENAME aicout 'c:\wood duck project\aicout.dbf';
PROC DBF DB3=aicout DATA=aicout;
FORMAT _NUMERIC_ 16.6;
And what I get is:
OBS MODEL TYPE DEPVAR . . . . AIC
1 MODEL1 PARMS CONST 219.8
2 MODEL1 SEB CONST .
(I have removed some of the output variables for brevity)
I would like to output this file in some sort of format that will put the
betas and associated SE's on the same line (i.e. one line per model
considered). Any ideas?
I am using SAS 6.12 in Windows 98.
Thanks in advance,
Travis Hayes Folk
Graduate Research Assistant
School of Forestry and Wildlife Sciences
Auburn University, AL