cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Chugvenk
‎06-22-2019
  • 10 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Random Numbers summing to a particular value

by Calcite | Level 5 in SAS Programming
‎05-17-2019 04:30 PM
‎05-17-2019 04:30 PM
@FreelanceReinh  Thanks so much. I tested this and it works perfectly! Awesome! ... View more

Re: Random Numbers summing to a particular value

by Calcite | Level 5 in SAS Programming
‎05-17-2019 04:25 PM
‎05-17-2019 04:25 PM
 the dataset you created was a bunch of numbers that went uptil 250 (250 was the last number), which was not quite what I was looking for. I was looking for a column of random numbers and the total of that should have been 250. Again, maybe I didn't explain it correctly, so my bad. Thanks for getting back to me! Have a good day! ... View more

Re: Random Numbers summing to a particular value

by Calcite | Level 5 in SAS Programming
‎05-17-2019 03:09 PM
‎05-17-2019 03:09 PM
@PGStats  Unfortunately, this didn't work. The solution provided by @ChrisNZ  is the correct one I was looking for.   That said, thanks for getting back to me. I appreciate it!   ... View more

Re: Random Numbers summing to a particular value

by Calcite | Level 5 in SAS Programming
‎05-17-2019 03:06 PM
‎05-17-2019 03:06 PM
@ChrisNZ  Thank you so much. This absolutely works!   I had no idea this code would be so complex. You are awesome! Thanks again! ... View more

Re: Random Numbers summing to a particular value

by Calcite | Level 5 in SAS Programming
‎05-16-2019 07:25 PM
‎05-16-2019 07:25 PM
Patrick,   It can be done in excel, I have done it before. I need to do this in SAS.   https://stackoverflow.com/questions/21782329/generate-n-random-numbers-whose-sum-is-a-constant-k-excel   And yes, we would need a custom logic, I was asking help with that since I am new to SAS.    Regards, Suhrit     ... View more

Re: Random Numbers summing to a particular value

by Calcite | Level 5 in SAS Programming
‎05-16-2019 07:11 PM
‎05-16-2019 07:11 PM
Yes, they need to be positive integers.  Purpose: For creating a mockup for reporting, until we actually get the data from the warehouse. Test for Randomness: Honestly, I'm not sure what this means. It should just be 5000 random numbers summing to 25000. I can do this in excel, I'm new to SAS, so I am hoping there are functions for this. ... View more

Random Numbers summing to a particular value

by Calcite | Level 5 in SAS Programming
‎05-16-2019 06:28 PM
‎05-16-2019 06:28 PM
Team,   I have a dataset of 5000 rows. I want to create a new column (say x) that generates random integers so that the sum of those integers (in the 5000 rows) comes to 25000. How do I achieve this in SAS?   Regards, Suhrit ... View more

Re: Change in Revenue for Partial Months in a year

by Calcite | Level 5 in SAS Programming
‎05-08-2019 11:20 PM
‎05-08-2019 11:20 PM
Reeza,   Thank you for your response! I tried it out and it worked. You are awesome!     ... View more

Re: Change in Revenue for Partial Months in a year

by Calcite | Level 5 in SAS Programming
‎05-01-2019 06:38 PM
‎05-01-2019 06:38 PM
Hi Reeza,    Thanks for your response   This is the desired output   CompanyNo Year Month Rev 123 2017 September 250 123 2017 October 165 123 2017 November 170 123 2017 December 150 123 2018 January 125 123 2018 February 150 123 2018 March 175 123 2018 April 200 123 2018 May 225 123 2018 June 250 123 2018 July 275 123 2018 August 300 123 2018 September 325 123 2018 October 350 123 2018 November 375 123 2018 December 400     GROWTH -49.310345   So basically, IF company has revenue for n number of months in a 2017, the same number of months should be compared for 2018.   This is the code I had worked. It works fine if the data exists for all months in a year, so I can simply use the lag function to see the value for the previous row.   data mylib.RevenueYOYGrowth; set mylib.cc_test; by client_number yr; lyr1 = lag1(revenue); if first.yr then count=0;else count+1; if count ge 1 then growth1yr=100*(revenue-lyr1)/lyr1; run; ... View more

Change in Revenue for Partial Months in a year

by Calcite | Level 5 in SAS Programming
‎05-01-2019 06:24 PM
‎05-01-2019 06:24 PM
Hi, I am new to SAS and need some help. I have a dataset with the following data: Company number, year, month, Revenue. File attached. I was able to calculate the change in revenue for current month compared to previous month using the below code data mylibrary.RevenueYOYGrowth;      set mylibrary.chug_test;      by company_number yr;      lyr1 = lag1(revenue);      if first.yr then count=0;else count+1;      if count ge 1 then growth1yr=100*(revenue-lyr1)/lyr1; run; The above code works perfectly if the company has data for all the months in year. Requirement is, if the company has partial revenue in one year, the change in revenue should only be calculated for those months. So if a company has revenue for months say September 2017, October 2017, November 2017, December 2017, then the revenue should be calculated only for those months in 2018 also. Basically, (sum(september2017+october2017+november2017+december2017)-sum(september2018+october2018+november2018+december2018))/sum(september2018+october2018+november2018+december2018)   Excel attached shows sample data for both scenarios. I am needing help for the scenario in yellow. Please find attached   Appreciate a quick response! Thank you! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-22-2019 08:59 PM
Likes given to
View All
Quick links