BookmarkSubscribeRSS Feed
MarcoCRESPO
Calcite | Level 5

Hello. I am doing study on PCA on a survey. I was told that SAS is best used in those kinds of situations regarding PCA because it is considered powerful in running PCA. The problem is that the data has qualitative AND quantitative variables, which you also call it mixed data. Anyway I stumbled a code called PRINQUAL and I was hoping you can answer these questions:

 

1. How does the code determine that the variable is either qualitative or quantitative? 1.1 if I doesn’t determine do I need to code something first to make it note if the variables are qualitative or quantitative? Sorry if my questions sound odd I am a novice in running SAS

 

Here are my variables:

 

observation
age of respondent
Municipality
Province
SEC (SEC36)
Q3B. AGE OF RESPONDENT
Q4. COMPETITIVE FIELDS SCREENER
SEC12. GENDER
SEC14. AREA
Q69. LOCALE
SEC16. MARITAL STATUS
SEC38AB. WORK STATUS
SEC19AB. OCCUPATION OF RESPONDENT
SE22A/SEC23. EDUCATIONAL ATTAINMENT OF THE RESPONDENT
OCCUPATION BASED ON PSOC - HHH
OCCUPATION BASED ON PSOC - RESPO
OCCUPATION BASED ON PSOC - HHH/RESPO
Q7. PDM FOR HOUSEHOLD FINANCES
Q65. MONTHLY HOUSEHOLD INCOME
Q8A. ACCOUNT OWNERSHIP
Q11 (SAVINGS). PURPOSE OF ACCOUNT (SAVINGS) - Bank account
Q11 (SAVINGS). PURPOSE OF ACCOUNT (SAVINGS) - E-money account
Q11 (SAVINGS). PURPOSE OF ACCOUNT (SAVINGS) - Account with Non-Stock Savings and Loan Association
Q11 (SAVINGS). PURPOSE OF ACCOUNT (SAVINGS) - Account with Cooperative
Q11 (SAVINGS). PURPOSE OF ACCOUNT (SAVINGS) - Account with Microfinance NGOs
Q11 (SAVINGS). PURPOSE OF ACCOUNT (SAVINGS) - REGARDLESS OF PURPOSE
Q13. OTHER MEANS OF SAVINGS
Q11 (PAYMENT). PURPOSE OF ACCOUNT (PAYMENT) - Bank account
Q11 (PAYMENT). PURPOSE OF ACCOUNT (PAYMENT) - E-money account
Q11 (PAYMENT). PURPOSE OF ACCOUNT (PAYMENT) - Account with Non-Stock Savings and Loan Association
Q11 (PAYMENT). PURPOSE OF ACCOUNT (PAYMENT) - Account with Cooperative
Q11 (PAYMENT). PURPOSE OF ACCOUNT (PAYMENT) - Account with Microfinance NGOs
Q11 (PAYMENT). PURPOSE OF ACCOUNT (PAYMENT) - REGARDLESS OF PURPOSE
Q18. REASONS FOR NOT USING CHANNELS FOR TRANSACTION - REGARDLESS OF MODE
Q21. SOURCE OF CREDIT OR LOAN - Outstanding
Q21. SOURCE OF CREDIT OR LOAN - Previous
Q21. SOURCE OF CREDIT OR LOAN - REGARDLESS OF SOURCE OF CREDIT OR LOAN
Q26A. EASE OF APPLYING FOR LOANS
Q28A. DENIED LOAN
Q29A. INSURANCE OWNERSHIP
Q30A. INVESTMENT OWNERSHIP
Q36A. INCIDENCE OF SENDING MONEY IN THE P6M
Q36B. INCIDENCE OF RECEIVING MONEY IN THE P6M
Q43. CHANNEL OF PAYMENT - Taxes
Q43. CHANNEL OF PAYMENT - Licenses
Q43. CHANNEL OF PAYMENT - Purchases (food/grocery, clothes, etc.)
Q43. CHANNEL OF PAYMENT - Bills Payments (electricity, water, rent, etc.)
Q43. CHANNEL OF PAYMENT - REGARDLESS OF PAYMENT
Q46. AVERAGE AMOUNT PAID MONTHLY - Taxes
Q46. AVERAGE AMOUNT PAID MONTHLY - Licenses
Q46. AVERAGE AMOUNT PAID MONTHLY - Loan payments (loans from SSS, GSIS, PAGIBIG)
Q46. AVERAGE AMOUNT PAID MONTHLY - Contributions (SSS, GSIS, PAGIBIG, Philhealth)
Q46. AVERAGE AMOUNT PAID MONTHLY - Purchases (food/grocery, clothes, etc.)
Q46. AVERAGE AMOUNT PAID MONTHLY - Bills Payments (electricity, water, rent, etc.)
Q46. AVERAGE AMOUNT PAID MONTHLY - Loan Payment
Q46. AVERAGE AMOUNT PAID MONTHLY - REGARDLESS OF PAYMENT
Q48. PAYMENTS RECEIVED
Q49. MANNER OF RECEIVING PAYMENTS - Through my account or credit to my account
Q49. MANNER OF RECEIVING PAYMENTS - Cash
Q49. MANNER OF RECEIVING PAYMENTS - Check
Q49. MANNER OF RECEIVING PAYMENTS - REGARDLESS OF MANNER
Q50. CONSIDERATIONS IN MANNER OF RECEIVING PAYMENT - Through my account or credit to my account
Q50. CONSIDERATIONS IN MANNER OF RECEIVING PAYMENT - Cash
Q50. CONSIDERATIONS IN MANNER OF RECEIVING PAYMENT - Check
Q50. CONSIDERATIONS IN MANNER OF RECEIVING PAYMENT - REGARDLESS OF MANNER
Q52A. AWARENESS OF ACCESS POINTS
Q58A. CONTACT REGULATOR ON ISSUES - REGARDLESS OF ACCESS POINTS
Q32. P4W INTERNET USAGE
Q69. E-PAYMENT AWARENESS
Q60. RECENCY OF SCENARIO - Spent money on expensive things that you plan ahead to buy or pay for
Q60. RECENCY OF SCENARIO - Spent money to cope with the effects of expensive risks due to unexpected incidences like emergencies
Q60. RECENCY OF SCENARIO - Were unable to meet your weekly or monthly spending needs
Q60. RECENCY OF SCENARIO - Spent to start or put up a business
Q60. RECENCY OF SCENARIO - REGARDLESS OF SCENARIO
Neighborhood of respondent
Quality of outdoor of respondent
Home durability of respondent
Quality of indoor of respondent
Gender
Area
Car ownership and number
Has an aircon?
Has an electric fan?
Has an installed water heater?
Has a washing machine and spinner?
has a washing machine only?
Has a clothes dryer?
Has a radio?
Has a radio/cassette?
Has a karaoke?
Has color tv?
Has Sky Cable?
Has Destiny?
Has Home Cable?
Has other cable connection (please specify)?
Has CD only?
Has VCD only?
Has DVD?
Has Video Camera?
Has Digital Camera?
Has Camera?
Has refrigerator?
Has Freezer?
Has Microwave?
Has Range with oven?
Has Cookstop/Stove?
Has Kerosene Burner?
Has oven toaster/toaster?
Has Turbo Boiler?
Has coffee maker?
Has electric water dispenser?
Has installed water purifier?
Has not installed water purifier?
Has PC/Notebook?
Has printer?
Has Modem?
Has Home/Family computer/Play station?
Has Smartphone?
Has tablet?
Has Running water/motorized water pump with plumbing facilities?
Has running water/own water system regardless if motorized or not?
Has electricity?
Has Flush toilet?
Has electric iron?
Has Telephone?
WEIGHTS

2 REPLIES 2
PaigeMiller
Diamond | Level 26

I think PRINQUAL assumes all variables are numeric and are either continuous or ordinal. If they are categorical, you have to replace them with dummy variables that take on values 0, 1, 2, ... etc. I don't think PRINQUAL is appropriate with variables such as "Q69. LOCALE" or "Q43. CHANNEL OF PAYMENT - Bills Payments (electricity, water, rent, etc.)", which are not ordinal.

--
Paige Miller

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 533 views
  • 0 likes
  • 3 in conversation