Hi all could please help for below question, I have a .xlsb file containing one lakh records in that few of the records of a particular variable has above 500 characters towards bottom of the file, but i could read only up to 250 characters using proc import, how do I read the complete 500 characters? In simple terms the how to increase the length of the particular record up to 500? I have tried SCANTEXT, GETNAMES, but nothing worked. Please help me. Sample program which I have tried. proc import datafile=work.abc DBMS=excelcs replace out="C:\Users\work\Desktop\abc.xlsb"; sheet='Repayment'; getnames="yes"; scantext="yes"; run;
... View more