Counting new products/users in SAS VA 7.4

[jmehul]

Hi All,

I want to make a KPI on my dashboard using SAS VA 7.4 on which I can show the number of new users/products/employees e.t.c. in the current month. For that, I have date level data. 

Can anyone guide me?  

[FredrikE]

One way could be to have a flag for each level (users/products/employees) that get the value 1 if it s new for that date.

When you have that you can aggrete on which level (day/week/month/year) you want.

🙂

//Fredrik

[jmehul]

Thanks for responding.

But How to make that flag which will identify the new user.

[SASKiwi]

Write a SAS program which adds this flag to your SAS dataset before it is loaded into your LASR server.

If you want help with how to code this then you will need to post sample input data and your expected output data. 

[jmehul]

Thanks,

I will do it in EG.