About Ramakanthkrovi

Ramakanthkrovi · ‎10-03-2019

The way I would do it is using a proc sql (which a lot of people suggest not to) and do a self join. if b.date in between a.date-7 (use intnx) and a.date then sum(comms) and group by a.date.

Ramakanthkrovi · ‎09-30-2019

We currently use Simba driver to connect to Big Query in 9.4M4 . Is there a paper or demo for what this post refers to?

Ramakanthkrovi · ‎09-09-2019

Hi @novinosrin - sorry about that. In the data that I have, there is no ID variable and so I replied that the lag worked which it did. I am just curious to know how having an ID variable will impact the code as I assumed it to be same as using a by statement. Apologies about that. I am trying to learn this thing to an extent where I don't have to come back to the forum if I do get a request sooner or later to include an ID variable.

Ramakanthkrovi · ‎09-08-2019

Thank you @novinosrin - if there is an ID variable, what will be the impact on the code? Region Month A sum(rolling 12 months) Australia April 2018 1 . Australia May 2018 2 3 Australia June 2018 3 6 Australia July 2018 4 10 Australia August 2018 5 15 Australia September 2018 6 21 Australia October 2018 7 28 Australia November 2018 8 36 Australia December 2018 9 45 Australia January 2019 10 55 Australia February 2019 11 66 Australia March 2019 12 78 Australia April 2019 13 90 Australia May 2019 14 102 NZ April 2018 1 . NZ May 2018 2 3 NZ June 2018 3 6 NZ July 2018 4 10 NZ August 2018 5 15 NZ September 2018 6 21 NZ October 2018 7 28 NZ November 2018 8 36 NZ December 2018 9 45 NZ January 2019 10 55 NZ February 2019 11 66 NZ March 2019 12 78 NZ April 2019 13 90 NZ May 2019 14 102

Ramakanthkrovi · ‎09-08-2019

I had to do this to get a rolling 12 month figure. the article is not informative for what I was trying to do. otherwise it works. RelativePeriod(_Sum_, 'NDC'n, _ApplyAllFilters_, 'Reg_Mon'n, _ByMonth_, 0, _Full_, {Date}) + RelativePeriod(_Sum_, 'NDC'n, _ApplyAllFilters_, 'Reg_Mon'n, _ByMonth_, -1, _Full_, {Date}) + RelativePeriod(_Sum_, 'NDC'n, _ApplyAllFilters_, 'Reg_Mon'n, _ByMonth_, -2, _Full_, {Date}) + RelativePeriod(_Sum_, 'NDC'n, _ApplyAllFilters_, 'Reg_Mon'n, _ByMonth_, -3, _Full_, {Date}) + ... +RelativePeriod(_Sum_, 'NDC'n, _ApplyAllFilters_, 'Reg_Mon'n, _ByMonth_, -11, _Full_, {Date}) + RelativePeriod(_Sum_, 'NDC'n, _ApplyAllFilters_, 'Reg_Mon'n, _ByMonth_, -12, _Full_, {Date})

Ramakanthkrovi · ‎09-08-2019

Thank you @novinosrin - The lag worked great. Is it simpler to do this way if we have multiple columns or is there a way I can do it in SAS VA 7.4?

Ramakanthkrovi · ‎09-08-2019

Hi @PaigeMiller - no, unfortunately we don't have sas/ets licence. I was also looking to do this in SAS VA (7.4) if possible. is it simpler than writing a program?

Ramakanthkrovi · ‎09-08-2019

No ID variable. for every month I just need the actual (a) and sum(a to a-11).

Ramakanthkrovi · ‎09-08-2019

Hi Team, I don't have sas/ets and was trying to see if this question has been raised and answered previously. I am trying to create a rolling 12 month total which calculates the sum of the last 12 months. Month A sum(rolling 12 months) April 2018 1 . May 2018 2 3 June 2018 3 6 July 2018 4 10 August 2018 5 15 September 2018 6 21 October 2018 7 28 November 2018 8 36 December 2018 9 45 January 2019 10 55 February 2019 11 66 March 2019 12 78 April 2019 13 90 May 2019 14 102 June 2019 15 114 July 2019 16 126 August 2019 17 138 September 2019 18 150 October 2019 19 162 November 2019 20 174

Ramakanthkrovi · ‎07-25-2019

Exactly, that is the problem. I want to create a category which is custom and I already explained that in the initial question. it is like writing sum(All geos) = "Group" APAC = "APAC" sum(all geos) - APAC = "RoW" that is the custom category. is it possible in SAS VA?

Ramakanthkrovi · ‎07-25-2019

True, but that was what I put together quickly to help you understand the problem. Because I am including all values of 'Geo' to create 'Group' - the new calculated item will always have only one value - Group.

Ramakanthkrovi · ‎07-25-2019

This is a query on the basis of the following thread https://communities.sas.com/t5/SAS-Visual-Analytics/Create-a-custom-category-in-SAS-VA-using-2-different-source/m-p/553671#M12335 I have a different issue compared to the one above. I need to create a custom category/ calculated item which is unique. I have attached the screenshot to understand it better - In the bar chart, "Group" is a sum of all revenue across all regions (including APAC, Europe and Americas), APAC is just APAC and "Rest of the world" is Europe and Americas. They are all built off the same variable. I need to create a category/ calculated item to use in a bar chart and assign values accordingly. Of course the below code doesn't work but below is a sample of how I expect it to work. IF ( 'Geo'n In ('APAC', 'Europe', 'North America', 'Enterprise') ) RETURN 'Group' ELSE ( IF ( 'Geo'n = 'APAC' ) RETURN 'APAC' ELSE 'Rest of the World'

Ramakanthkrovi · ‎07-23-2019

Hardware could be an issue. I am running on SAS EG on the cloud so I cannot pinpoint the exact problem.

Ramakanthkrovi · ‎07-21-2019

I am grouping by two columns already mentioned in the group by statement and I am selecting * from the dataset.

Ramakanthkrovi · ‎07-21-2019

@SASKiwi yes, the log contains that note. how can I overcome it?

Online Status	Offline
Date Last Visited	‎10-31-2020 12:43 PM

Re: Selecting sum of values from the last week of date from a date

Re: Sneak Preview - SAS/ACCESS Interface to Google BigQuery

Re: Rolling 12 months

Re: Rolling 12 months

Re: Rolling 12 months

Re: Rolling 12 months

Re: Rolling 12 months

Re: Rolling 12 months

Rolling 12 months

Re: Creating Custom Category in SAS VA

Re: Rolling 12 months

Re: Rolling 12 months

Re: Rolling 12 months

Re: using "having" in proc sql - run times

Re: Can SAS VA access SAS programs like SSRS?

Dynamic Crosstab Columns

Enterprise Guide in SAS Viya

Re: Selecting sum of values from the last week of date from a date

Re: Sneak Preview - SAS/ACCESS Interface to Google BigQuery

Re: Rolling 12 months

Re: Rolling 12 months

Re: Rolling 12 months

Re: Rolling 12 months

Re: Rolling 12 months

Re: Rolling 12 months

Rolling 12 months

Re: Creating Custom Category in SAS VA

Re: Creating Custom Category in SAS VA

Creating Custom Category in SAS VA

Re: using "having" in proc sql - run times

Re: using "having" in proc sql - run times

Re: using "having" in proc sql - run times

SAS Analytics Explorers