LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2007, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 13 Dec 2007 07:55:01 -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: Sigurd Hermansen <HERMANS1@westat.com>
In-Reply-To:  <CA8F89971ADA9F47A6C915BA2397844207B422E0@MAILBE2.westat.com>
Content-Type: text/plain; charset=ISO-8859-1

I'm thinkin LIBNAME='MYDATA' might be more appropriate, given the code posted.

On Dec 12, 2007 9:40 PM, Sigurd Hermansen <HERMANS1@westat.com> wrote: > 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/ >


Back to: Top of message | Previous page | Main SAS-L page