BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Silvertreetops
Obsidian | Level 7

Hello,

I have some survey data which includes an effort score (interger 0-5). I'd like to understand from all other information in the survey data set what other factors (any of the variables) influence that score. I'm after advice on both:

  1. The correct statistical procedure here to use; and
  2. guidance on how to do this in SAS EG (including how to account for survey weights)

could you please recommend concise resources that would help me understand how to beat do this, and interpret the results?

thank you,

silvertreetops

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

I'll make an attempt at an answer, but first I'm required to utter this disclaimer: "I am not a statistician".

With that out of the way, I can say that I've seen people use Factor Analysis (PROC FACTOR) or Principle Component Analysis (PROC PRINCOMP) to achieve what you've described.  Both of these are tasks in SAS Enterprise Guide.  Here are descriptions from the online help:

Factor analysis performs a variety of common factor and component analyses and rotations. Input can be multivariate data, a correlation matrix, a covariance matrix, a factor pattern, or a matrix of scoring coefficients.

You might want to use this task to perform a common factor analysis on an annual employee review. For example, suppose that 103 police officers were rated by their supervisors on 14 scales (variables). You can conduct a common factor analysis on these variables to see what latent factors are operating behind these ratings.

Principal component analysis is a multivariate technique for examining relationships among several quantitative variables. You should use principal component analysis if you are interested in summarizing data and detecting linear relationships.

You might use the Principal Components task when you have too many variables to plot simultaneously. For example, suppose that you have the crime rates per 100,000 people in 7 categories for each of the 50 states in 1977. Since there are seven numeric variables, it is impossible to plot all the variables simultaneously. You can use principal component analysis to summarize the data in two or three dimensions and to help you visualize the data.

Both tasks are found in the Tasks->Multivariate menu.

Chris

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

View solution in original post

2 REPLIES 2
ChrisHemedinger
Community Manager

I'll make an attempt at an answer, but first I'm required to utter this disclaimer: "I am not a statistician".

With that out of the way, I can say that I've seen people use Factor Analysis (PROC FACTOR) or Principle Component Analysis (PROC PRINCOMP) to achieve what you've described.  Both of these are tasks in SAS Enterprise Guide.  Here are descriptions from the online help:

Factor analysis performs a variety of common factor and component analyses and rotations. Input can be multivariate data, a correlation matrix, a covariance matrix, a factor pattern, or a matrix of scoring coefficients.

You might want to use this task to perform a common factor analysis on an annual employee review. For example, suppose that 103 police officers were rated by their supervisors on 14 scales (variables). You can conduct a common factor analysis on these variables to see what latent factors are operating behind these ratings.

Principal component analysis is a multivariate technique for examining relationships among several quantitative variables. You should use principal component analysis if you are interested in summarizing data and detecting linear relationships.

You might use the Principal Components task when you have too many variables to plot simultaneously. For example, suppose that you have the crime rates per 100,000 people in 7 categories for each of the 50 states in 1977. Since there are seven numeric variables, it is impossible to plot all the variables simultaneously. You can use principal component analysis to summarize the data in two or three dimensions and to help you visualize the data.

Both tasks are found in the Tasks->Multivariate menu.

Chris

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
Silvertreetops
Obsidian | Level 7

Thanks Chris,

Apologies for the slow reply - I have a look at those, they look helpful

sas-innovate-2024.png

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.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 986 views
  • 0 likes
  • 2 in conversation