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

[philippe777]

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 

[Kurt_Bremser]

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 

---