DATA Step, Macro, Functions and more

No matching members in the directory sas university

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

No matching members in the directory sas university

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.

sAS excel.PNG


Accepted Solutions
Solution
‎08-22-2017 12:34 AM
Super User
Posts: 24,003

Re: No matching members in the directory sas university

[ Edited ]
Posted in reply to goldenflash

XLSX seems buggy for that to be honest. But you've also used XLSX to connect to an XLS file which isn't correct. Try changing it to EXCEL, except I'm not sure that works in SAS UE. Can you try saving your file as XLSX and try again?

 

Your approach is correct, and I can confirm that it does work in SAS UE. 

So the issue is likely the file itself or the file type specified. 

 


goldenflash wrote:

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.

sAS excel.PNG


 

View solution in original post


All Replies
Solution
‎08-22-2017 12:34 AM
Super User
Posts: 24,003

Re: No matching members in the directory sas university

[ Edited ]
Posted in reply to goldenflash

XLSX seems buggy for that to be honest. But you've also used XLSX to connect to an XLS file which isn't correct. Try changing it to EXCEL, except I'm not sure that works in SAS UE. Can you try saving your file as XLSX and try again?

 

Your approach is correct, and I can confirm that it does work in SAS UE. 

So the issue is likely the file itself or the file type specified. 

 


goldenflash wrote:

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.

sAS excel.PNG


 

Occasional Contributor
Posts: 5

Re: No matching members in the directory sas university

[ Edited ]

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;

sAS excel.PNG

 

Super User
Posts: 24,003

Re: No matching members in the directory sas university

Posted in reply to goldenflash

What happens if you try and import the data? 

What happens if you open the library in SAS, via point and click?

Occasional Contributor
Posts: 5

Re: No matching members in the directory sas university

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.

sAS excel.PNG

Trusted Advisor
Posts: 1,848

Re: No matching members in the directory sas university

[ Edited ]
Posted in reply to goldenflash

Change to : 

     set custfm.males;

Not -  'males$'n

Occasional Contributor
Posts: 5

Re: No matching members in the directory sas university

Alright, thx I got it working. I was taught to use $ sign and n, is this only needed when you are using it for non universiy edition?
Trusted Advisor
Posts: 1,848

Re: No matching members in the directory sas university

Posted in reply to goldenflash

When the name is not a sas valid name you can use 'not valid'n format.

The $ sign - use only if it is part of the sheet name.

Occasional Contributor
Posts: 5

Re: No matching members in the directory sas university

Thank you. I got everything to work.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 420 views
  • 3 likes
  • 3 in conversation