Hello, I am using a PROC IMPORT OUT to read in an ecxel spreadsheet with 6 different tabs i am needing to reference.  The first 2 tabs that i am referencing has zero values in the rows on the excel doc that is causing my columns to read as character vs numeric and the other 4 tabs have values in the same columns. In my data file_1 step is where i am receiving the error saying my variables are both Character & numeric and i need to columns to be numeric. PROC IMPORT OUT= WORK.file_&filename. DATAFILE= "\File path" DBMS=xlsx REPLACE; sheet="&sheet"; GETNAMES=yes; RUN; /*proc append data=file_&filename. base=read force; run;*/ %mend; %read(File,1); %read(File,2); %read(File,3); %read(File,4); %read(File,5); %read(File,6); data xx.File_dummy_; retain Rep_assigned Date_Assigned Date_Completed Fee_Type  Fee_Amt Coverage_added_and_billed_; Format Date_Assigned Date_Completed mmddyy10.; Format Fee_Type BEST.  Fee_Amt dollar7.2; if _N_ >= 0 then delete; run; data file_1; set xx.File_dummy_  file_1; run; ... View more