/******************************************************************************** SAS User File for ATCPUF13 Data This file contains information and sample SAS programs to create a permanent SAS dataset for users who want to use SAS in processing the ATCPUF13 transport data file provided in this PUF release. Section A provides a sample SAS program to convert the SAS transport data file to a regular SAS dataset using the SAS procedure: CIMPORT. Section B explains format-related SAS statements that a user may optionally use when working with the SAS dataset. ******************************************************************************/ /******************************************************************************* A. A Sample SAS Program for Converting the SAS Transport File to a Permanent SAS Dataset *******************************************************************************/ LIBNAME PUFLIB 'C:\MCBS\SASDATA'; FILENAME F "C:\MCBS\DOWNLOAD\ATCPUF13.XPT"; PROC CIMPORT LIBRARY=PUFLIB INFILE=F; RUN; /******************************************************************************* The LIBNAME PUFLIB statement tells SAS the location (directory name) to store the permanent SAS dataset which is output by PROC CIMPORT. The FILENAME F statement tells SAS the location (complete directory and file name) of the input SAS transport data file. *******************************************************************************/ /********************************************************************************* B. Optional Format-related SAS Statements If a user wants to use formats for the SAS variables, a SAS format library must first be created. Below is a SAS program that will accomplish this: *******************************************************************************/ proc format LIBRARY=PUFLIB; value age2grp 1='1:Age Group <65' 2='2:Age Group [65,75)' 3='3:Age Group >=75'; value sex 1='1:Male' 2='2:Female'; value race 1='1:Non-Hispanic white' 2='2:Non-Hispanic black' 3='3:Hispanic' 4='4:Other'; value ivcore 1='1:Non-Hispanic white, < 65 years' 2='2:Non-Hispanic white, 65-74 years' 3='3:Non-Hispanic white, 75-84 years' 4='4:Non-Hispanic white, 85+ years' 5='5:Non-Hispanic black, <65 years' 6='6:Non-Hispanic black, 65-74 years' 7='7:Non-Hispanic black, 75-84 years' 8='8:Non-Hispanic black, 85+ years' 9='9:Hispanic, <65 years' 10='10:Hispanic, 65-74 years' 11='11:Hispanic, 75+ years' 12='12:Other, <65 years' 13='13:Other, 65-74 years' 14='14:Other, 75+ years'; value yesfmt 1='1:Yes' 2='2:No' .='Missing' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained' -1='Inapplicable'; value income .='Missing' -7='-7:Refused' -8="-8:Don't know" 1='1:<25000 $' 2='2:>=25000 $'; value edu .='Missing' 1='1:Less than high school' 2='2:High school or vocational, technical, business, etc' /*LM edit 12/30 and 4/8*/ 3='3:More than high school' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value marsta .='Missing' 1='1:Married' 2='2:Widowed' 3='3:Divorced/separated' 4='4:Never Married' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value genhfmt .='Missing' 1='1:Excellent' 2='2:Very good' 3='3:Good' 4='4:Fair' 5='5:Poor' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value compfmt .='Missing' 1='1:Much Better' 2='2:Somewhat better' 3='3:About the same' 4='4:Somewhat worse' 5='5:Much Worse' -9='-9: Not ascertained' -8="-8: Don't know" -7='-7: Refused'; value timefmt .='Missing' 1='1:None of the time' 2='2:Some of the time' 3='3:Most of the time' 4='4:All of the time' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value lookfmt .='Missing' 1='1:No trouble seeing' 2='2:A little trouble seeing' 3='3:A lot of trouble seeing' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value lastfmt 1='1:Never had an eye exam' 2='2:1 year to less than 2 years' 3='3:2 years to less than 5 years' 4='4:5 years or more' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained' .='Missing'; value edofmt .='Missing' 1='1:Optometrist' 2='2:Ophthalmologist' 91='91:Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hcfmt .='Missing' 1='1:No trouble' 2='2:A little trouble' 3='3:A lot of trouble' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value bmifmt .='Missing' 1='1:Underweight, <18.5' 2='2:Healthy, 18.5-<25' 3='3:Overweight, 25-<30' 4='4:Obese, 30-<40' 5='5:Extreme or high risk obesity, >=40'; value time2fmt .='Missing' 1='1:Less than 6 months ago' 2='2:6 months to less than 1 year' 3='3:1 year to less than 2 years' 4='4: 2 years or more' 5='5:Never taken' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value sitefmt .='Missing' 1="1:Doctor's office/clinic or managed care center" 2='2:Health center/clinic' 3='3:Urgent care/Hospital related facility' 4='4:V.A. facility' 5='5:Shopping mall/other store' 6='6:Other' 7='7:No Flu Shot' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value difffmt .='Missing' 1='1:No Difficulty' 2='2:Little Difficulty' 3='3:Some Difficulty' 4='4:A lot of Difficulty' 5='5:Unable to do it' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value diafmt .='Missing' 1='1:Type 1: insulin dependent, juv-onset' 2='2:Type 2: non-insulin depend, adult-onset' 3='3:Borderline' 4='4:Pre-diabetes' 5='5:Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value funlmtfmt .='Missing' 0='0:No Functional Limitations' 1='1:IADLs Only' 2='2:1 to 2 ADLs' 3='3:3 to 4 ADLs' 4='4:5 to 6 ADLs'; value adlhnm .='Missing' 1='1:1 helper' 2='2:2 helpers' 3='3:3 helpers' 4='4:4 or more helpers'; value time3fmt .='Missing' 1='1:All of the time' 2='2:Most of the time' 3='3:Some of the time' 4='4:A little of the time' 5='5:None of the time' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value felltimefmt .='Missing' 1='1:Fell 1 time' 2='2:Fell 2 times' 3='3:Fell 3 times' 4='4:Fell 4 times' 5='5:Fell 5 or more times' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value time4fmt .='Missing' 0='0:Never had blood cholesterol taken' 1='1:Less than 6 months ago' 2='2:6 months to 1 year ago' 3='3:1 year to less than 2 years ago' 4='4:2 years to less than 5 years ago' 5='5:5 or more years ago' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hypetf .='Missing' 1="1:Yes" 2="2:No" 3="3:Never told. Prior entry in error" -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value smktime .='Missing' 1='1:Less than 1 year' 2='2:1 to 9 years' 3='3:10 or more years' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value smktime2f .='Missing' 1='1:Less than 1 year' 2='2:1 to 4 years' 3='3:5 to 9 years' 4='4:10 or more years' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value smkquit .='Missing' 1='1:Yes' 2='2:No' 3='3:Never Smoke' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value drinkday .='Missing' 0='0:None' 1='1:One day a month' 2='2:Two days a month' 3='3:Three days a month' 4='4:Four days a month' 5='5:Five days a month' 6='6:Six to ten days a month' 7='7:Eleven to fifteen days a month' 8='8:Sixteen to twenty days a month' 9='9:Twenty-one to twenty-five days a month' 10='10:Twenty-six days to every day' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value drinkspd .='Missing' 1='1:Less than one alcohol drink per day' 2='2:One drink per day' 3='3:Two drinks per day' 4='4:More than two drinks per day' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value drink2day .='Missing' 0='0:None' 1='1:One day a month' 2='2:Two to five days a month' 3='3:Six days a month to every day' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hracta .='Missing' 0='0:None' 1='1:One hour per week' 2='2:Two hours per week' 3='3:Three hours per week' 4='4:Four hours per week' 5='5:Five hours per week' 6='6:Six hours per week' 7='7:Seven hours per week' 8='8:Eight to thirteen hours per week' 9='9:Fourteen hours per week' 10='10:Fifteen to twenty five hours per week' 11='11:Twenty six or more hours per week' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hractb .='Missing' 0='0:None' 1='1:One hour per week' 2='2:Two hours per week' 3='3:Three hours per week' 4='4:Four hours per week' 5='5:Five hours per week' 6='6:Six hours per week' 7='7:Seven hours per week' 8='8:Eight to nine hours per week' 9='9:Ten hours per week' 10='10:Eleven to thirteen' 11='11:Fourteen hours per week' 12='12:Fifteen hours per week' 13='13:Sixteen to twenty hours per week' 14='14:Twenty one to twenty five hours per week' 15='15:Twenty five to thirty hours per week' 16='16:Thirty one or more hours per week' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hractc .='Missing' 0='0:None' 1='1:One hour per week' 2='2:Two hours per week' 3='3:Three hours per week' 4='4:Four hours per week' 5='5:Five hours per week' 6='6:Six hours per week' 7='7:Seven hours per week' 8='8:Eight or more hours per week' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hkitfmt .='Missing' 1='1:Yes' 2='2:No' 3='3:Never given home kit to COLHKIT' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value colrecnt .='Missing' 0='0:No test done' 1='1:Less than 1 year ago' 2='2:Between 1-2 years ago' 3='3:Between 2-3 years ago' 4='4:Between 3-5 years ago' 5='5:5 or more years ago' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value whenscop .='Missing' 0='0:No colonoscopy or sigmiodoscopy' 1='1:Less than 1 year ago' 2='2:Between 1-2 years ago' 3='3:Between 2-3 years ago' 4='4:Between 3-5 years ago' 5='5:5 or more years ago' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value time5fmt .='Missing' 1='1:Less than 5 years ago' 2='2:5 to 9 years ago' 3='3:10 or more years ago'; value time6fmt .='Missing' 1='1:Less than 1 year' 2='2:1 to 4 years' 3='3:5 to 9 years' 4='4:10 to 14 years' 5='5:15 to 19 years' 6='6:20 to 29 years' 7='7:30 or more years' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hypefmt .='Missing' 1='1:One med' 2='2:Two meds' 3='3:Three or more meds' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value ctrlfmt .='Missing' 1='1:Very confident' 2='2:Confident' 3='3:Somewhat confident' 4='4:Not confident' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value time7fmt .='Missing' 1='1:Less than 1 week' 2='2:More than 1 week' 3='3:Never resumed regular activities' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value fallscale .='Missing' 1='1:Not at all afraid of falling' 2='2:A little afraid of falling' 3='3:Moderately afraid of falling' 4='4:Afraid of falling' 5='5:Very afraid of falling' 6='6:Extremely afraid of falling' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value apptfmt .='Missing' 1='1:Appointment' 2='2:Walked in' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value opdtelfmt .='Missing' 1='1:Told to come back during a prior visit' 2='2:Called for an appointment' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value appttime .='Missing' 0="0:Didn't have wait" 1='1:1 to 3 days' 2='2:4 to 9 days' 3='3:10 or more days' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value opttime .='Missing' 1='1: Up to one hour' 2='2: More than one hour' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value mdfmt .='Missing' 1='1:Primary Care' 2='2:Obstetrics/Gynecology' 3='3:Ophthalmology' 4='4:Orthopedics' 5='5:Psychiatry' 6='6:Cardiology' 7='7:Dermatology' 8='8:Urology' 9='9:Surgery' 10='10:Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value appt2time .='Missing' 0="0:Didn't have wait" 1='1:1 to 3 days' 2='2:4 to 6 days' 3='3:7 to 9 days' 4='4:10 to 20 days' 5='5:21 days or more' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value mdtime .='Missing' 1='1:0 - 60 mins' 2='2:61 - 120 mins' 3='3:121 mins or more' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value satffmt .='Missing' 1='1:Very Satisfied' 2='2:Satisfied' 3='3:Dissatisfied' 4='4:Very Dissatisfied' 5='5:No experience' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value yes2fmt .='Missing' 1='1:Yes' 2='2:No' 3='3:No experience' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value dhstfmt .='Missing' 1='1:Kept track of total medicine spending' 2='2:Info provided by the pharmacy' 3='3:Info provided by the part D plan' 91='91:Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value worry .='Missing' 1='1:Very worried' 2='2:Somewhat worried' 3='3:Not at all worried' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value truefmt .='Missing' 1='1:True' 2='2:False' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value reason1fmt .='Missing' 1='1:Not serious' 2='2:Cost too much' 3='3:Trouble finding doc' 4='4:Schedule conflict' 5='5:Doctor could not do much' 6='6:Afraid of finding out' 7='7:Insurance not accepted' 91='91:Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value reason2fmt .='Missing' 1='1:Cost too much' 2='2:Would not help' 3='3:Afraid of reaction' 4='4:Do not like to take' 5='5:Not necessary' 6='6:Not covered' 7='7:Trouble obtaining' 8='8:Used substitution' 9='9:Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value freqfmt .='Missing' 1='1:Often' 2='2:Sometimes' 3='3:Never' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value site2fmt .='Missing' 1="1:Doctor’s office group or Doctor’s clinic" 2='2:Managed care plan center/ HMO' 3='3:Other clinic (incl neighborhood family health center, rural health center, company clinic, other clinic)' 4='4:Hospital (incl. walk in urgent care, hospital ER, hospital outpatient, hospital inpatient)' 5='5:VA facility' 6='6:Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value md2fmt .='Missing' 1='1:Primary Care' 2='2:Osteopathy' 3='3:Cardiology' 4='4:Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value showfmt .='Missing' 1='1:Walking' 2='2:Driving' 3='3:Being driven' 4='4:Ambulance or other special vehicle' 5='5:Taxi' 6='6:Other public transportation' 7='7:Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value minsfmt .='Missing' 1='1:0 to 15 mins' 2='2:16 to 30 mins' 3='3:31 to 59 mins' 4='4:60 to 119 mins' 5='4:2 hours or more' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value compnyfmt .='Missing' 0='0:No one accompanies' 1='1:Spouse' 2='2:Children' 3='3:Other' -7='-7:Refused' -8="-8:Don't know" -5='-5:Never ask again'; value time8fmt .='Missing' 1='1:Less than 1 year' 2='2:1 year to < 3 years' 3='3:3 years to < 5 years' 4='4:5 years to < 10 years' 5='5:10 years or more' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value agree .='Missing' 1='1:Strongly Agree' 2='2:Agree' 3='3:Disagree' 4='4:Strongly Disagree' 5='5:No experience' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value mcare .='Missing' 1='1:Part A or Part B only' 2='2:Part A and Part B' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value mcrhmo .='Missing' 0='0:No entitlement' 1='1:Survey data only' 2='2:CMS administrative data only' 3='3:Both survey and administrative data' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value privat .='Missing' 0='0:No entitlement' 1='1:Employer-sponsored insurance (ESI)' 2='2:Self-purchased' 3='3:Both ESI and self-purchased' 4='4:Unknown' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value public .='Missing' 0='0:None' 1='1:One or more' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value source .='Missing' 0='0:No entitlement' 1='1:Survey data only' 2='2:CMS administrative data only' 3='3:Both survey and administrative data' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value ins1type .='Missing' 0='0:Other government program' 1='1:General insurance' 2='2:Dental only' 3='3:Vision only' 4='4:LTC' 5='5:Rx only' 6='6:Dental/Vision' 7='7:Life insurance' 8='8:Cancer/Dread disease' 9='9:Military/Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hmofmt .='Missing' 0='0:No enrollment' 1='1:Some enrollment' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hmocur .='Missing' 1='1:Currently enrolled' 2='2:Not currently enrolled' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value ins2type .='Missing' 1='1:Medicare' 2='2:Medicaid' 3='3:Public plan' 4='4:Private plan' 5='5:Medicare Advantage' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value covnum .='Missing' 1='1:One person' 2='2:Two persons' 3='3:More than two persons' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value privnum .='Missing' 0='0:No private plan' 1='1:One private plan' 2='2:Two private plans' 3='3:Three or more private plans' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hhtot .='Missing' 1='1:One' 2='2:Two' 3='3:Three' 4='4:Four' 5='5:Five' 6='6:Six or more' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hh2tot .='Missing' 0='0:No one' 1='1:One' 2='2:Two' 3='3:Three or more' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hhcomp .='Missing' 1='1:No one' 2='2:Spouse only' 3='3:Spouse & others' 4='4:Children only' 5='5:Children & others' 6='6:Others only' 7='7:Non relative' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hhlt .='Missing' 0='0:No one' 1='1:One' 2='2:Two' 3='3:Three' 4='4:Four or more' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value dwelfmt .='Missing' 1='1:Single family home (one-family detached)' 2='2:Multi family dwelling (two-family or duplex, mother in law apartment)' 3='3:Apartment or condominium building/ row house or town house' 4='4:Mobile home or trailer' 5='5:Other' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value levelfmt .='Missing' 1='1:One level' 2='2:Two levels' 3='3:Three or more levels' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained' -1="-1: Inapplicable" ; value servfmt .='Missing' 1='1:All included' 2='2:Some included/some separate' 3='3:All separate' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value roomnum .='Missing' 1='1:One or two rooms' 2='2:Three rooms' 3='3:Four rooms' 4='4:Five rooms' 5='5:Six rooms' 6='6:Seven rooms' 7='7:Eight rooms' 8='8:Nine or more rooms' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value lang .='Missing' 1='1:English' 2='2:Spanish'; value proxy .='Missing' 1='1:Self' 2='2:Proxy' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value medstafmt .='Missing' 1='1:Aged' 2='2:Disabled' 3='3:Unknown' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value metro .='Missing' 1='1:Metro area' 2='2:Non-metro area'; value pdrsfmt .='Missing' 1='1:Subsidized full year' 2='2:Not subsidized' 3='3:Subsidized part year' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value ipstyfmt .='Missing' 0='0:No stay' 1='1:One stay' 2='2:Two stays' 3='3:Three stays' 4='4:Four or more stays' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value ipsty2fmt .='Missing' 0='0:No visit' 1='1:One or more visit' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value snfdayfmt .='Missing' 0='0:0 day covered' 1='1:1 day or more covered' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value ipdayfmt .='Missing' 0='0:0 day' 1='1:1 day' 2='2:2 days' 3='3:3 days' 4='4:4 days' 5='5: 5 or more days' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value ipday2fmt .='Missing' 0='0:0 day' 1='1:1 day' 2='2:More than 1 day' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value otbillfmt .='Missing' 0='0:No outpatient bill' 1='1:1 to 9 bills' 2='2:10 or more bills' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value phyclm .='Missing' 0='0:No physician claim' 1='1:1 to 9 claims' 2='2:10 to 49 claims' 3='3:50 or more claims' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value phylin .='Missing' 0='0:No physician' 1='1:1 to 9 physicians' 2='2:10 to 99 physicians' 3='3:100 or more physicians' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value phyvist .='Missing' 0='0:No office visit' 1='1:1 to 5 office visits' 2='2:6 to 10 office visits' 3='3:11 to 15 office visits' 4='4:16 to 20 office visits' 5='5:21 or more office visits' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value numclm .='Missing' 0='0:0 claims' 1='1:1 to 9 claims' 2='2:10 or more claims' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value numitem .='Missing' 0='0:0 items' 1='1:1 to 9 items' 2='2:10 or more items' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value opmdcd .='Missing' 1='1:Nondual' 2='2:Full dual' 3='3:Partial dual' 4='4:QMB dual'; value dualfmt .='Missing' 1='1:Non dual' 2='2:Part year dual' 3='3:Full year dual' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value ffsfmt .='Missing' 1='1:No FFS' 2='2:Part year FFS' 3='3:Full year FFS' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value mafmt .='Missing' 1='1:No MA' 2='2:Part year MA' 3='3:Full year MA' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value acofmt .='Missing' 1='1:Shared Savings Program ACO' 2='2:Not assigned to an ACO' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value premfmt .='Missing' 1='1:No premium subsidy' 2='2:Part year premium subsidy' 3='3:Full year premium subsidy' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value prem2fmt .='Missing' 1='1:No premium subsidy' 2='2:Not full year 100% premium subsidy' 3='3:Full year 100% premium subsidy' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value hmoyrfmt .='Missing' 1='1:less than 1 year' 2='2:1-2 years' 3='3:3 to 5 years' 4='4:6 to 10 years' 5='5:11 or more years' -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value refdif .='Missing' 1='1:Yes' 2='2:No' 3="3:N/A - haven't tried to obtain referral" -7='-7:Refused' -8="-8:Don't know" -9='-9:Not ascertained'; value opdf 1="1:OPD visit" 2="2:No OPD visit"; value mdf 1="1:MD visit" 2="2:No MD visit"; value impf 1="1: Imputed" 2="2: Not imputed"; RUN; /*************************************************************************** Below is an example of how to use the SAS formats defined by the PROC FORMAT procedure: ****************************************************************************/ OPTIONS FMTSEARCH=(PUBLIB PUBLIB.FORMATS); DATA ATCPUF13; SET PUFLIB.ATCPUF13; FORMAT IV_AGE age2grp. IV_RACE race. IV_SEX sex. D_RE_AGE ivcore. D_ARMED yesfmt. D_INCOME income. D_INC_IMP impf. D_EDU edu. D_MARSTA marsta. HLT_GENHELTH genhfmt. HLT_COMPHLTH compfmt. HLT_HELMTACT timefmt. HLT_ECHELP yesfmt. HLT_ECTROUB lookfmt. HLT_EDOCEXAM yesfmt. HLT_EDOCTYPE edofmt. HLT_EDOCDLAT yesfmt. HLT_ECATARAC yesfmt. HLT_EGLAUCOM yesfmt. HLT_ERETINOP yesfmt. HLT_EMACULAR yesfmt. HLT_ECCATOP yesfmt. HLT_ELASRSUR yesfmt. HLT_HCHELP yesfmt. HLT_HCTROUB hcfmt. HLT_HCKNOWMC hcfmt. HLT_HCCOMDOC hcfmt. HLT_FOODTRBL hcfmt. HLT_BMI_CAT bmifmt. HLT_BPTAKEN time2fmt. HLT_MAMMOGRM yesfmt. HLT_PAPSMEAR yesfmt. HLT_HYSTEREC yesfmt. HLT_DIGTEXAM yesfmt. HLT_BLOODTST yesfmt. HLT_FLUSHOT yesfmt. HLT_FLUSITE sitefmt. HLT_VACPAID yesfmt. HLT_PNEUSHOT yesfmt. HLT_EVERSMOK yesfmt. HLT_SMOKNOW yesfmt. HLT_DRQTSMOK yesfmt. HLT_DIFSTOOP difffmt. HLT_DIFLIFT difffmt. HLT_DIFREACH difffmt. HLT_DIFWRITE difffmt. HLT_DIFWALK difffmt. HLT_OCARTERY yesfmt. HLT_OCHBP yesfmt. HLT_D_HBP yesfmt. HLT_HYPETOLD hypetf. HLT_OCMYOCAR yesfmt. HLT_D_MYOCAR yesfmt. HLT_OCCHD yesfmt. HLT_D_CHD yesfmt. HLT_OCOTHHRT yesfmt. HLT_D_OTHHRT yesfmt. HLT_OCCFAIL yesfmt. HLT_D_CFAIL yesfmt. HLT_OCCVALVE yesfmt. HLT_D_VALVE yesfmt. HLT_OCRHYTHM yesfmt. HLT_D_RHYTHM yesfmt. HLT_OCSTROKE yesfmt. HLT_D_STROKE yesfmt. HLT_CANCER yesfmt. HLT_OCCANCER yesfmt. HLT_OCCSKIN yesfmt. HLT_D_CSKIN yesfmt. HLT_OCBETES yesfmt. HLT_OCDVISIT yesfmt. HLT_OCARTHRH yesfmt. HLT_OCARTH yesfmt. HLT_D_ARTHRD yesfmt. HLT_ALZDEM yesfmt. HLT_OCDEPRSS yesfmt. HLT_D_DEPRSS yesfmt. HLT_D_MENDIS yesfmt. HLT_MENDIS yesfmt. HLT_OCOSTEOP yesfmt. HLT_OCBRKHIP yesfmt. HLT_D_PPARAL yesfmt. HLT_HAVEPROS yesfmt. HLT_D_PROST yesfmt. HLT_OCCHOLES yesfmt. HLT_D_CHOLES yesfmt. HLT_FUNC_LIM funlmtfmt. HLT_D_ADLHNM adlhnm. HLT_MEMLOSS yesfmt. HLT_PROBDECS yesfmt. HLT_TROBCONC yesfmt. HLT_TIMESAD time3fmt. HLT_LOSTINTR yesfmt. HLT_LOSTURIN yesfmt. HLT_TALKURIN yesfmt. HLT_REASURIN yesfmt. HLT_SURGURIN yesfmt. HLT_FALLANY yesfmt. HLT_FALLTIME felltimefmt. HLT_EDOCLAST lastfmt. HLT_PROSSURG yesfmt. HLT_OCDTYPE diafmt. HLT_OCEMPHYS yesfmt. HLT_OCPPARAL yesfmt. HLT_BCTAKEN time4fmt. HLT_OCPARKIN yesfmt. PRV_DIDSMOKE smktime. PRV_LASTSMOK smktime2f. PRV_HAVSMOKE smktime. PRV_QUITSMOK smkquit. PRV_DRINKDAY drinkday. PRV_DRINKSPD drinkspd. PRV_FOURDRNK drink2day. PRV_D_VIGTIM hracta. PRV_D_MODTIM hractb. PRV_D_MUSTIM hractc. PRV_HYPEYRS time5fmt. PRV_HYPEHOME yesfmt. PRV_HYPEDRNK yesfmt. PRV_HYPEMEDS yesfmt. PRV_HYPELONG time6fmt. PRV_HYPEPAY yesfmt. PRV_HYPESKIP yesfmt. PRV_HYPECOND yesfmt. PRV_HYPECTRL ctrlfmt. PRV_FALLHELP yesfmt. PRV_FALLIMIT yesfmt. PRV_FALLBACK time7fmt. PRV_FALLFEAR fallscale. PRV_FALNOINJ yesfmt. PRV_FALFRACT yesfmt. PRV_FALSPRAN yesfmt. PRV_FALBRUIS yesfmt. PRV_FALCUT yesfmt. PRV_FALOTHER yesfmt. ACC_OPDMCOND yesfmt. ACC_OPDTESTS yesfmt. ACC_OPDFOLUP yesfmt. ACC_OPDCHKUP yesfmt. ACC_OPDRFRL yesfmt. ACC_OPDSURGY yesfmt. ACC_OPDPSHOT yesfmt. ACC_OPDTSHOT yesfmt. ACC_OPDPMED yesfmt. ACC_OPDOTHER yesfmt. ACC_OPDAPPT apptfmt. ACC_OPDDRTEL opdtelfmt. ACC_D_OPAPPT appttime. ACC_D_OPTIME opttime. ACC_MDSPCLTY mdfmt. ACC_MDAPPT apptfmt. ACC_MDDRTEL opdtelfmt. ACC_D_MDAPPT appt2time. ACC_HCTROUBL yesfmt. ACC_HCDELAY yesfmt. ACC_MCQUALTY satffmt. ACC_MCAVAIL satffmt. ACC_MCEASE satffmt. ACC_MCCOSTS satffmt. ACC_MCINFO satffmt. ACC_MCFOLUP satffmt. ACC_MCCONCRN satffmt. ACC_MCSAMLOC satffmt. ACC_MCSPECAR satffmt. ACC_MCTELANS satffmt. ACC_MCAMTPAY satffmt. ACC_MCDRGLST satffmt. ACC_MCFNDPCY satffmt. ACC_MCRECPLN yes2fmt. ACC_DHEVHEAR yesfmt. ACC_DHPLAN yesfmt. ACC_DHTHISYR yesfmt. ACC_DHSTART dhstfmt. ACC_DHEND yesfmt. ACC_DHWORRY worry. ACC_MCDISSFY yesfmt. ACC_MCWORRY truefmt. ACC_MCAVOID truefmt. ACC_MCSICK truefmt. ACC_MCDRSOON truefmt. ACC_MCDRNSEE truefmt. ACC_MCDRATMP yesfmt. ACC_SCRMAIN reason1fmt. ACC_PMNOTGET yesfmt. ACC_GENERRX freqfmt. ACC_MAILRX freqfmt. ACC_DOSESRX freqfmt. ACC_SKIPRX freqfmt. ACC_DELAYRX freqfmt. ACC_SAMPLERX freqfmt. ACC_COMPARRX freqfmt. ACC_NOFILLRX freqfmt. ACC_SPENTLRX freqfmt. ACC_CHAINRX freqfmt. ACC_STOPRX freqfmt. ACC_CREDRX freqfmt. ACC_NOINSRX freqfmt. ACC_PLACEPAR yesfmt. ACC_PLACEMCP yesfmt. ACC_USUALDOC yesfmt. ACC_MDSPEC md2fmt. ACC_GETUSHOW showfmt. ACC_D_GETUS minsfmt. ACC_ACCOMPUS yesfmt. ACC_D_ACCREL compnyfmt. ACC_USHOWLNG time8fmt. ACC_PREVMEDC yesfmt. ACC_USCOMPET agree. ACC_USUNHIST agree. ACC_USUNWRNG agree. ACC_USHURRY agree. ACC_USEXPPRB agree. ACC_USDISCUS agree. ACC_USFAVOR agree. ACC_USTELALL agree. ACC_USANSQUX agree. ACC_USCONFID agree. ACC_USDEPEND agree. ACC_NUSNOTSK yesfmt. ACC_NUSMOVIN yesfmt. ACC_NUSAVAIL yesfmt. ACC_NUSDIFFP yesfmt. ACC_NUSTOOFR yesfmt. ACC_NUSTOOEX yesfmt. ACC_D_MDTIME mdtime. ACC_PLACEKND site2fmt. ACC_USCKEVRY agree. ACC_MDMCOND yesfmt. ACC_MDTESTS yesfmt. ACC_MDFOLUP yesfmt. ACC_MDCHKUP yesfmt. ACC_MDRFRL yesfmt. ACC_MDSURGY yesfmt. ACC_MDPSHOT yesfmt. ACC_MDTSHOT yesfmt. ACC_MDPMED yesfmt. ACC_MDOTHER yesfmt. ACC_ACCWRITE yesfmt. ACC_ACCEXPDR yesfmt. ACC_ACCEXPSP yesfmt. ACC_ACCASKQS yesfmt. ACC_ACCTRANS yesfmt. ACC_ACCAPPTS yesfmt. ACC_ACCMORAL yesfmt. ACC_ACCDRIVE yesfmt. ACC_ACCHELP yesfmt. ACC_ACCOTHER yesfmt. INS_D_MCARE mcare. INS_D_MCRHMO mcrhmo. INS_D_PRIVAT privat. INS_D_PUBLIC public. INS_D_MCAID source. INS_PART_D yesfmt. INS_MCAIDHMO yesfmt. INS_PUBRXCOV yesfmt. INS_MTFCOVER yesfmt. INS_D_HMOCOV hmofmt. INS_D_HMOCUR hmocur. INS_MHMORX yesfmt. INS_MHMODENT yesfmt. INS_MHMOEYE yesfmt. INS_MHMONH yesfmt. INS_MHMOPAY yesfmt. INS_D_PRIVNUM yesfmt. INS_D_PRIVNUMC privnum. INS_PUBRX yesfmt. INS_PUBGEN yesfmt. INS_PRIVRX yesfmt. INS_PRIVLTC yesfmt. INS_PRIVIP yesfmt. INS_PRIVMDLAB yesfmt. INS_PRIVGEN yesfmt. INS_PRIVVIS yesfmt. INS_PRIVDS yesfmt. HOU_D_HHTOT hhtot. HOU_D_HHREL hhtot. HOU_D_HHUNRL hh2tot. HOU_D_HHCOMP hhcomp. HOU_D_HHLT50 hhlt. HOU_D_HHGE50 hhlt. HOU_DWELLING dwelfmt. HOU_HLEVELS levelfmt. HOU_HELEVTR yesfmt. HOU_HONELEVL yesfmt. HOU_HBTHLEVL yesfmt. HOU_HRAMPS yesfmt. HOU_HBATHRM yesfmt. HOU_HRAILING yesfmt. HOU_HOUSTYPE yesfmt. HOU_HPERCARE yesfmt. HOU_MEALPROB yesfmt. HOU_MAIDPROB yesfmt. HOU_WASHPROB yesfmt. HOU_HELPPROB yesfmt. HOU_TRANPROB yesfmt. HOU_RECPROB yesfmt. HOU_SERVINCL servfmt. HOU_STAYPUT yesfmt. HOU_CAREPART yesfmt. HOU_REQAGE yesfmt. HOU_PERSBATH yesfmt. HOU_PERKITCH yesfmt. HOU_OUTSTATE yesfmt. HOU_D_HHLT18 hhlt. HOU_NBRROOMS roomnum. INT_LANG lang. INT_PROXY proxy. INT_PNSPLAN yesfmt. INT_PNSPNAM yesfmt. INT_PNSPNAP yesfmt. INT_PNSPNOK yesfmt. INT_PNSPUNA yesfmt. INT_PNSPOTHER yesfmt. INT_RRECHELP yesfmt. ADM_H_ENT mcare. ADM_H_MEDSTA medstafmt. ADM_H_METRO metro. ADM_H_GHPSW yesfmt. ADM_H_PDRS pdrsfmt. ADM_H_CRED yesfmt. ADM_H_HOSSW yesfmt. ADM_H_INPSW yesfmt. ADM_H_SNFSW yesfmt. ADM_H_HHASW yesfmt. ADM_H_OUTSW yesfmt. ADM_H_PBSW yesfmt. ADM_H_INPSTY ipstyfmt. ADM_H_INPDAY ipdayfmt. ADM_H_SNFSTY ipstyfmt. ADM_H_SNFDAY snfdayfmt. ADM_H_HHAVST ipsty2fmt. ADM_H_OUTBIL otbillfmt. ADM_H_PHYCLM phyclm. ADM_H_PHYLIN phylin. ADM_H_PMTVST phyvist. ADM_H_DMECLM numclm. ADM_H_DMELIN numitem. ADM_OP_MDCD opmdcd. ADM_DUAL_FLAG_YR dualfmt. ADM_PARTD yesfmt. ADM_ACOFLAG acofmt. ADM_FFS_FLAG_YR ffsfmt. ADM_MA_FLAG_YR mafmt. ADM_LIS_FLAG_YR premfmt. ADM_PREM_AMT_YR prem2fmt. MA_MAYEARS hmoyrfmt. MA_MHREFDIF refdif. MA_MHREFPAY yesfmt. MA_MHMORX yesfmt. MA_MHMODENT yesfmt. MA_MHMOEYE yesfmt. MA_MHMONH yesfmt. MA_MHMOPAY yesfmt. MA_RECMHMO yesfmt. ACC_OPDFLAG opdf. ACC_MDFLAG mdf.; RUN;