I am importing an Excel file to SAS; however, one of variables (often 300+ characters) is getting truncated. I want to use GUESSINGROWS, but I see that it is not compatible with Excel, only text delimited data. It is the nature of the project I am using this data for to not alter the raw data we receive--i.e., I cannot convert the file itself to a compatible format. Does anyone know how I can read in the data so this variable will not be truncated?
proc import
datafile = "&maindir.\Data\State Submissions\&year.\Raw\&state.\&stinptE."
out = part_e_imp replace
dbms = excel;
GUESSINGROWS = 3000;
run;