It is often much more useful to show the LOG from when you run code. Copy text from the log for the entire data step or procedure that you are attempting, on the forum open a text box using the </> icon that appears above the message box and paste the text. The text box helps by preserving text diagnostics that SAS often provides that get reformatted when pasting into the main message windows.
IF pcfile server is configured correctly you would not "import" or "export" data. The spreadsheet file would be a Library and you read sheets (maybe, bad sheet names can be problematic) as data sets, or write to the library with any procedure or data set to create a new sheet.
Since you only provided picture and not actual text in that PDF (talk about wasted time doing that: copy and paste from editor should be much quicker)
Libname mylib pcfiles "\\server\path\filename.xlsx";
if the path is correct and pcfiles configured correctly would create a library named MYLIB.
If the xlsx file has sheets named Data1, Data2 and similar then those sets would appear in the LIBRARY folder.
Note: set options validvarname BEFORE a procedure that may need it. With the typical junk I find in spreadsheet tab names you likely also need Validmemname=extend. Be prepared to deal with Name literals for variables and data sets.
... View more
