BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Gil_
Quartz | Level 8
I created a lib that gets created but file is blank using 9.4.
Libnane xlsxfile "h:\test.xlsx";

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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.

View solution in original post

5 REPLIES 5
Gil_
Quartz | Level 8
I created a lib that gets created but file is blank using 9.4.
Libnane xlsxfile "h:\test.xlsx";

Kurt_Bremser
Super User

@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.

ballardw
Super User

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.

Gil_
Quartz | Level 8
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
Gil_
Quartz | Level 8
I got it bring it in csv then convert character to datetime thsnks

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Discussion stats
  • 5 replies
  • 1970 views
  • 0 likes
  • 3 in conversation