Importing Excel files shows corrupted files again and again..

[JKCho]

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!!!

[Reeza]

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.

[JKCho]

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!

[Tom · Accepted solution]

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.

[JKCho]

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

Thank you so much!

[JKCho]

For you who may read this thread later..

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

[Reeza]

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?