Child Health Check-ups, CMS-416, EPSDT

[WHPPHD]

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

[ballardw]

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.

[WHPPHD]

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

[ballardw]

Sorry for the misunderstanding.

I suspect finding a cut-and-paste may be difficult due to variable naming and different data sources structures.

[WHPPHD]

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