GUESSINGROWS for Excel

[raivester]

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;

[SASKiwi]

Do these help? 

https://support.sas.com/kb/17/123.html

https://support.sas.com/kb/46/472.html

Does DBMS = XLSX help?

[Reeza]

Search for DBSASTYPE and using and ODBC connection instead.

[r_behata]

Have you tried :

GUESSINGROWS = MAX;

[ballardw]

---

@r_behata wrote:
Have you tried :

GUESSINGROWS = MAX;

---

Guessingrows is not a valid option for XLSX or XLS file formats. It is only valid for delimited text files.