* DATE: July 2011 * PROGRAM: SA_PA2010.sas * * DESCRIPTION: SAS CODE; * LEISURE-TIME PHYSICAL ACTIVITY INDICATORS (RECODES)FOR * HEALTHY PEOPLE 2010 PHYSICAL ACTIVITY OBJECTIVES. * * * Input files: SAMADULT [Sample Adult File] * * Output files: SA_ACTIVE Sample Adult dataset with physical activity recode * * Purpose: Create a recode (ACTIVE): CLASSIFY LEISURE-TIME PHYSICAL * * ACTIVITY STATUS BY REGULARITY OF VIGOROUS AND LIGHT-MODERATE * * ACTIVITY * * CREATE A DATA SET WITH THE FULL SAMPLE ADULT FILE AND RECODE * * * NOTES1: Questions are asked in the Sample Adult Core questionnaire * * Adult Health Behavior (AHB)section and have remained unchanged * * since July 1997. * * * * NOTES2: THE RECODE(ACTIVE)CREATED BELOW IS USED IN THE FOLLOWING * * NCHS REPORTS: * * "EARLY RELEASE FROM THE NHIS" THROUGH 2010, * * "HEALTH, UNITED STATES," * * "SUMMARY HEALTH STATISTICS FOR ADULTS (2007-2009) * * "HEALTH BEHAVIORS OF ADULTS" (2005-2007) * * * * NOTES3: THIS RECODE IS BASED ON THE SAMPLE ADULT CORE VARIABLES: * * VIGFREQW, VIGMIN, MODFREQW, AND MODMIN * * CATEGORIES OF LEISURE-TIME PHYSICAL ACTIVITY STATUS (ACTIVE): * * (1) REGULARLY ACTIVE [ VIGOROUS ACTIVITY 3+ TIMES PER WEEK * * FOR AT LEAST 20 MINUTES EACH TIME OR LIGHT-MODERATE ACTIVITY * * 5+ TIMES PER WEEK FOR AT LEAST 30 MINUTES EACH TIME, OR BOTH * * (2) SOME ACTIVITY [ENGAGED IN SOME VIGOROUS OR LIGHT-MODERATE * * ACTIVITY BUT ACTIVITY DID NOT MEET THE CRITERIA FOR REGULAR * * (3) INACTIVE [NEVER ENGAGED IN ANY VIGOROUS OR LIGHT-MODERATE * * ACTIVITY OR VOLUNTEERED THAT THEY WERE UNABLE TO ENGAGE IN * * THESE ACTIVITIES. * * (9)ANY INFORMATION IS MISSING FOR ANY OF THE FOUR VARIABLES * * * * NOTES4: EXAMPLE PROGRAM USES 1998 SAMADULT DATA FILE. THE PROGRAM CAN * * BE APPLIED TO ANY FULL DATA YEAR SINCE 1998 AND CAN BE MODIFIED* FOR USE WITH 1997 DATA. * **********************************************************************************; * PRELIMINARY STEPS TO USING THIS PROGRAM CODE: ***** * STEP 1: CREATE a folder on your C-drive named NHIS1998 ***** * STEP 2: DOWNLOAD SAMADULT.EXE executable data file. ***** * STORE in NHIS1998 folder. ***** * STEP 3: DOUBLE CLICK on SAMADULT.EXE to extract sequential .DAT file ***** * STEP 4: COPY SAMADULT.SAS program file ***** * STEP 5: RUN SAMADULT.SAS to create a SAS data set ***** ********************************************************************************** * NOW RUN THE FOLLOWING PROGRAM TO ADD PHYSICAL ACTIVITY (ACTIVE) RECODE to ** * the SAMPLE ADULT (SAMADULT) DATASET. SAVE RESULTING DATA SET (WITH RECODE) ** * AS A PERMANENT DATA SET IN THE NHIS1998 FOLDER: DATASET=NHIS1998.SA_ACTIVE ** * ********************************************************************************** ; LIBNAME NHIS "C:\\NHIS1998"; LIBNAME LIBRARY "C:\\NHIS1998"; Title1 "NHIS 1998 SAMPLE ADULT CORE (AHB) PHYSICAL ACTIVITY - %sysfunc(today(),MMDDYY.) %sysfunc(time(),time8.)"; RUN; PROC FORMAT LIB=LIBRARY; VALUE ACTIVE 1 = "INACTIVE" 2 = "SOME ACTIVITY, < REGULAR" 3 = "REGULARLY ACTIVE" 9 = "UNKNOWN"; run; DATA NHIS.SA_ACTIVE; SET NHIS.SAMADULT; LABEL ACTIVE = "USUAL LEISURE-TIME PHYSICAL ACTIVITY" ; IF (MODFREQW >=5 & MODFREQW <=28 & MODMIN >=30 & MODMIN <=720) OR (VIGFREQW >=3 & VIGFREQW <=28 & VIGMIN >=20 & VIGMIN <=720) THEN ACTIVE=3; /* REGULARLY ACTIVE */ ELSE IF (MODFREQW IN (0,1,2,3,4,95,96) & (VIGFREQW=. OR VIGFREQW >=97)) OR (VIGFREQW IN (0,1,2,95,96) & (MODFREQW=. OR MODFREQW >=97)) OR ((MODFREQW=. OR MODFREQW >=97) & (MODMIN=. OR MODMIN >=997)) OR ((VIGFREQW=. OR VIGFREQW >=97) & (VIGMIN=. OR VIGMIN >=997)) OR (MODFREQW >=5 & MODFREQW <=28 & (MODMIN=. OR MODMIN >=997)) OR (VIGFREQW >=3 & VIGFREQW <=28 & (VIGMIN=. OR VIGMIN >=997)) THEN ACTIVE=9; /* UNKNOWN (MISSING) */ ELSE IF (MODFREQW=95 OR MODFREQW=96) & (VIGFREQW=95 OR VIGFREQW=96) THEN ACTIVE=1; /* INACTIVE */ ELSE IF (MODFREQW=. AND VIGFREQW=.) THEN ACTIVE=9; /* NOT SAMPLE ADULT (MISSING) */ /* THIS CONDITION APPLIES ONLY WHEN PERSON FILE AND */ /* THE SAMPLE ADULT FILES HAVE BEEN MERGED */ ELSE ACTIVE=2; /* SOME ACTIVITY (LESS THAN REGULAR) */ proc contents data=NHIS.SA_ACTIVE; TITLE2 "CONTENTS: SAMPLE ADULT FILE WITH PHYSICAL ACTIVITY (ACTIVE) RECODE"; run; PROC FREQ DATA=NHIS.SA_ACTIVE; TABLE ACTIVE; FORMAT ACTIVE ACTIVE.; RUN;