03-02-2016
Gaffron
Fluorite | Level 6
Member since
02-29-2016
- 5 Posts
- 0 Likes Given
- 1 Solutions
- 0 Likes Received
-
Latest posts by Gaffron
Subject Views Posted 2015 03-01-2016 07:47 AM 2068 03-01-2016 06:14 AM 1810 02-29-2016 08:52 AM 1812 02-29-2016 08:43 AM 1850 02-29-2016 04:45 AM -
Activity Feed for Gaffron
- Posted Creating dataset with ultimo month dates on SAS Programming. 03-01-2016 07:47 AM
- Posted Re: Calculationg year to date growth on SAS Programming. 03-01-2016 06:14 AM
- Posted Re: Calculationg year to date growth on SAS Programming. 02-29-2016 08:52 AM
- Posted Re: Calculationg year to date growth on SAS Programming. 02-29-2016 08:43 AM
- Posted Calculationg year to date growth on SAS Programming. 02-29-2016 04:45 AM
03-01-2016
07:47 AM
Hi I need a program that forms at the end of month dates between two dates. Somthing like: data date; format date ddmmyy10.; do date='01jan2010'd to '31dec2016'd by 1; output; end; run; But unly with one date for each month. data months; format date ddmmyy10.; do date=intnx('month', '31dec2010'd, n)-1 to '31dec2016'd by n; output; end; run; But how to I count n up with 1 to 31dec2016? Best regards Terkel
... View more
03-01-2016
06:14 AM
Thank you for being so kind to take the time to answer my questions. Best regards Terkel
... View more
02-29-2016
08:52 AM
Right! My mistake. Sorry for the confusion, Thanks for the elegant solution. What If I need to calculate the growth for each year? Best regards Terkel
... View more
02-29-2016
08:43 AM
Well, embarrassing !!!!, I’m afraid I forgot that I need to calculate the year-to-date growh for each year. Is that possible?
... View more
02-29-2016
04:45 AM
/* || Hi || How do I create year to date growth from || And I need to calculate the year to data growth */ DATA employee; INFORMAT DATE MMDDYY10. employees 3. ; INPUT DATE employees; FORMAT DATE DATE9.; DATALINES; 12/31/2014 60 01/31/2015 70 02/28/2015 100 03/31/2015 131 04/30/2015 140 05/31/2015 150 06/30/2015 160 07/31/2015 170 08/31/2015 145 09/30/2015 150 10/31/2015 153 11/30/2015 160 12/31/2015 170 01/31/2016 180 ; run; Output: Date Employees GrowthYTO 01/31/2015 70 10 02/28/2015 100 40 03/31/2015 131 71 04/30/2015 140 80 05/31/2015 150 90 06/30/2015 160 100 07/31/2015 170 110 08/31/2015 145 95 09/30/2015 150 100 10/31/2015 153 103 11/30/2015 160 110 12/31/2015 170 120 01/31/2016 180 130 Best regards Terkel
... View more