Hi, Sorry, the xlxs file was saved in the wrong folder but saving it as a xlxs solved the problem. I have another issue while creating a temporary SAS file. when I use data and set, I get another error saying it couldn't find the spreadsheet. Sorry for the question after question, but I've been trying to get this to work. Thank you.
... View more
Hi, Thank you for your reply. I've tried saving as xlxs but I still get the same log output. I've attached copies (an xls and xlxs file) of my excel so that you can check if there is a problem with the excels. Thank you for your time. Code for your convenience: LIBNAME custfm XLSX '/folders/myfolders/dataset/custfm.xlsx'; proc contents data=custfm._all_; run;
... View more
Hello, Im new to SAS university and have been having this issue. I successfully assigned the library but can't get proc contents to work. There is a custfm.xls file in my folder. Sorry if this is trivial and thank you.
... View more