Hello,
I prepare tables in SAS EG 4.3 to later export them to SAS. All variables are character fields.
After exporting, every cell in the excel-file automatically gets preceded by an apostrophe ( ' ).
I strongly suspect this to be problematic when importing that excel-file into another application.
I am not able to change this. Things I tried to undo this:
Can someone explain
Thank you.
Thomas
The leading apostrophe or single quote is used to signify character fields. Welcome to the wonderful world of Excel, and The Folly That Is Thinking That Excel Is Any Good For Business Intelligence.
If you remove the leading single quote, fields with numeric values will be treated as numbers in Excel (leading 0s removed etc).
Thank you. That answers my first question.
If it were possible, I'd export my SAS table directly into that other application. However, that application only welcomes excel-files.
And the main problem remains: I'm not able to remove the leading single quotes. (Or more accurate: if I remove it, Excel automatically puts it back.)
However, that application only welcomes excel-files.
Does that mean only .xls and .xlsx, or anything that is also accepted by excel, like .xml or .csv?
I can't offer a perfect fix, but you might either use the trim-function in excel (depends on your data), or export as csv and open with excel or use proc export, or in excel: "data" > "text to columns" > text qualifier = none.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.