SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
jjyang
Calcite | Level 5

Hello! I am having trouble figuring out how to best analyze data. First off, the data obtained was answers through surveys (and I know this isn't always the best way to get data, but we had a large population). The goal of this project was to figure out why childhood lead testing has declined in the jurisdiction I am serving. The intern before me initially sent out 919 postcards with a survey link to parents with children between 12-24 months in our area. A total of 86 parents filled out the survey that they were never asked or given the opportunity for their child to be tested. Therefore, the intern then created a LeadTool Kit intervention to give to pediatricians and families with helpful information and teaching materials. 1.5 years later, 1209 postcards with a survey link were again sent to parents with children between 12-24 months (not necessarily the same parents from the first group) to answer and determine if the Toolkit has helped increase awareness and provider practices of asking to test for childhood lead. A total of 103 parents answered (some saying they were asked and some saying they weren't). I am trying to analyze both sets of data to determine if the intervention/Toolkit in fact helped increase awareness and whether parents were asked about childhood testing in their PCP visit. What is the best way to do this? This was sort of a project that I kind of took on, so I don't know many other details. All I know is that both sample sizes (919 and 1209) are different and it is not guaranteed that the same parents answered. The cohort is similar in that postcards were sent to parents with children between 12-24 months. I have been stuck on how to  analyze this effectively and efficiently for a while, so please let me know what I should do! Furthermore, we serve 7 villages so if I could break it down further by those, that would also be helpful. I have attached a word doc below.

 

Please let me know if there are any questions! Thanks in advance!

 

Thanks! 

6 REPLIES 6
Reeza
Super User
Compare the proportion who responded as having been asked or not been asked. BUT you really don't have a large sample size, so I highly suspect your experiment is under powered here. I would not be doing anything beyond a t-test or chi square test with this amount of data.
jjyang
Calcite | Level 5
Thanks for responding! I planned on doing chi-squared but am unsure how to set it up on SAS. In regards to what you said, am I comparing who was asked VS who was not for both the pre and post-intervention groups?
Reeza
Super User
Check the PROC FREQ documentation for more details, but without any more information I can't really help with code.

I can't open attachments so not sure what's in there. If you provide sample data someone can likely help you further. Fake data is fine.
jjyang
Calcite | Level 5
What I'd really like to know is if the intervention increased the number of parents who were asked the Four Easy Questions during their child's PCP visit
Reeza
Super User
Well, I guess you start by converting that to a sas data set with the information in separate columns to be analyzed. I'm not typing out your data to work with it either, so once you have that done feel free to post back.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 2249 views
  • 1 like
  • 2 in conversation