Prev: SAS - Analysis in DATA Step
Next: Inside the SAS procs.
From: Sunny on 5 Apr 2010 22:42
Hello Group,


I 'm trying to get the MTD YTD & PYTD and PYMTD using date function
data is something like this

1 MONTH 12 MONTH
MONTH OF PRICE PRICE 1 MONTH 3 MONTH 6 MONTH 1 YEAR 2 YEAR 3 YEAR 5
YEARS 10 YEARS TOTAL TOTAL
CLOSE CHANGE % CHANGE % CHANGE % CHANGE % CHANGE % CHANGE % CHANGE %
CHANGE % CHANGE RETURN RETURN
10/2009 1036.19 -20.88 -1.98% 4.93% 18.72%
6.96% -33.12% -24.80% -8.32% -23.97% -1.86% 9.80%



thanks in advance will appreciate your help.

Sunny
From: Barry Schwarz on 6 Apr 2010 19:40
On Mon, 5 Apr 2010 19:42:53 -0700 (PDT), Sunny <msunny17(a)gmail.com>
wrote:

>Hello Group,
>
>
>I 'm trying to get the MTD YTD & PYTD and PYMTD using date function
>data is something like this
>
> 1 MONTH 12 MONTH
>MONTH OF PRICE PRICE 1 MONTH 3 MONTH 6 MONTH 1 YEAR 2 YEAR 3 YEAR 5
>YEARS 10 YEARS TOTAL TOTAL
> CLOSE CHANGE % CHANGE % CHANGE % CHANGE % CHANGE % CHANGE % CHANGE %
>CHANGE % CHANGE RETURN RETURN
>10/2009 1036.19 -20.88 -1.98% 4.93% 18.72%
>6.96% -33.12% -24.80% -8.32% -23.97% -1.86% 9.80%

What do your acronyms mean?

There is only one date function and it returns "today's" date. How
will that help you calculate the values you want.

We need real data, including variable names, and a precise definition
of the intended output. And it would help a whole bunch if you
figured out a way to present the data clearly taking into account word
wrap.

--
Remove del for email
From: saurabh modi on 8 Apr 2010 21:08

Actually I 'm trying to get Month to Date Year to Date, prev. Year
month to date, prev year to date.
I 'm trying to create a macro for that and have the date value through
macro variable.



On Apr 6, 7:40 pm, Barry Schwarz <schwa...(a)dqel.com> wrote:
> On Mon, 5 Apr 2010 19:42:53 -0700 (PDT), Sunny <msunn...(a)gmail.com>
> wrote:
>
> >Hello Group,
>
> >I 'm trying to get the MTD YTD & PYTD  and PYMTD  using date function
> >data is something like this
>
> >                                                                                    1 MONTH 12 MONTH
> >MONTH OF    PRICE   PRICE   1 MONTH 3 MONTH         6 MONTH         1 YEAR  2 YEAR  3 YEAR  5
> >YEARS       10 YEARS        TOTAL   TOTAL
> >    CLOSE   CHANGE  % CHANGE        % CHANGE        % CHANGE        % CHANGE        % CHANGE        % CHANGE        %
> >CHANGE      % CHANGE        RETURN  RETURN
> >10/2009     1036.19 -20.88  -1.98%  4.93%   18.72%
> >6.96%       -33.12% -24.80% -8.32%  -23.97% -1.86%  9.80%
>
> What do your acronyms mean?  
>
> There is only one date function and it returns "today's" date.  How
> will that help you calculate the values you want.
>
> We need real data, including variable names, and a precise definition
> of the intended output.  And it would help a whole bunch if you
> figured out a way to present the data clearly taking into account word
> wrap.
>
> --
> Remove del for email

From: Barry Schwarz on 9 Apr 2010 08:22
And you just happen to have multiple gmail accounts?

On Thu, 8 Apr 2010 18:08:12 -0700 (PDT), saurabh modi
<saurabhm17(a)gmail.com> wrote:

>
>Actually I 'm trying to get Month to Date Year to Date, prev. Year
>month to date, prev year to date.
>I 'm trying to create a macro for that and have the date value through
>macro variable.
>
>
>
>On Apr 6, 7:40�pm, Barry Schwarz <schwa...(a)dqel.com> wrote:
>> On Mon, 5 Apr 2010 19:42:53 -0700 (PDT), Sunny <msunn...(a)gmail.com>
>> wrote:
>>
>> >Hello Group,
>>
>> >I 'm trying to get the MTD YTD & PYTD �and PYMTD �using date function
>> >data is something like this
>>
>> > � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �1 MONTH 12 MONTH
>> >MONTH OF � �PRICE � PRICE � 1 MONTH 3 MONTH � � � � 6 MONTH � � � � 1 YEAR �2 YEAR �3 YEAR �5
>> >YEARS � � � 10 YEARS � � � �TOTAL � TOTAL
>> > � �CLOSE � CHANGE �% CHANGE � � � �% CHANGE � � � �% CHANGE � � � �% CHANGE � � � �% CHANGE � � � �% CHANGE � � � �%
>> >CHANGE � � �% CHANGE � � � �RETURN �RETURN
>> >10/2009 � � 1036.19 -20.88 �-1.98% �4.93% � 18.72%
>> >6.96% � � � -33.12% -24.80% -8.32% �-23.97% -1.86% �9.80%
>>
>> What do your acronyms mean? �
>>
>> There is only one date function and it returns "today's" date. �How
>> will that help you calculate the values you want.
>>
>> We need real data, including variable names, and a precise definition
>> of the intended output. �And it would help a whole bunch if you
>> figured out a way to present the data clearly taking into account word
>> wrap.
>>
>> --
>> Remove del for email

--
Remove del for email
 | 
Pages: 1
Prev: SAS - Analysis in DATA Step
Next: Inside the SAS procs.