Data with SDC2 in VA

barlocaroni — Tue, 12 Mar 2019 06:52:30 GMT

Hello All,

I am quite new to the SAS VA (7.4)

My data contains two data fields (start and end) that define the validity interval of each record (SCD type 2):

Item Status StartDate EndData

001 Not Active 3Nov2018 24Nov2018

001 Active 25Nov2018 31Dec2999

002 Not Active 22Nov2018 31Dec2999

003 Active 11Nov2018 20Nov2018

003 Not Active 21Nov2018 31Dec2999

My goal is to select / filter only the records valid at a certain date selected, for example, through a single value slider.

Is it possible to do this directly with VA or it's necessary some workaround with data? For example, selecting 23Nov2018, how many items are active or Not Active?

Thanks in advance

Re: Data with SDC2 in VA

FredrikE — Tue, 12 Mar 2019 07:58:48 GMT

HI!

I think you can do it 🙂

Create a parameter and connect it to the slider.

Then create a filter like "startDate <= [parameter] <= endDate", either as a data filter or on the objects you asre using.

The only thing is that the slider needs to be fed by data and you might not have all dates in your data set.

One way to solve this is by having a separate data set with the dates, and I think it only need to have the minimum and maximum dates and as long as it is a date variable the slider object will allow tou to select any date in between.

//Fredrik

topic Data with SDC2 in VA in SAS Visual Analytics

Data with SDC2 in VA

Re: Data with SDC2 in VA