cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
hayesk
‎02-12-2024
  • 8 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

How to calculate Mahalanobis distance for survey data between one part...

by Calcite | Level 5 in Statistical Procedures
‎02-12-2024 04:51 PM
‎02-12-2024 04:51 PM
Hello! I have data for a sample of 74 people who answered a 97-question assessment utilizing a likert scale. Looking at the data visually, we noticed a few responses that look like outliers/careless responses and we are considering removing them from the dataset. We want to do a formal outlier analysis to justify this. I read that Mahalanobis distance can be used to identify outliers but I don't know how to do it in SAS and with my variables. The 97-item assessment is broken up into subscales with items belonging to only one subscale. Would I calculate the means for each of the subscales and then use those values to calculate Mahalanobis' distance between the individual's mean on the subscales and the sample's means? What would the specific syntax be for this? ... View more

Re: Year showing up correctly on SAS but not in Excel export

by Calcite | Level 5 in New SAS User
‎08-19-2022 04:44 PM
‎08-19-2022 04:44 PM
Lesson learned, thanks again 🙂 ... View more

Re: Year showing up correctly on SAS but not in Excel export

by Calcite | Level 5 in New SAS User
‎08-19-2022 04:36 PM
‎08-19-2022 04:36 PM
IT WORKED!!! Thank you so much you saved me at work 🙂 ... View more

Re: Year showing up correctly on SAS but not in Excel export

by Calcite | Level 5 in New SAS User
‎08-19-2022 04:16 PM
‎08-19-2022 04:16 PM
I'm attaching the output as a document but I think you just helped me figure it out! Should I just reformat these to equal the year or use if statements or what do you recommend? ... View more

Re: Year showing up correctly on SAS but not in Excel export

by Calcite | Level 5 in New SAS User
‎08-19-2022 04:01 PM
‎08-19-2022 04:01 PM
proc export data=qd outfile='G:...' dbms=xlsx replace; run; Here's my export code, I redacted the file location and name but that would normally be there in place of the '...'.    I followed your advice and exported it as csv and then read in a text editor and the year is still showing up correctly there! Not sure where it's all going wrong ... View more

Re: Year showing up correctly on SAS but not in Excel export

by Calcite | Level 5 in New SAS User
‎08-19-2022 03:53 PM
‎08-19-2022 03:53 PM
Here is the output from the proc contents for the year variable:   Variable Type Length Format Informat Label Q2_2_Today_date_year Num 8 Q2_2_TOA.   Today's date: - Year   In Excel,  the column format just says "General" but if I change it to date then it makes it 1900. And all the values in that column are 120 or 121 as I mentioned but in SAS it shows up as the correct years (2019, 2020, 2021)     ... View more

Re: Year showing up correctly on SAS but not in Excel export

by Calcite | Level 5 in New SAS User
‎08-19-2022 03:18 PM
‎08-19-2022 03:18 PM
Hmm… the data is being downloaded from a survey on Qualtrics and the only response choices are in 4-digit numeric years. There’s also no special format Im applying to the variable. If I import the data file into SAS and immediately print the dataset, the year shows up as 2019, 2020, or 2021. Unsure how it could be importing as a 3 digit value but SAS still somehow reads the numeric value as the correct year but then it gets all messed up in the date reformatting. I’m a new user by the way so if you have any advice on how you would proceed that would be really helpful! Thanks! ... View more

Year showing up correctly on SAS but not in Excel export

by Calcite | Level 5 in New SAS User
‎08-19-2022 02:49 PM
‎08-19-2022 02:49 PM
I have a large dataset with 3 variables to comprise a date: Q2_Today_date_month, Q2_1_Today_date_day, Q2_2_Today_date_year.  The values for the month and day are showing up correctly, but the value for the year appears correct on the SAS output but after the proc export to an Excel workbook, the year changes to a 3-digit value of 120 or 121. The years should be between 2019-2021.    In SAS, the year variable is just a regular numeric variable. When I try to format it to a date, it becomes 1960. I know the year 1960 is the default SAS year but I'm confused how numeric values of 2019, 2020, and 2021 are translating to a year of 1960. I'm not sure if the solution is changing the format in Excel or in SAS since it appears correct in SAS but then gets messed up when opening the dataset in Excel. Any guidance is greatly appreciated, thanks!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-12-2024 10:02 PM
Quick links