BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
JM_VFAU
Obsidian | Level 7

Is there a feature of joining two data sources in SAS VA  as part of the data preparation step? If this is possible, is there any special consideration that need to be taken into consideration for the CAS server setup? for e.g if we need to join 2 data sets with 2+ years of data is ok to do the data preparation within SAS VA or outside of SAS VA.

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

I recommend joining outside of SAS VA especially if you want a repeatable, automated process. Typically I do all VA data preparation in SAS code, then run this as a scheduled job. 

View solution in original post

4 REPLIES 4
SASKiwi
PROC Star

I recommend joining outside of SAS VA especially if you want a repeatable, automated process. Typically I do all VA data preparation in SAS code, then run this as a scheduled job. 

acordes
Rhodochrosite | Level 12

As @SASKiwi said, it's a better choice to do it in sas studio via code or through a data plan.

Nevertheless it can be done within the VA report. Right-clicking on the data table gives you several options to join tables. 

What you need to have in mind is the following:

  • calculated items are not part of the join
  • you cannot define a where clause in the join
  • the report user can only access the resulting table if he has access to the intervening caslibs of the join.
  • you mentioned 2 years, have in mind that tables can get unloaded from memory. the join to succeed requires the table to be promoted or elsewise having a file with the same name (sashdat or other formats) in the same caslib 
Madelyn_SAS
SAS Super FREQ

It is not recommended to  join tables in the Visual Analytics report itself, as it can cause performance problems. 

JM_VFAU
Obsidian | Level 7

Thank you @Madelyn_SAS @SASKiwi @acordes. Very helpful tips.

 

I under SAS VA has limited capability to join data sets. Listing some of options possible to combine data sets

 

1) Use Data Studio to prepare data by joining various data sources for exploration purpose. This amount of data is limited by the infrastructure resorces.

2) Once the data exploration is done, prepare the data outside of SAS Viya environment if you need the same data set to have 4 or 5 years data.

 

Does this sound right?

 

 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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
  • 4 replies
  • 757 views
  • 5 likes
  • 4 in conversation