Philadelphia SSuN

December 2, 2009

Atlanta, GA

Greta L Anschuetz

Email: greta.anschuetz@phila.gov

Telephone: 215-685-6756

Address: 500 S Broad St, Philadelphia, 19146

Items of discussion

Randomization for GC interviews

Trich Summary

Challenges to date

Report created for GC data

Ranuni function of SAS®

Random number generator in SAS

Returns a random variate from a uniform distribution.

z=RANUNI(seed);

Make sure your seed is an integer.

Returns numbers from 0-1 (all are equally likely), so approximately 20% of the random numbers will be less than 0.20, thus keeping all records with a number <0.20 will be keeping 20% of the sample 

Code for Randomizationdata gcdata2;set gcdata1;if hdistno ne 'N'; /*Deleting OOJs*//*Ineligible: 1)recs rpt’ed >60 days from lab & 2)anyone under 14 years*/if (rcvdt-l1dt)>60 then eligible = 0; else if age lt 14 then eligible = 0; else eligible =1; /*Keep only eligible records*/run; data gcdata3;set gcdata2;random = ranuni(56); /*random # assigned to eligibles*/run; data gcdata4;set gcdata3;if random ge 0.0 and random le 0.20 then select=1;else select =0; /*We attempt to interview anyone with a random number between 0.0 and 0.20 – 20%*/run;

Trich data 420 Inpouch results

– 57 (13%) positive– 4 (7.8%) demonstrated in vitro resistance (of 51 tested for resistance at CDC lab)

On average, those with a positive Inpouch were 5 years older than those who tested negative.– Median age showed same results

35% of the positives vs. 21% of the negatives – had a previous history of Trichomonas.

72% (41/57) of the patients with a positive Inpouch were positive by wet mount.

GC Interviews–NETSS data formats did not match SSuN data formats

•E.g., PA state in NETSS is “42” but formatted as a character; for SSuN the format is numeric – variable has same name!•Dates are character formatted 20091203 – SSuN uses a date format

–Added geocoder to our existing database•Only able to code census tract Philadelphia addresses

–Learning Access VB scripting•Many cases have missing phone number •Created a new page to go to “clinician page”

Challenges to date

Clinic– Get new version of medical record live

Previous Medical Record New Medical RecordLive Date: 9/14/2009

Patient’s Name DOB

Example of “Clinician Page”

Report created for GC data

Work in Progress!

Auto report generated from county file sent to Darlene

Able to keep the program informed on the progress of SSuN and the data that we are getting

SAS code is adaptable if other sites would like a copy of the program that generates the report