Date:         Wed, 12 Dec 2007 22:40:51 -0500
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: SORTING SAS DATASETS IN A UNIX DATA DIRECTORY
Comments: To: SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL.COM>,
          "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
In-Reply-To:  <200712130315.lBCNYNvc030720@malibu.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Try ... where libname='WORK' (DICTIONARY dataset libraries and column
names always in upper case).
S

-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of SUBSCRIBE SAS-L Chandra Gadde
Sent: Wednesday, December 12, 2007 10:15 PM
To: SAS-L@LISTSERV.UGA.EDU; Richard A. DeVenezia
Subject: Re: SORTING SAS DATASETS IN A UNIX DATA DIRECTORY


Richard,

I have this error message.

1    libname mydata '/home/t11/jobs';
NOTE: Libref MYDATA was successfully assigned as follows:
      Engine:        V9
      Physical Name: /home/t11/jobs
2    proc sql noprint;
3      select
4          cats(libname,'.',memname) format=$41.
5        , input(scan(memname,-1,'_'),date7.) as date format=date7.
6      into
7          :table
8        , :date
9      from
10     dictionary.tables
11     where libname='work'
12     and memname like 'A_%'
13     having date=max(date)
14     ;
NOTE: The query requires remerging summary statistics back with the
original data.
NOTE: No rows were selected.
15   quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.02 seconds
      cpu time            0.02 seconds


WARNING: Apparent symbolic reference TABLE not resolved.
WARNING: Apparent symbolic reference DATE not resolved.
16   %put &table | &date;
&table | &date

On Wed, 12 Dec 2007 19:44:21 -0500, Richard A. DeVenezia
<rdevenezia@WILDBLUE.NET> wrote:

>Chandra Gadde wrote:
>> Hi All,
>>
>>
>> I have several sas datasets in one unix data directory. Some of them
>> follow this pattern.
>>
>> job_claim_10dec07.sas7bdat
>> job_claim_11jan07.sas7bdat
>> job_claim_22jun05.sas7bdat
>> job_claim_11nov07.sas7bdat
>> job_claim_19mar06.sas7bdat
>>
>>
>>
>> and so forth.
>>
>> I need to sort these data sets, in the ascending order of DDMONYY
>> extension. In other words, after sorting I should see the sas
>> datasets in the following way and pick up the latest sas program. My
>> goal is to identify the latest SAS dataset being created. I need to
>> identify the latest SAS dataset and use that in my new sas PROGRAM I
>> am creating. Any help would be greatly appreciated.
>>
>> job_claim_22jun05.sas7bdat
>> job_claim_19mar06.sas7bdat
>> job_claim_11jan07.sas7bdat
>> job_claim_11nov07.sas7bdat
>> job_claim_10dec07.sas7bdat
>
>libname mydata "path to directory";
>
>proc sql noprint;
>  select
>      cats(libname,'.',memname) format=$41.
>    , input(scan(memname,-1,'_'),date7.) as date format=date7.
>  into
>      :table
>    , :date
>  from
>  dictionary.tables
>  where libname="WORK"
>  and memname like 'A_%'
>  having date=max(date)
>  ;
>quit;
>
>%put &table | &date;
>
>
>--
>Richard A. DeVenezia
>http://www.devenezia.com/