SAS Support Communities

Hi,    I am currently creating a process which will be scheduled on our Viya 3.3 environment which will effectively loop through a folder and read filenames of a certain pattern.    So obviously to start I need a list of files.    This would be completed using something similar to the below   filename myfiles pipe "ls /data/files/*.ext"; And stored in a table using a subsequent data step. I first got errors then surrounding XCMD issues, so obviously this option is disabled by default. Similar messages occur using the %SYSEXEC Macros.   ERROR: Shell Escape is Not Valid in this Session I've tried adding the    OPTIONS XCMD;   to the start of the script which appears to not have worked, and I do have access to autoexec_usermods.sas and have added the same still no luck.    Finally I've tried implementing the Enabling -XCMD for the SAS Connect Spawner and still no luck.   I get the security implications for disabling this initially, however it surely isn't that hard to enable system commands in SAS? If anybody can point me in the right direction, it would be greatly appreciated.       ... View more

Hi,    I've tried importing an SPK from a 9.4 VA Environment to a SAS Viya VA Environment. This is using the transfer CLI on windows. We have our Viya instance setup via AWS and for obvious security reasons have disabled access over http://, i.e. we are only accepting traffic over a https:// request. (and no reopening http is not an option) I've taken the following steps to get to the sticking point. I was wondering if anybody else had the same issue and if so what steps have they taken to resolve? It all looked to be going pretty good until push came to shove.    Step 1: Create the Profile   C:\Users\Folder>sas-transfer profile init   Enter configuration options:   Service Endpoint>  https://site:7980   Output type (text|json|fulljson)> text Saved 'Default' profile to C:\Users\Folder\.sas\config.json.   Step 2: Get an OAuth Token for profile   C:\Users\Folder> sas-transfer authenticate login -u sasadmin -p password   Login succeeded. Token saved.   Step 3: Upload SPK with Mapping File C:\Users\Folder> sas-transfer upload --spk package.spk --mapping mapping.yml Id 3e253eb5-cfd5-47fd-b949-ba4d86f1082a Name package.spk INFO: Mapping file mapping.yml created.   Step 4: Import updated file and mapping (the puzzling bit)   C:\Users\Folder>sas-transfer import -packageId 3e253eb5-cfd5-47fd-b949-ba4d86f1082a --mapping mapping.yml   running ....failed The following errors have occurred:   Get http://site/SASHome/: dial tcp 10.10.10.10:80 : connectex: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. Http Status: 0   Why would the cli default back to http:// especially when I've specified the request/site to be https://?    Kind Regards,  David    ... View more