Date:         Wed, 12 Dec 2007 18:05:28 -0600
Reply-To:     "data _null_," <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_," <datanull@GMAIL.COM>
Subject:      Re: SORTING SAS DATASETS IN A UNIX DATA DIRECTORY
Comments: To: SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@gmail.com>
In-Reply-To:  <200712122323.lBCKKNnG024059@mailgw.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

This might be helpful.  You don't say exactly where you want this data
set name stored.

data
   job_claim_10dec07
   job_claim_11jan07
   job_claim_22jun05
   job_claim_11nov07
   job_claim_19mar06;
   run;

proc sql;
   select memname,input(scan(memname,-1,'_'),date.) as order
format=date. into :member0, :date0
      from dictionary.members
      where libname eq 'WORK' and memname eqt 'JOB'
      order by 2 descending;
   quit;
   run;
%put _user_;


On Dec 12, 2007 5:23 PM, SUBSCRIBE SAS-L Chandra Gadde
<ddraj2015@gmail.com> 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
>