topic My libnane table is blank doesnt exist error message in Microsoft Integration with SAS

My libnane table is blank doesnt exist error message

Gil_ — Tue, 07 Aug 2018 21:45:44 GMT

I created a lib that gets created but file is blank using 9.4.
Libnane xlsxfile "h:\test.xlsx";

My libnane table is blankexist error message

Gil_ — Tue, 07 Aug 2018 21:46:23 GMT

I created a lib that gets created but file is blank using 9.4.
Libnane xlsxfile "h:\test.xlsx";

Re: My libnane table is blank doesnt exist error message

ballardw — Tue, 07 Aug 2018 23:14:57 GMT

You are posting this in the integration with Microsoft Office area. Your question does not appear to relate to that so perhaps this should be in the base programming area.

Also, LIBNAME by itself does not create any files or output and you don't show any code that should create output. So we have no idea what might be an issue.

Check your log.

If there are warnings or errors copy the code and messages from the log and paste that into a code box opened using the forum's {I} menu icon.

Re: My libnane table is blank doesnt exist error message

Gil_ — Tue, 07 Aug 2018 23:42:46 GMT

1st time creating a lib
Libnane xlsxfile "h:\test.xlsx. here is my code to refer where the file is located it creates a tanle but no data my log shows it was created successful when i click pn log it hives me error message test$ doesnt exist

Re: My libnane table is blank doesnt exist error message

Gil_ — Wed, 08 Aug 2018 01:33:52 GMT

I got it bring it in csv then convert character to datetime thsnks

Re: My libnane table is blankexist error message

Kurt_Bremser — Wed, 08 Aug 2018 04:37:03 GMT

@Gil_ wrote:
I created a lib that gets created but file is blank using 9.4.
Libnane xlsxfile "h:\test.xlsx";

Please post your real code and the log from that; this statement is a pure syntax error.

See my footnotes for how to post code and log.