11-20-2014 10:48 AM
I am wondering if there is anyone out there that has or knows of a SAS algorithm already created to generate counts for lines and age bands for Child Health Check-ups (CHCUP) or EPSDT or CMS-416.
Any direction would be appreciated.
11-20-2014 11:28 AM
I'm not quite sure what you may mean by "lines" but for age groups one of the most flexible approaches is the creation of a custom format and Proc Freq.
assume that age is in years
proc format ;
0 - 3 = "0 to 3"
4 - 6 = "4 to 6"
7 - 12 = "7 to 12"
13 - high = "13+"
Proc freq data=have;
tables age ;
format age agegroup. ;
If you only want counts then modify the tables statement with / nopercent nocum if single variable or
/ norow nocol nopercent if crossing age with another variable.
11-21-2014 08:39 AM
Thank you for your response.
Yes I am good with the basic concept format & proc freq for age groups.
The form itself is quite extensive and requires if then else, do loops, and I imagine macros in some healthcare companies logic in order to pull and populate.
I would rather not reinvent the wheel from scratch if a version or two that I could cut and paste from specific for my medicaid population are available.
My question is really does anyone have the complete algorithm for this form, less their specific proprietary terms (blinded) etc..
11-21-2014 10:34 AM
Sorry for the misunderstanding.
I suspect finding a cut-and-paste may be difficult due to variable naming and different data sources structures.
11-21-2014 10:43 AM
No misunderstanding my friend, appreciate your input.
Yes of course, cut and paste would have many complications as you mention.
Generally you can use a find and replace with some efficiency from time to time, but will still be tedious.
Thanks for your input.