Hello.
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.
Thanks
WHP
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 ;
value agegroup
0 - 3 = "0 to 3"
4 - 6 = "4 to 6"
7 - 12 = "7 to 12"
13 - high = "13+"
;
run;
Proc freq data=have;
tables age ;
format age agegroup. ;
run;
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.
Hello ballard.
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..
Thanks
WHP
Sorry for the misunderstanding.
I suspect finding a cut-and-paste may be difficult due to variable naming and different data sources structures.
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.
WHP
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need courses to help you with SAS Life Sciences Analytics Framework, SAS Health Cohort Builder, or other topics? Check out the Health and Life Sciences learning path for all of the offerings.