length limit of proc export for variable label (SPSS and Excel)

philippe777 — Thu, 09 Jan 2020 12:55:35 GMT

Hi,

I am trying to export a data set from SAS to SPSS and Excel.

Everything work fine except for the length of the variable label.

SPSS is limit to 128gb in the export (it is not a SPSS limit) and for Excel this is 256 (not a Excel limit).

Here is my code.

proc export data = PH2017c
outfile="C:\Users.xlsx"
dbms=xlsx
replace;
run;

proc export data = PH2017c
outfile="C:\Users"
dbms=spss replace;
fmtlib=library.formats;
run;

Thanks

Re: length limit of proc export for variable label (SPSS and Excel)

Kurt_Bremser — Thu, 09 Jan 2020 13:06:22 GMT

I can hardly imagine anyone displaying a label with 128 billion characters. Labels are something for human consumption.

And contrary to your post, there IS a 120 character length limit on SPSS labels: https://www.ibm.com/support/pages/120-character-limitation-using-spss-adding-value-labels-syntax

@philippe777 wrote:

Hi,

I am trying to export a data set from SAS to SPSS and Excel.

Everything work fine except for the length of the variable label.

SPSS is limit to 128gb in the export (it is not a SPSS limit) and for Excel this is 256 (not a Excel limit).

Here is my code.

proc export data = PH2017c
outfile="C:\Users.xlsx"
dbms=xlsx
replace;
run;

proc export data = PH2017c
outfile="C:\Users"
dbms=spss replace;
fmtlib=library.formats;
run;

Thanks

topic length limit of proc export for variable label (SPSS and Excel) in SAS Procedures

length limit of proc export for variable label (SPSS and Excel)

Re: length limit of proc export for variable label (SPSS and Excel)