topic Re: Date prompt in SAS VA in SAS Visual Analytics

Date prompt in SAS VA

india2016 — Mon, 03 Sep 2018 11:27:52 GMT

Hello All,

Need your small help . I want to have a summarisation report for few columns. Those columns at the back end depends on different date. But in VA at the front end I want to show the data having generalized date, Say for example. Frond end is like this

Date Slider
Districts	No. Of FIR	No. OF Petty cases	No. Of MOBs
1	12	23	22
2	3	45	33
3	4	6	44
4	5	7	55
5	78	89	66
6	90	89	77
7	11	90	88

Date is generalized at the front end.

At the back end all this 3 number columns depends on different date.

Re: Date prompt in SAS VA

FredrikE — Mon, 03 Sep 2018 13:44:27 GMT

CAn you describe the back end data and the rules that apply to get the desired output?

//Fredrik

Re: Date prompt in SAS VA

india2016 — Tue, 04 Sep 2018 06:02:07 GMT

@FredrikE

First Dataset below:

Districts Date FIR
A 02-09-2018 2
B 02-09-2018 5
A 03-09-2018 3
A 04-09-2018 5
B 04-09-2018 6

Second dataset Below

Districts P_Date Petty Case
A 01-09-2018 3
B 02-09-2018 3
A 02-09-2018 4
A 04-09-2018 6
B 04-09-2018 7

Frond end I have to use general date. But from the back end we need FIR number By districts and date from 1st dataset and number of petty cases by districts and date from 2nd dataset.

Re: Date prompt in SAS VA

FredrikE — Tue, 04 Sep 2018 08:12:28 GMT

Ok, then you need to merge the two datasets before adding it to the report.

You can do that either in the source system or in the data prep step in VA.

Your data should consist of.

Districts commonDate FIR Petty Case

Where commonDate is the merge between date and p_date.

//Fredrik