topic Re: Self-Service Import of a Microsoft Excel File in New SAS User

Self-Service Import of a Microsoft Excel File

ashasupriya — Thu, 22 Aug 2019 19:19:06 GMT

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

Re: Self-Service Import of a Microsoft Excel File

ballardw — Thu, 22 Aug 2019 19:27:18 GMT

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.

Re: Self-Service Import of a Microsoft Excel File

ashasupriya — Thu, 22 Aug 2019 19:28:41 GMT

Thank you for your quick response.

Re: Self-Service Import of a Microsoft Excel File

Kurt_Bremser — Thu, 22 Aug 2019 19:29:24 GMT

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