09-01-2015
ChrisHumana
Calcite | Level 5
Member since
10-10-2011
- 5 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by ChrisHumana
Subject Views Posted 2002 10-21-2011 09:10 AM 2002 10-13-2011 07:23 AM 2002 10-11-2011 08:52 AM 2002 10-11-2011 06:22 AM 2045 10-10-2011 03:59 PM -
Activity Feed for ChrisHumana
- Posted Help with Proc Format on SAS Programming. 10-21-2011 09:10 AM
- Posted Help with Proc Format on SAS Programming. 10-13-2011 07:23 AM
- Posted Help with Proc Format on SAS Programming. 10-11-2011 08:52 AM
- Posted Help with Proc Format on SAS Programming. 10-11-2011 06:22 AM
- Posted Help with Proc Format on SAS Programming. 10-10-2011 03:59 PM
10-21-2011
09:10 AM
Hey Tom, Thanks again for your input. I see what you mean about the rounding. I have rounded all zscores to accordingly. The only reason I have missing values for some of the zscores is due to some calculations do not apply to certain providers. For example, if looking at the total charged for DME supplies not all providers have billed those supplies. Joining data back will result in no match, which I substitute with a zero to avoid math errors. I used the round function to take care of all zscore rounding. Thanks again.
... View more
10-13-2011
07:23 AM
Good point Mike. I have the zscore values set to decimal.2 so I didn't think I had to account for anything past that. I set the value of my zscore based on my formats listed below. Then I do a conversion to numeric. Then I do a final IF check before I do a sum of all my different zscore weights. Reason for that is my final data has 5390 providers in it and not all of them will have the zscore values. So when I do my final left join some of them show up as blank if they weren't in the data set joined in. The numbers weren't coming out correctly when adding a '.' into a series of integers. Setting all the blanks to zero fixed that. Here is some of my code. VALUE AVG_MBR_CHRG_ZSCORE . = 0 LOW - 1.19 = 0 1.2 - 1.5 = 1 1.51 - 2.2 = 2 2.21 <- HIGH = 3; AVG_MBR_CHRG_WEIGHT = INPUTN(PUT(AVG_MBR_CHRG_ZSCORE, AVG_MBR_CHRG_ZSCORE.), 2.); IF AVG_MBR_CHRG_WEIGHT = . THEN DO; AVG_MBR_CHRG_WEIGHT = 0; END;
... View more
10-11-2011
08:52 AM
Thanks again Tom and Ieva for responding. Everything worked as expected.
... View more
10-11-2011
06:22 AM
Thanks Tom. I didn't think of that for this particular situation. I am going to try that today. I have the zscore result set to decimal.2 so I shouldn't have to worry about extending into the 3rd decimal place. Hopefully I am not overlooking something.
... View more
10-10-2011
03:59 PM
Hello I am using PROC FORMAT to change the value of a zscore to a integer. Here is an example: VALUE AVG_MBR_CHRG_ZSCORE . = 0 LOW - 1.19 = 0 1.2 - 1.5 = 1 1.51 - 2.2 = 2 2.21< - HIGH = 3; Everything links up in my data correctly when I apply the format. For example, if the zscore is 1.25 it displays the label of 1. The problem I am having is I want to add up all the weights into a final score. It seems to be pulling from the original value versus the format label when doing the addition. Does anyone have advice or experience on how to get around this? Any help would be greatly appreciated.
... View more