Hi! I am running a written SAS codes for a report and I received errors in my log. Below is the error message and the procedure steps. Any help or suggestions will be appreciated. Thank you. 355 data combined; 356 set std_prevyr2 (Drop=patient_id morb_id address_id mmwr_week) report_dz; ERROR: Variable morb_age has been defined as both character and numeric. ERROR: Variable SURVWEB_CONDITION_ID has been defined as both character and numeric. ERROR: Variable NETSS_YEAR has been defined as both character and numeric. ERROR: Variable COUNTED_JURISDICTION_LOC_ZIP has been defined as both character and numeric. 357 format gen_rept_dt mmddyy10.; 358 gen_rept_dt=mdy(rept_month, 1,input(cats("20",mmwr_year),4.)); 359 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.COMBINED may be incomplete. When this step was stopped there were 0 observations and 131 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.00 seconds *Importing data for previous year; PROC IMPORT OUT= WORK.std_prevyr DATAFILE= "R:\morb&prevyr..xls" DBMS=EXCEL REPLACE; RANGE="MORB$"; GETNAMES=YES; MIXED=YES; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; *Reformatting month names for previous year's data; data std_prevyr2 (drop=mmwr_year); set std_prevyr; if mmwr_month='JANUARY' then rept_month=1; else if mmwr_month='FEBRUARY' then rept_month=2; else if mmwr_month='MARCH' then rept_month=3; else if mmwr_month='APRIL' then rept_month=4; else if mmwr_month='MAY' then rept_month=5; else if mmwr_month='JUNE' then rept_month=6; else if mmwr_month='JULY' then rept_month=7; else if mmwr_month='AUGUST' then rept_month=8; else if mmwr_month='SEPTEMBER' then rept_month=9; else if mmwr_month='OCTOBER' then rept_month=10; else if mmwr_month='NOVEMBER' then rept_month=11; else if mmwr_month='DECEMBER' then rept_month=12; else rept_month=.; length mmwr_year2 $4; mmwr_year2=substr(put(mmwr_year,4.),3,2); run; proc datasets lib=work nolist; modify std_prevyr2; rename mmwr_year2=mmwr_year; quit; data combined; set std_prevyr2 (Drop=patient_id morb_id address_id mmwr_week) report_dz; format gen_rept_dt mmddyy10.; gen_rept_dt=mdy(rept_month, 1,input(cats("20",mmwr_year),4.)); run;
... View more