topic Re: Issues with using OS commands in SAS Studio University Edition in SAS Studio

Issues with using OS commands in SAS Studio University Edition

wilbur — Tue, 31 Oct 2017 17:09:33 GMT

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

Re: Issues with using OS commands in SAS Studio University Edition

Reeza — Tue, 31 Oct 2017 17:14:54 GMT

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

Re: Issues with using OS commands in SAS Studio University Edition

jennifert — Tue, 31 Oct 2017 17:50:43 GMT

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

Re: Issues with using OS commands in SAS Studio University Edition

wilbur — Wed, 01 Nov 2017 17:35:02 GMT

Thanks!