- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
>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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.