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.
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
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:
One other point: SAS datasets are also ODBC compliant so you can import them using Excel.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.