Programming the statistical procedures from SAS

What is best approach - DV Cont and IV Ordinal

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

What is best approach - DV Cont and IV Ordinal

Hi,

I have 15 questions and each question has 4 different statuses like 0 – ‘no action’ 1 – ‘started ‘2- ‘implemented’ and 3 – ‘completed’. I'd like a good way to measure the impact of each question on our in visitors (number of visitors), and if possible apply regression.

  1. It is possible to use dummy-encoding to the ordinal variable and use regression ( 3 INV variable – 1,2,3)
  2. It is possible to output each dummies Standardized Coefficients - Beta
  3. Also get from R-squared how different independent variables (dummies) are contributing to a dependent variable ( number visiting)

Please let me know if the above makes sense

Thanks in advance.


Accepted Solutions
Solution
‎05-26-2018 11:48 AM
Occasional Contributor
Posts: 5

Re: What is best approach - DV Cont and IV Ordinal

Posted in reply to PaigeMiller

Thank you both ..

View solution in original post


All Replies
Super User
Posts: 13,500

Re: What is best approach - DV Cont and IV Ordinal

Procedure intending to use what?

 

Many of the modeling / regression procedures will allow specifying categorical variables as Class variables and handle creating/using "dummy variables" in the background.

 

Output options tend to depend on which specific procedure is used.

Occasional Contributor
Posts: 5

Re: What is best approach - DV Cont and IV Ordinal

Thanks for the reply.

The intention is - which status (driver) are contributing more on the outcome ( i.e Driver 4 - Completed).

 

In that case we were thinking to show each RSQR and Beta for each status.

 

Thanks again.

Occasional Contributor
Posts: 5

Re: What is best approach - DV Cont and IV Ordinal

Is it ok to model /regression

by question;

Model Visit = Status1 (0,1) Status2 Status3 / STB output each R..

 

In ordinal variable

 

Please let me know

 

Super User
Posts: 13,500

Re: What is best approach - DV Cont and IV Ordinal

SAS has over 20 different regression procedures.

Choice relates to type of regression wanted, data types involved and possibly sample design (surveyreg and surveylogistic.

The model statements have different options depending on specific procedure chosen.

 

What do you mean by Status1 (0,1) in that model statement?

Occasional Contributor
Posts: 5

Re: What is best approach - DV Cont and IV Ordinal

The status are ordinal VR :

Status like 0 – ‘no action’ 1 – ‘started ‘2- ‘implemented’ and 3 – ‘completed’..

 

All the 16 groups (participant) -  They have to choose one of the scores for each question (total = 15 questions)

 

I was thinking to convert the ordinal data to dummy (0, 1) - But not sure.? I see before where categorical is coded 0 and 1.

 

Ideally would like to get an idea which group (group 1 to group 16) has impact on the continuous outcome (visit)

Respected Advisor
Posts: 2,983

Re: What is best approach - DV Cont and IV Ordinal


@Diimoo wrote:

The status are ordinal VR :

Status like 0 – ‘no action’ 1 – ‘started ‘2- ‘implemented’ and 3 – ‘completed’..

 

All the 16 groups (participant) -  They have to choose one of the scores for each question (total = 15 questions)

 

I was thinking to convert the ordinal data to dummy (0, 1) - But not sure.? I see before where categorical is coded 0 and 1.

 

Ideally would like to get an idea which group (group 1 to group 16) has impact on the continuous outcome (visit)


As I explained in my above post, there is NO need to create dummy variables here. SAS will do the work for you.

--
Paige Miller
Respected Advisor
Posts: 2,983

Re: What is best approach - DV Cont and IV Ordinal

[ Edited ]

@Diimoo wrote:

Hi,

I have 15 questions and each question has 4 different statuses like 0 – ‘no action’ 1 – ‘started ‘2- ‘implemented’ and 3 – ‘completed’. I'd like a good way to measure the impact of each question on our in visitors (number of visitors), and if possible apply regression.

  1. It is possible to use dummy-encoding to the ordinal variable and use regression ( 3 INV variable – 1,2,3)

If I am understanding properly, there's no need for YOU to create dummy variables here. In most modeling procedure in SAS, such as PROC GLM or PROC PLS, you can take the variable (let's call it by the name STATUS) with the 0,1,2,3 value and place it is a CLASS statement, and then SAS will create the dummies for you internally, so you don't have to.

 

In this case, your model becomes (because you have 15 different status variables)

 

CLASS STATUS1-STATUS15;

MODEL VISITS = STATUS1-STATUS15/options ... ;

 

It is possible to output each dummies Standardized Coefficients - Beta

 

Yes, you can get coefficients for each level of STATUS.

 

Also get from R-squared how different independent variables (dummies) are contributing to a dependent variable ( number visiting)

 

There is NO SUCH THING as an R-squared for individual terms in the model; the only R-squared number you can get is for the entire model fit.

--
Paige Miller
Solution
‎05-26-2018 11:48 AM
Occasional Contributor
Posts: 5

Re: What is best approach - DV Cont and IV Ordinal

Posted in reply to PaigeMiller

Thank you both ..

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 238 views
  • 0 likes
  • 3 in conversation