topic Putting parameter estimates back in the data set when using surveyreg in SAS Programming

Putting parameter estimates back in the data set when using surveyreg

JKCho — Wed, 24 Jul 2019 17:08:44 GMT

proc surveyreg data=basu2 ;
class DR;
by sic;
model NI = R DR DR_R / clb solution;
run;

Hi all!

I can obtain parameter estimates for each group by sic as seen in the above code.

The reason why I got them is to use these parameters in another regression's independent variables. To do so, I need to put them in my data set again and merge this set to another data file and do the final regression I want.

Well.. I found how to put parmest into dataset when using PRCO REG but PROC SURVEYREG... that does not work.

ods output ParameterEstimates = parms;
   proc reg data=sashelp.baseball;
      model logsalary = nHits nBB YrMajor / clb;
      quit;
   proc print data=parms noobs;
      run;

I have tried sth similar like the above. but even code color does not turn up to blue or navy, meaning it is not a valid code... I need to use surveryreg instead of just reg as I have a dummy variable and the data is a panel.

I thank you again your help very much again!

Re: Putting parameter estimates back in the data set when using surveyreg

Patrick — Wed, 24 Jul 2019 17:14:27 GMT

ODS TRACE ON; will show you in the log what output objects with what names a procedure creates.

Re: Putting parameter estimates back in the data set when using surveyreg

Reeza — Wed, 24 Jul 2019 17:14:59 GMT

Here's some instructions and explanations on how to capture output that is shown.
https://blogs.sas.com/content/sastraining/2017/03/31/capturing-output-from-any-procedure-with-an-ods-output-statement/

@JKCho wrote:
proc surveyreg data=basu2 ;
class DR;
by sic;
model NI = R DR DR_R / clb solution;
run;
Hi all!

I can obtain parameter estimates for each group by sic as seen in the above code.

The reason why I got them is to use these parameters in another regression's independent variables. To do so, I need to put them in my data set again and merge this set to another data file and do the final regression I want.

Well.. I found how to put parmest into dataset when using PRCO REG but PROC SURVEYREG... that does not work.
ods output ParameterEstimates = parms;
   proc reg data=sashelp.baseball;
      model logsalary = nHits nBB YrMajor / clb;
      quit;
   proc print data=parms noobs;
      run;
I have tried sth similar like the above. but even code color does not turn up to blue or navy, meaning it is not a valid code... I need to use surveryreg instead of just reg as I have a dummy variable and the data is a panel.

I thank you again your help very much again!

Re: Putting parameter estimates back in the data set when using surveyreg

ballardw — Wed, 24 Jul 2019 17:23:32 GMT

@JKCho wrote:
proc surveyreg data=basu2 ;
class DR;
by sic;
model NI = R DR DR_R / clb solution;
run;
Hi all!

I can obtain parameter estimates for each group by sic as seen in the above code.

The reason why I got them is to use these parameters in another regression's independent variables. To do so, I need to put them in my data set again and merge this set to another data file and do the final regression I want.

Well.. I found how to put parmest into dataset when using PRCO REG but PROC SURVEYREG... that does not work.
ods output ParameterEstimates = parms;
   proc reg data=sashelp.baseball;
      model logsalary = nHits nBB YrMajor / clb;
      quit;
   proc print data=parms noobs;
      run;
I have tried sth similar like the above. but even code color does not turn up to blue or navy, meaning it is not a valid code... I need to use surveryreg instead of just reg as I have a dummy variable and the data is a panel.

I thank you again your help very much again!

Do NOT trust the editor code highlighting to tell you whether code is valid or not.

Did you actually run something like:

ods output ParameterEstimates = surveyparms;
proc surveyreg data=basu2 ;
   class DR;
   by sic;
   model NI = R DR DR_R / clb solution;
run;

If that does not create an output data set then show us the log.

Re: Putting parameter estimates back in the data set when using surveyreg

JKCho — Wed, 24 Jul 2019 17:48:33 GMT

I have tried similar codes you suggested and tried some codes again.

ods output ParameterEstimates = surveyparms;
proc surveyreg data=basu2 ;
class DR;
by sic;
model NI = R DR DR_R / solution;
run;

This is the code works with NO clb.
That might be the reason and, as usual, sas code does not work by a small difference.

Re: Putting parameter estimates back in the data set when using surveyreg

Reeza — Wed, 24 Jul 2019 17:52:42 GMT

CLB isn't listed as a valid option in the documentation.

It is an option for the REG procedure though. If the log didn't throw an error it should have....

Re: Putting parameter estimates back in the data set when using surveyreg

ballardw — Wed, 24 Jul 2019 17:54:55 GMT

@JKCho wrote:
I have tried similar codes you suggested and tried some codes again.

ods output ParameterEstimates = surveyparms;
proc surveyreg data=basu2 ;
class DR;
by sic;
model NI = R DR DR_R / solution;
run;

This is the code works with NO clb.
That might be the reason and, as usual, sas code does not work by a small difference.

Just because an option, such as CLB is valid for one procedure, such as REG, does not mean that it is valid in another procedure.

I would expect that the LOG showed an error that CLB was not a valid option for the Surveyreg Model statement.

Which is why we say "Read the LOG" and POST the log as well as "Read the documentation".

Using options without knowing what they do or if they are valid is a poor way to program in any language, not just SAS.

A CAT command in Unix means something quite different than a CAT command on an HP3000 or the CAT function in a SAS data step.

Re: Putting parameter estimates back in the data set when using surveyreg

Reeza — Wed, 24 Jul 2019 17:56:27 GMT

CLB does generate an error in the log when I run SURVEYREG with it.