Hi, I'm trying to get the percentages of women that had a screening mammogram by county using Behavioral Risk Factor Surveillance System (BRFSS, a large survey performed by the Centers for Disease Control and Prevention) data. This is the code I'm trying to use: proc surveyfreq data=tmp; strata _ststr; cluster _psu; weight _llcpwt; tables fips*mam/or; run; I'm confident the strata, cluster, and weight statements are correct. The issue seems to be in the tables statement, specifically with using the county in the cross tabulation. "fips" refers to the county code (e.g. 22001, 22003, etc. - there's 64 different counties in the state of interest), and "mam" refers to if the woman had a mammogram or not (1=yes, 2=no, 9=unknown). Can someone tell me why I can't seem to run this code (it just keeps running)? And how I could do this analysis? Amanda ... View more

Hi, I'm trying to take data that's in this form: County FIPS Survey Question 22001 1 (yes) 22001 1 (yes) 22001 2 (no) 22001 1 (yes) 22003 9 (refused) 22003 1 (yes) 22003 1 (yes) 22005 1 (yes) 22005 2 (no) And get summary statistics (percent that said no for each county) in this form: County FIPS Percent No 22001 25% 22003 0% 22005 50% I've tried using PROC FREQ in various ways to create different outputs, but I'm not getting this simple and straightforward output - County and % No. I would greatly appreciate any guidance or suggestions. Amanda Sorry, error in original second table ... View more

Hi, I have a .txt file that looks like this: Advanced Breast Center|Carr.   14 KM 72.2|Plaza Milliangie||Cayey|PR|00736|787738-8077|787735-0718 Advanced Diagnostic Imaging Center, LLC|1728 Village Park Dr.|||Orangeburg|SC|29118|803536-1106|803535-6033 Advanced Diagnostic Radiology, LLC|952 Seton Dr.|||Cumberland|MD|21502|301777-3522|301777-1902 Advanced Imaging|35 Batavia City Centre Main St|||Batavia|NY|14020|585345-9729|585345-9823 So it looks like it is "|" delimited, and I also have this information- Fields Name and Field Length: Facility Name 75 Address 1 50 Address 2 50 Address 3 50 City 50 State 2 Zip Code 15 Phone 50 Fax 50 How can I import this into SAS? ... View more

Hi, I have a dataset that looks like this: ID       Type     Provider 01       CBE          A     01       Mam         A 01       US            B 01       Biopsy       B I want it to look like this: ID     CBE     Mam     US     Biopsy 01       A          A         B         B Any suggestions how to do this? Amanda ... View more