topic Re: Incremental Loading data into CAS Server in SAS Data Management

Incremental Loading data into CAS Server

sridhar_m — Mon, 18 Feb 2019 05:29:23 GMT

Hi, Could you please help me on the below:

How to load latest 6 months data into SAS CAS Server.

and after that how to append 3 more months into it.

Using with PROC CASUTIL.

Thanks in Advance,

Regards,

Sri

Re: Incremental Loading data into CAS Server

ChrisHemedinger — Thu, 21 Feb 2019 19:58:01 GMT

I've moved this post to the Data Management board for more expertise.

I think you probably will need to use DATA step or another data prep step to filter your data to the months you need, then use CASUTIL to load the result. But others here might have better ideas.

Re: Incremental Loading data into CAS Server

sridhar_m — Fri, 22 Feb 2019 03:31:39 GMT

Hi Chris,

Thanks a lot for your updates. Actually In CAS environment while loading the data itself we need to filter it right. Please correct me if I am wrong. And before loading the data can we use DATA step? Please let me know.

Thanks in Advance,

Regards,

Sri

Re: Incremental Loading data into CAS Server

SASKiwi — Fri, 22 Feb 2019 21:40:57 GMT

@sridhar_m This looks like the same question you asked in this post: https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-to-current-year-and-month-by-default/m-p/535159#M11888

Where do you want continue - in this post or the other one? Sticking to one post is a lot better.