Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

☑ This topic is **solved**.
Need further help from the community? Please
sign in and ask a **new** question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 01-19-2024 05:16 PM
(504 views)

I'm performing a multivariable linear regression using PROC REG or PROC GENMOD. I want to multiply beta coefficients and 95% CIs by a given value (e.g., 10). Is there a statement (UNITS?) I can use or do I have to use a DATA step to do this?

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

@_maldini_ wrote:

Yes, multiplying the confidence limits. As an example, say I wanted standardized betas and confidence limits per the standard deviation. Or, say my independent variable was in years and I wanted to report it in decades (...a 1 unit change would be a decade, instead of a year).

For your "decade" description you would need to change the input data to the regression procedure so that the appropriate variable(s) have the desired unit and rerun the regression for this to make any sort of sense.

4 REPLIES 4

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

What exactly would it mean to multiply a CI by a given value? Do you mean the upper and lower confidence limits? What would the meaning of that result actually be?

I think you may want to provide some explanation as to what you are attempting as this brief request sounds pretty dubious as to how the result would be interpreted.

Adjusting the ALPHA= option the regression proc would yield a different set of confidence limits in a meaningful sense. Alpha= 0.1 would have 90% confidence limits and would be narrower than the default alpha=.05, or 0.01 with 99% CI would be wider. But that wouldn't effect the betas.

If I understand what you request the mechanics would be to get the values from the regression output into a data set, such as use of the OUTEST= option in proc reg, and then use a data step to modify them.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

@_maldini_ wrote:

For your "decade" description you would need to change the input data to the regression procedure so that the appropriate variable(s) have the desired unit and rerun the regression for this to make any sort of sense.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

There is no UNITS statement. You would have to use the DATA step.

It sounds like you already understand how the beta coefficients (and the CIs) are related to linear changes of scale. But if you want a review of the formulas, you can look at the section "Linear transformations of random variables" in the article "Standardized regression coefficients." That section has formulas that describe how the regression coefficients change if you perform an affine change of the dependent variable or an independent variable.

**Don't miss out on SAS Innovate - Register now for the FREE Livestream!**

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

Upcoming Events

- From Zero to SAS: Using SAS Tasks to Summarize and Manipulate Your Data | 25-Apr-2024
- Free Webinar from Michigan SAS User Group | 25-Apr-2024
- How Can You Use Deep Learning for Personalized Pricing and Revenue Optimization? | 02-May-2024
- VALSUG General Meeting | 02-May-2024
- SAS® Enterprise Guide® Is Now Integrated With SAS® Viya® 4 | 07-May-2024
- Iowa SAS Users Group: The 14th One-Day Conference | 13-May-2024
- Nebraska SAS Users Group (NEBSUG) One-Day SAS Conference | 14-May-2024

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.