BookmarkSubscribeRSS Feed
sridhar_m
Obsidian | Level 7
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
3 REPLIES 3
ChrisHemedinger
Community Manager

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.

Learn from the Experts! Check out the huge catalog of free sessions in the Ask the Expert webinar series.
sridhar_m
Obsidian | Level 7

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

SASKiwi
PROC Star

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

 

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

 

 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1510 views
  • 0 likes
  • 3 in conversation