topic Proc Import: xlsm variable format in SAS Programming

Proc Import: xlsm variable format

Selvan05 — Tue, 02 Jul 2019 15:07:10 GMT

Hi,

I am trying to import a .xlsm file using proc import. in my .xlsm file I have a column of type Number. but, the number is captured in Commax (Nordic format: -100.00,00).

when I run the proc import, this value is getting ignored/missing. Could you please to have a solution on this?

Thanks in advance!

br,

Selvan

Re: Proc Import: xlsm variable format

ChrisNZ — Wed, 03 Jul 2019 00:34:21 GMT

This is an ongoing problem.

Excel is just not a good data storage format.

What's really needed is a way to import everything as character strings.

In the meantime, you'll have to modify the Excel file and try to set the column as a different data type, or add a row with letters.

Re: Proc Import: xlsm variable format

Selvan05 — Wed, 03 Jul 2019 08:40:02 GMT

Thank you Chris for your reply:).