Sql query regarding data refresh

[mattneo]

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?

[ChrisNZ]

>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]

Im really new into these, so i dont know what to look for. If you're into analogies, im like a 3 year old toddler exploring the world and being curious. What may seemed obvious to adults may not be so for a toddler. Another one: i only see sql code being used. To me, coding might have certain operators that perhaps i can referenced. Perhaps an UPDATE(DATASOURCE) or sth. So its like ordering from macdonalds. I wanna Big Mac, and there's only that few ingredients that goes into it.. i could be wrong....but some guidance would be appreciated

[andreas_lds]

---

@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.

[Patrick]

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.

[mattneo]

Sorry typo error. Its v 8.3.1. I was told im in a sandbox environ, and data gets refreshed manually. Im not a tech person so im just figuring out

[ChrisNZ]

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.

[mattneo · Accepted solution]

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.