BookmarkSubscribeRSS Feed
vamsipallaganti
Calcite | Level 5

Hi,

 

I am new to SAS VA. I am trying to create a crosstab by loading data from an oralce table. But my source table has more than 50 million records that belong to the past 10 years. But, I dont want to pull all the data into my SAS VA server. I would like to load the data for the past 6 months only.

 

Could anyone help me, how to load the data with filters.

 

Thanks in advance.

1 REPLY 1
LinusH
Tourmaline | Level 20

The easiest would be to define the filter in the Data Builder interface.

Another option would be to pre-process data in a SAS batch program, and store store the intermediate table in a staging area, or in a SASHDAT location (if you are in distributed environment).

Data never sleeps

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!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 884 views
  • 0 likes
  • 2 in conversation