Hi,
When importing an Excel file, the excel engine multiplies by 3 the size of character variables. If we attempt to reduce the length using dbsastype= option, values get truncated.
Do you know how to avoid id or at least how to reduce the length afterwards without altering the data ?
proc export data=sashelp.class
outfile="&test./reporting/test.xlsx"
dbms=xlsx
replace;
sheet=class;
run;
libname demo xlsx "&test./reporting/test.xlsx";
*libname demo excel "&test./reporting/test.xlsx";
ods select position;
proc contents data=demo.class varnum;
run;
proc print data=demo.class;
run;
libname demo clear;
It is ok with xlsx engine (see below). I'm just trying to understand excel engine here.
... View more