topic Re: slope determination in Statistical Procedures

slope determination

DShah — Mon, 30 Jan 2017 16:15:40 GMT

I have a dataset in SAS. I want to calculate slope and r2 for the data in the last two columns respectively. can you please help me in writing a procedure.

Thank you in advance.

Re: slope determination

art297 — Mon, 30 Jan 2017 17:39:47 GMT

If you only need to find the linear relationship you can obtain both the R2 and slope using PROC REG (see: https://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/viewer.htm#statug_reg_sect003.htm )

e.g.:

   proc reg;
      model sum_CiS = Q;
   run;

HTH,

Art, CEO, AnalystFinder.com

Re: slope determination

DShah — Mon, 30 Jan 2017 17:22:58 GMT

Hi Art

Thank you for your reply. Is there a way to add the Slope and R2 values in the table?

Thank you!

Re: slope determination

art297 — Mon, 30 Jan 2017 18:04:05 GMT

Not sure what you're asking. Both are included in the output.

If you want them output to files, simply capture the ODS tables that contain them. e.g.:

ods output ParameterEstimates=estimates;
ods output FitStatistics=stats;
/* ods trace on; */
proc reg data=have;;
  model sum_CiS = Q;
run;
/* ods trace off; */

I commented out the ods trace on and off statements as they are only used to find out what ods output tables are available.

Art, CEO, AnalystFinder.com