Issues with using OS commands in SAS Studio University Edition

[wilbur]

Hello, I am using SAS Studio University Edition (Release 3.6) for Linux Ubuntu 16.04. I am trying to get a directory listing of files using the 'ls' command, and receiving the error statements "ERROR: Insufficient authorization to access PIPE. ERROR: Error in the FILENAME statement." My code: filename DIRLIST pipe "ls /path_to_excel_files/*"; I have read online solutions regarding setting the XCMD option, but cannot find where this might be set in University Edition. Perhaps there is another way to get a file listing? I want to be able to import selected XLS files into SAS. Thanks much

[Reeza]

SAS UE does not allow/support system commands, including pipe access. However, you can use Fxxx type functions to retrieve the same information. I think the following will work on SAS UE, you do need to set up a shared folder to the path of interest though. https://github.com/statgeek/SAS-Tutorials/blob/master/Import_all_files_one_type

[jennifert]

Hi @wilbur,

Just as an FYI, you can find this and other limitations here in the SAS University Edition FAQ:

Is there anything else I should know before I start using SAS University Edition?

thanks,

Jennifer

[wilbur]

Thanks!