topic Re: Sql query regarding data refresh in SAS Programming

Sql query regarding data refresh

mattneo — Wed, 18 Mar 2020 15:29:07 GMT

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?

Re: Sql query regarding data refresh

ChrisNZ — Fri, 20 Mar 2020 01:17:53 GMT

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

Re: Sql query regarding data refresh

andreas_lds — Fri, 20 Mar 2020 05:46:50 GMT

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

Re: Sql query regarding data refresh

Patrick — Fri, 20 Mar 2020 06:04:34 GMT

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.

Re: Sql query regarding data refresh

mattneo — Fri, 20 Mar 2020 14:48:24 GMT

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

Re: Sql query regarding data refresh

mattneo — Sat, 21 Mar 2020 01:09:01 GMT

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

Re: Sql query regarding data refresh

ChrisNZ — Sat, 21 Mar 2020 01:31:57 GMT

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.

Re: Sql query regarding data refresh

mattneo — Sat, 28 Mar 2020 15:07:16 GMT

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.