My datasource at SAS Viya 8.1 is in a Sandbox environment, so my IT guy refreshes the data manually every day. He's away from work so the datasource is a few days old. As a power user, i can access SAS studio and SAS data studio, so where should i go to run the query to update my datasource? I see Proc Sql code when i enter SAS studio. What would the code to refresh data look like, and how do i run it?
Basically, just hit the Submit button in SAS Studio. When the run is completed, an Output tab will appear to show the outcome, like if there are any errors etc.
>What would the code to refresh data look like, and how do i run it?
It could look like anything.
It's like you are telling us you have access to a supermarket and what does food look like?
@mattneo wrote:
My datasource at SAS Viya 8.1 is in a Sandbox environment, so my IT guy refreshes the data manually every day. He's away from work so the datasource is a few days old. As a power user, i can access SAS studio and SAS data studio, so where should i go to run the query to update my datasource? I see Proc Sql code when i enter SAS studio. What would the code to refresh data look like, and how do i run it?
Just because you are a "power user" does not mean that you have the required rights to update the data-source.
There is no Viya version 8.1 The latest version of Viya is 3.5.
You can't load data into CAS using Proc SQL
Here the docu link how to load data via script into CAS. There is much development happening in the Viya space so make sure you use the docu for your Viya version.
Sorry, it's really hard to help you with such vague requirements.
Your solution could literally be anywhere and look like one of an infinite number of patterns.
Basically, just hit the Submit button in SAS Studio. When the run is completed, an Output tab will appear to show the outcome, like if there are any errors etc.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.