Dear Team, I am working on a C-SAT data where there are 2 outcome : SAT(9-10) and DISSAT(1-8). I have approx. 22 predictor variables most of which are categorical and some have more than 10 categories. As with Linear regression we can VIF to test the multicollinearity in predcitor variables. While searching from SAS forum itself i realized we can use "influence" as a measure but that helps with outliers. Moreover from this post https://communities.sas.com/t5/SAS-Statistical-Procedures/Outliers-and-Multicollinearity-for-Regression/m-p/286569#M15175- there is a link explaining the diagnostics however i do not understand the outcome in detail. Is there any other approach.   Also can we use stepwise/forward/backward regression to remove non signifincant predictors at a given p value. Kindly advice. Attached is the data for reference. I am using Base SAS. Regards, Shivi ... View more

Dear All, We are in the process of finalizing a BI tool for our client. Currently in the process of compairing VA and Tableau. As we are looking at more than just basic visulization which Tableau offers whereas VA has more depth. However when i spoke with the Sales guy from my region he educated me on what all the tool could offer but i still have doubt. Hence i would request the forum to please suggest to what extent we can perform text minining, correlations, clustering, regression with VA. Kindly note that we are not looking at SAS Visual Statistics because that would only inflate our cost. Regards. ... View more

Dear Team,    i am working on a survey data and need to run a chi square test to see if there is any relation between gender and rating.    As one of the assumption of Chi Square is : Sample Size: each particular scenario (cell) must have at least five cases. However as i have very less data points hence this assumption is violated.  We can run a fisher exact test in this scenario though while researching i came across a literature from "Wai Wan Tsang and Kai Ho Cheng" from the Univeristy of The University of Hong Kong" that we can still run a chi square test.    I am a bit confused and while searching this on researchgate. net this option was suggested hence checking on the forum if this is still a valid test to conduct.    Regards, Shivi ... View more

Dear Team ,   I have recently started working on a new survey data which has data points for the last 1 year. The customers can rate us on a scale ranging from 1-10 where 1 being the lowest and 10 being excellent.   I have performed the EDA/ descriptive part of the contributing variables as to which are most prominent, region level, day of the month etc and other variables and have come up with a list of most significant variables.    Now i am not sure how to perform a prediction based on these as it is the first time i am working on a survey data. One option i can think of is creating clusters from these variables however then the same has already been achieved using the freq tables.    Can we run a logistic regression on these 8-9 predictor variables i have and the outcome var i.e. C-sat can be categorized in 3 levels similarly we have for the NPS scores say multinomial logistic regression.    Any thought & inputs would be of great help.    Regards, Shivi ... View more