About DavidHD

DavidHD · ‎02-15-2023

If everything is configured properly you shouldn't need to configure anything. What you can do is adjust your Autoexec to set things like options set=R_HOME="/R/R-4.0.2/lib64/R";

DavidHD · ‎02-14-2023

Hi @alko13 , Python and R need to be installed on the same machine as your compute - please refer to this documentation For the Proc IML R integration you will also need to set the RLANG option - documentation For Proc FCMP Python integration you will also need to set MAS_M2PATH - documentation If you want to run your Python models in MAS please see this documentation Please note that Proc Python is not available in SAS Viya 3.5. Hope this helps, David

DavidHD · ‎01-31-2023

Hi @AreSivertsen , you can list all clients and their properties by making a GET request to <viya-host>/SASLogon/oauth/clients. Deleting a client is done by making a DELETE request to <viya-host>/SASLogon/oauth/clients/<client-id>. Best, David

DavidHD · ‎11-06-2022

Hey, you can make use of the dataShaping.wideToLong CAS Action. Please note that this action was first introduced in SAS Viya 2021.1.2 proc cas; dataShaping.wideToLong / table={caslib='casuser', name='iris'}, id='Species', casOut={caslib='casuser', name='iris4', replace=true} ; quit; Best, David

DavidHD · ‎01-01-2022

There is a Viya Trial Version available - check out this blog post for all the information about it.

DavidHD · ‎09-29-2021

Yes this can be done by utilizing the proc olapoperate - see the documentation: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/olapug/n0rh9rcu3ucqzon1o9cb47zbzytj.htm

DavidHD · ‎07-29-2021

Oh okay, I'm sorry I guess I miss understood the use case. Going around the login of SAS Viya is of course dangerous because then the link can be shared with anyone in your organization and they can open up the report and if there is row level security on the table this gets even worse. Just a reminder I'm sure you know what you are sharing with the users. You have to ensure that Guest Access is enabled for your SAS environment, then Copy Link of the VA report you want to be accessible through your application and enable guest access (see Screenshot). Clicking on that link should open the report directly without a login.

DavidHD · ‎07-29-2021

Hi @smallajyosula , You pass the token in the header of your Request: Authorization: 'Bearer <your-token>' Please be advised that by default Accept-Tokens in Viya have a validity of 12 hours so you will either implement a token refresh or have your Viya admins issue a token that has a longer lifetime. I'm no C# programmer but it should look a little something like this: var client = new RestClient("https://sasviya.test.com/SASJobExecution/?_program=/Projects/MyOrg/ExpenseReport"); client.Timeout = -1; var request = new RestRequest(Method.GET); request.AddHeader("Authorization", "Bearer <your-token>"); IRestResponse response = client.Execute(request); Console.WriteLine(response.Content); Cheers, David

DavidHD · ‎07-20-2021

Hi @Eitan123 , in the SMC UI inside of the flow editor there should be button for an and logic object. Then you connect the paths in the manner you would like into it and only if all of the completed successfully it will trigger the next thing after the and object. When you connect objects it should prompt you for the condition on which you want the following step to be executed. Hope this helps - Cheers David

DavidHD · ‎06-10-2021

@Manoj07k I believe that in the libname statement you need aclspecial=yes and of course the user that you use to connect to the lib needs to be the same. When you connect using EG these might not be the same as on the server when you have pre-assigned libs. Hope this helps, David

DavidHD · ‎06-08-2021

Hi @danewt , there is a revised version of that paper available see here: https://support.sas.com/resources/papers/proceedings16/SAS6201-2016.pdf The paper also contains some amazing links to additional resources. Hope this helps, David

DavidHD · ‎06-04-2021

Check that you can reach the DB Server from the SAS Server (e.g. ping it) - if this doesn't work check with the Firewall/DNS-Team. Validate your user credentials with the DB Team Submit via code libname statement with this works move the SMC If you get errors search for that error online and fix as appropriate - you might need to get in contact with the DB admins again

DavidHD · ‎06-04-2021

What happens if you submit the libname statement in code from EG? Do the tables then show up?

DavidHD · ‎05-28-2021

Hi @SasStatistics , 1. The latest SAS Viya version is 2021.1 for the LTS cadence and 2021.1.1 for the Stable cadence 2. There are no substantial differences between the version, and more importantly no breaking changes. Newer versions get more features, bug fixes, etc. So some content in Programming for SAS Viya 2020.1 might not be available in SAS Viya 3.5. But the majority is the same. On the cadence and versioning of SAS Viya take a look at this community entry: https://communities.sas.com/t5/SAS-Viya/Back-to-the-Future-with-SAS-Viya-Releases/td-p/703510 I hope this answers your questions. Best, David

DavidHD · ‎04-30-2021

If you are collaborating on the code, doing a lot of changes or it is a business critical process then I would recommend using Git. Here is a great paper describing the integration of Git and SAS Studio: https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4197-2020.pdf JSF can be really great, but as far as I'm aware it currently only supports time based triggers, but that might be all you need depending on your use case - take a look at this blog post: https://communities.sas.com/t5/SAS-Communities-Library/Go-with-the-Job-Flow-in-SAS-Viya-3-5/ta-p/612925 I hope this is helpful.

Online Status	Offline
Date Last Visited	Friday