Date prompt in SAS VA

[india2016]

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.

[FredrikE]

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

//Fredrik

[india2016]

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

[FredrikE]

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