topic Re: Importing Excel files shows corrupted files again and again.. in SAS Procedures

Importing Excel files shows corrupted files again and again..

JKCho — Fri, 12 Jul 2019 21:47:41 GMT

Hello all,

Importing Excel files shows corrupted files again and again..

I matched the bitness of my SAS and the Office to 64 bit and uninstall and reinstall SAS, the Office, and the SAS Documentation Server... but nothing changed... I changed .xlsx to .csv and all other formats available but... well... exhausted kind of.

I simply clicked the "Import Data" button over the menu bar. and followed processes...

Not even sure what is the cause.

Absurdly, there is no error or warning sign on my log window at all.

FYI, I attach the file(not only this file but other files does not properly is converted too with no error sign on the log window) so maybe one of you try to figure it out.

I asked my cohorts and my university's IT team and I know they have done their best. Sadly all did not work so far.

Please share with me any tips to move a bit forward!

Thank you!!!

Re: Importing Excel files shows corrupted files again and again..

Reeza — Fri, 12 Jul 2019 21:54:20 GMT

Show your code.

EDIT: your code from the log is fine.

And have you tried a code approach? If none are working, even CSV I suspect you have a path or license issue.

Re: Importing Excel files shows corrupted files again and again..

Tom — Fri, 12 Jul 2019 22:37:22 GMT

You said you used the IMPORT button but did not say what GUI you are using. Are you using Enterprise Guide? SAS/Studio? Display Manager? Something else?

What version of SAS are you running?

Did you try just running code to import the file instead of trusting some GUI tool to find the right code for you?

What process is making the files you are trying to read? perhaps the files really are corrupted.

Re: Importing Excel files shows corrupted files again and again..

Reeza — Fri, 12 Jul 2019 22:39:12 GMT

Different question, can you read any files at all? Have you tried importing a file from elsewhere that you're 100% sure is not corrupted?

Re: Importing Excel files shows corrupted files again and again..

JKCho — Sat, 13 Jul 2019 03:45:23 GMT

AH... I simply used PROC IMPORT instaed using the button... and all is good. I had no ideas what GUI and other things are.. and after reading others asking what about your GUI and something, I figured out that there is more than clicking the IMPORT button.

Thank you for your comments!

Re: Importing Excel files shows corrupted files again and again..

JKCho — Sat, 13 Jul 2019 03:46:33 GMT

I just ran the PROC IMPORT. I thought PROC IMPORT is the same as using the button. but not..

Thank you so much!

Re: Importing Excel files shows corrupted files again and again..

JKCho — Sat, 13 Jul 2019 03:47:24 GMT

For you who may read this thread later..

just use PROC IMPORT. that is it....