Applying a format to a variable doesn't change the value stored, only how it is displayed. If you want to use a WHERE clause on a formatted value you have to use the PUT function:
where put(lob, $flob.) in ('PONAUO','PONPRO');
... View more
You can turn that note off by adding this option to your SAS server AUTOEXEC - this will enable it for all users:
options noquotelenmax;
That's what we do and it works fine.
... View more
Are you talking about an Enterprise Guide project or something else? My suspicion is that you would have to export the code out of an EG project and then get Copilot to analyse it. I doubt Copilot could unpack an EGP file.
... View more
Did you investigate the possible cause posted above https://support.sas.com/kb/41/488.html?
You need to disable any external non-SAS processes that might be interfering with SAS WORK files.
... View more
Looks like Azure service principals are supported on Viya using the SPARK engine.
I also asked Google if this is supported on SAS 9.4 and got this:
I've got no way of checking this so I suggest you try Google yourself:
... View more
Authdomains are typically created via SMC and can be created or changed using the Server Manager or User Manager plugins. If they are being used to authenticate an external database then usually there is a metadata user group created to store the service account being used to access the dsatabase. The service account needs to have the authdomain applied to it. Also you need to be added as a member of the group for the authdomain to work for you.
If you can't check these out yourself then you will need to rely on your SAS administrator.
EDIT: If I'm understanding your post correctly then your question is more about using authdomains in SAS Viya. This is really a job for your SAS administrator but here is a link to how these are set up: https://documentation.sas.com/doc/en/sasadmincdc/v_069/calcredentials/p0c0l75i14ni65n10515di5layj8.htm
... View more
The SAS Viya Copilot logo includes a robot that looks a lot like a Doctor Who Cyberman that used to scare me witless as a kid 😆. Wonder if anyone else in the Community remembers them?!
... View more
What does your SAS log report when you assign the SNOW LIBNAME? Do you get something like this?
I've never had any problems with Snowflake not recognising the WAREHOUSE option. Maybe try adding SCHEMA = PUBLIC as well to see if that helps.
... View more
Looks like your SAS session is unable to allocate a SAS WORK library. Check your SAS config regarding the WORK folder location and troubleshoot why it isn't accessible.
... View more
Without individual IDs I don't think this is possible. In any case this is more of a Sybase IQ question so you should ask the question on on of their forums.
... View more
