BookmarkSubscribeRSS Feed
Melk
Lapis Lazuli | Level 10

I have a single group with incidence pre and post some intervention. The populations are different pre and post but I am not sure how to account for this in my analysis.

5 REPLIES 5
ballardw
Super User

What type of analysis are you actually attempting - research question to answer?

And some example data might help, replace anything sensitive with different values like xxxx, yyyy or similar.

 

Melk
Lapis Lazuli | Level 10

Research question is: is the intervention effective in reducing the number of injuries?

 

I have data from 5 different counties, with the populations pre-intervention and post-intervention, along with the incidence of injuries pre and post intervention as well.

ballardw
Super User

Do you want to know about each county or the data overall?

Is the population in the same data set as the incidence rate?

Do you have a variable that indicates whether a value is pre or post?

 

If you had posted some example data these questions would not be needed.

 

McNemar's test is sort of designed or a 2x2 table. is your data in form conducive to that? That would tend to look like

When  value

 

Pre      count yes

pre       count no

Post    Count yes

Post    count no

 

Also there are number of procedures that will do that test, or similar? Which one have you mind?

 

Melk
Lapis Lazuli | Level 10

Sample data:

 

ID       Time      Count     Total

1          pre         3           1200

1          post        5           1300

2          pre         0           1250

2          post        3           1310

..

 

 

I want to do by both county and overall. The event is very rare, I wondered if an exact poisson would be appropriate but we cannot use the repeated statement with an exact poisson. Any advice would be helpful.

rsanchez87
Obsidian | Level 7

Hi, I am looking to understanding the change pre-post for a single group as well. 

 

Here is my data: 

SRCCOUNTAGE0_10MEMCOUNTPERCENT_SRC
POST1879401716691.3377
PRE69560683298.2174
POST18794116288.6623
PRE695611241.7826


These are dependent samples. The category being evaluated is AGE0_10 (age between 0 and 10) in the pre-period and post-period. 

 

As you can see there is a 7% increase from pre-perod (2%) to the post-period (8%)

 

This is the code i wrote: 

 

ODS HTML CLOSE; ODS HTML;
PROC FREQ DATA = AGE0_10_SUM ORDER = DATA; 
WEIGHT MEMCOUNT;
TABLES AGE0_10*SRC / AGREE; 
TITLE "AGE0_10"; 
RUN;
;QUIT;

 

 

Which is giving me a p-vale <0.0001 ---> I believe this is wrong. The change may be significant, but not at this magnitude. 

 

Can you advise how to set up the summary table, I have subject level details. 

 

Thank you.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 594 views
  • 2 likes
  • 3 in conversation