DATA Step, Macro, Functions and more

how to do sas analysis for cost distribution within test score quintile

Reply
Super Contributor
Posts: 336

how to do sas analysis for cost distribution within test score quintile

An HR company wants to see how much it costs for a new hired employee and its relationship between the cost and the scores of tests he took during the interview.

The cost is not normally distributed. Skewed. The correlation is low. Now I need to explore distribution of cost within each test quintile. Mean, median, inter-quartile ranges.

 

Trusted Advisor
Posts: 2,113

Re: how to do sas analysis for cost distribution within test score quintile

I guess that I would first divide the test scores into quintiles using PROC RANK and then do boxplots to describe the data.  If you have different dimensions of test scores, you might be able to put together a two-dimensional array of box plots, but that might be hard to view.

Super Contributor
Posts: 336

Re: how to do sas analysis for cost distribution within test score quintile

I did rank but it is only one variable. Now I need to see how one variable distribution among groups of another variable. You are right, it is hard to see. And I do not know how to do box plot for two variables

I used KS method. Kolmogorov–Smirnov test . but I do not know how to interpret the SAS output. Anyone has advice? Thanks. Or is there a better way to see?

Ask a Question
Discussion stats
  • 2 replies
  • 171 views
  • 0 likes
  • 2 in conversation