Thank you for your reply, here's the code I used. libname final "Q:\sasData\final"; options nocenter nonumber nodate linesize=125 pagesize=4000 formchar=" " ; data brfss1; set final.brfss04_14_cdc; run; libname prelim "P:\BRFSS\data\ORIG\CDC"; data brfss2; set prelim.nm13finl prelim.nm14finl; run; data brfss3; set brfss2 (rename=(iyear = YEAR decide = _DiffDecide)); run; data brfss4; set brfss3 (keep = _DiffDecide RRCLASS2 RRATWRK2 RRCOGNT2 RREMTSM2 RRHCARE3 RRPHYSM2 YEAR SEQNO); year1 = input(year,4.0); drop year; rename year1 = YEAR; run; data brfss5; set brfss4; _RRCLASS = .; if RRCLASS2 = 6 then _RRCLASS = 1; else if RRCLASS2 = 4 OR RRCLASS2 = 5 then _RRCLASS = 2; else if RRCLASS2 = 2 then _RRCLASS = 3; else if RRCLASS2 = 3 then _RRCLASS = 4; else if RRCLASS2 = 1 then _RRCLASS = 5; LABEL _RRCLASS = "People Classify you: 1=American Indian/Alaska Native, 2=Asian/Pacific Islander, 3=Black/African American, 4=Hispanic, 5=White"; _RRCOGNT = .; if RRCOGNT2 = 6 then _RRCOGNT = 1; else if RRCOGNT2 = 5 then _RRCOGNT = 2; else if RRCOGNT2 = 4 then _RRCOGNT = 3; else if RRCOGNT2 = 3 then _RRCOGNT = 4; else if RRCOGNT2 = 2 then _RRCOGNT = 5; else if RRCOGNT2 = 1 then _RRCOGNT = 6; LABEL _RRCOGNT = "Thinking About Race: 1=Once an Hour, 2=Once a Day, 3=Once a Week, 4=Once a Month, 5= Once a Year, 6= Never"; _RRATWRK = .; if RRATWRK2 = 1 then _RRATWRK = 4; else if RRATWRK2 = 2 then _RRATWRK = 2; else if RRATWRK2 = 3 then _RRATWRK = 1; else if RRATWRK2 = 4 then _RRATWRK = 3; else if RRATWRK2 = 5 then _RRATWRK = 5; LABEL _RRATWRK = "Feel Treated at Work Due to Race: 1=Better Than Other Races, 2=Same as Other Races, 3=Worse Than Some Races, Better Than Others, 4=Worse Than Other Races, 5=Only Encountered People of The Same Race"; _RRHCARE = .; if RRHCARE3 = 1 then _RRHCARE = 4; else if RRHCARE3 = 2 then _RRHCARE = 2; else if RRHCARE3 = 3 then _RRHCARE = 1; else if RRHCARE3 = 4 then _RRHCARE = 3; else if RRHCARE3 = 5 then _RRHCARE = 5; else if RRHCARE3 = 6 then _RRHCARE = 6; LABEL _RRHCARE = "Experience at Health Care: 1=Better Than Other Races, 2=Same as Other Races, 3=Worse Than Some Races, Better Than Others, 4=Worse Than Other Races, 5=Only Encountered People of The Same Race, 6=No Health Care in Past 12 Months"; _RRPHYSM = .; if RRPHYSM2 = 1 then _RRPHYSM = 2; else if RRPHYSM2 = 2 then _RRPHYSM = 1; LABEL _RRPHYSM = "Felt Physical Symptoms Due to Race: 1=no, 2=yes"; _RREMTSM = .; if RREMTSM2 = 1 then _RREMTSM = 2; else if RREMTSM2 = 2 then _RREMTSM = 1; LABEL _RREMTSM = "Felt Emotionally Upset Due to Race: 1=no, 2=yes"; run; data brfss6 (keep = _DiffDecide _RRCLASS _RRATWRK _RRCOGNT _RREMTSM _RRHCARE _RRPHYSM YEAR SEQNO); set brfss5 (drop = RRCLASS2 RRATWRK2 RRCOGNT2 RREMTSM2 RRHCARE3 RRPHYSM2); run; data prelim.brfss; merge brfss1 brfss5; by seqno; run; I've already deleted the merge dataset file that was saved from the P drive and not by using SAS code. Yesterday like I said I had the same problem but it suddenly worked (don't have any clue how) and today I had the problem again. (FYI by not seeing the data, I mean when I double click on it from the P or Q drive; the proc print works just fine)
... View more
