Prev: ODS RTF - Grouping
Next: Estimating the value for the functional form of the variance
From: Barry Schwarz on 8 Aug 2010 17:54
On Sun, 8 Aug 2010 06:56:54 -0700 (PDT), Tom Abernathy
<tom.abernathy(a)gmail.com> wrote:

>If you have want to get the last one as another character variable
>then use the SCAN function.
>
>last_date = scan(date,-1,'>');

You probably want scan(date, -1, '->').

>
>If you want to convert it to an actual date then use the INPUT
>function.
>
>ldate = input(last_date,??yymmdd.);
>format ldate yymmddn8.;
>
>
>On Aug 8, 8:27�am, Rob Roszkowski <rob.roszkow...(a)gmail.com> wrote:
>> Hi everyone,
>>
>> I have a real problem on my hands that I need to resolve asap but I
>> don't know how as I have never come across this problem. If anyone can
>> figure this out I truly thank deeply.
>>
>> I have a data set (one of 100) where the date column comes up like
>> this :
>>
>> Date:
>> 20050122->20060121->20070120
>> 20050122->20060121->20070120
>> 20050122->20060121->20070120
>> 20050122->20060121->20070120
>> 20050122
>> 20050123
>> 20050122->20060121
>> 20050256
>> 20050122->20060121

--
Remove del for email
 | 
Pages: 1
Prev: ODS RTF - Grouping
Next: Estimating the value for the functional form of the variance