Self-Service Import of a Microsoft Excel File

[ashasupriya]

Hi,

Can you please me understand what does this warning means? Is this something to do with my xls version that I have installed on my PC or SAS import?

Regards,

Asha

[ballardw · Accepted solution]

When you attempt to import data from a source that has names that do not follow SAS naming conventions such as maximum of 32 characters and only allowing underscore, letters and digits then the names get modified to match SAS limitations. Depending on options you may get characters such as spaces or ( and ) replaced with _ and the names will (currently) be limited to 32 characters.

Nothing to do with specific file sources, the character limit is in SAS.

[ashasupriya]

Thank you for your quick response.

[Kurt_Bremser]

The spreadsheets in the Excel workbook have names that are not valid as SAS names, so they need to be adapted.