BookmarkSubscribeRSS Feed
Liane
Calcite | Level 5

Hi.

 

I'm using the SAS Version 9.4.

I use a macro to import and export data in SAS. First I had a problem when importing data to SAS because the variables were formatted with a maximum length of "$255.", what caused the truncation of some variables and then I changed it to "$1024.".

So now I have a dataset in SAS with that variables formatted as "$1024." but when I try to export them to excel it gives me this error in SAS :"ERROR: The character variable Q422 has too long a value for the MYXLSX library."

 

So looking for ideas to solve this problem and export correctly to excel from SAS.

 

2 REPLIES 2
Cynthia_sas
Diamond | Level 26

Hi:
  Without seeing the code you're using to export (LIBNAME engine, PROC EXPORT, ODS) or seeing the data, it's hard to make a constructive comment.

  If you can post the essential part of your code and some of your data, that would be most helpful. When I try using ODS EXCEL with a very large character variable (over 3500 characters), I get everything in Excel correctly.

Cynthia

use_ods_excel_bigvar.png

I put ### at the end of the variable value so I could make sure that the whole string was put into the cell.

 

Here's how I created the data -- using a screen shot so that all 3500+ characters do not wrap funny in the forum posting -- I assume that your character data is coming from an already existing data set or database file:

make_bigvar.png

AlanC
Barite | Level 11

One other point: SAS datasets are also ODBC compliant so you can import them using Excel.

https://github.com/savian-net

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1045 views
  • 0 likes
  • 3 in conversation