Date:         Wed, 13 Oct 2004 15:22:38 -0400
Reply-To:     Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Subject:      Re: Parsing the HLQ of a dataset

In some situations you can just declare the period as a delimiter and read
your HLQ (High Level Qaulifier?) directly:

   DATA _NULL_;
   INFILE DATALINES DLM=' .';
   INPUT HLQ $;
   PUT HLQ=;
   DATALINES;
   SGSS.KEITH.DS1
   #SG.RALPH.DS2
   DB2ADMN.DBP1.DATA
   RUN;

On Wed, 13 Oct 2004 09:03:39 -0400, Mike Rhoads <RHOADSM1@WESTAT.COM> wrote:

>Keith,
>
>The SCAN function is what you want.
>
>DATA _NULL_;
>LENGTH DSN $ 44  HLQ $ 8;
>INPUT DSN;
>HLQ = SCAN(DSN,1,'.');
>PUT HLQ=;
>DATALINES;
>SGSS.KEITH.DS1
>#SG.RALPH.DS2
>DB2ADMN.DBP1.DATA
>RUN;
>
>Mike Rhoads
>Westat
>RhoadsM1@Westat.com
>
>-----Original Message-----
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>McWhorter, Keith
>Sent: Wednesday, October 13, 2004 8:46 AM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Parsing the HLQ of a dataset
>
>
>Good morning,
>
>
>
>I'm under the gun to generate a report. I know this must be a simple
>command, but it's not in my SAS vocabulary yet! ;-)
>
>
>
>I'm reading in a 44-character data set name, and want to find the HLQ,
>which can vary in length, but of course is terminated by a period.
>Example:
>
>            SGSS.KEITH.DS1
>
>            #SG.RALPH.DS2
>
>            DB2ADMN.DBP1.DATA
>
>
>
>So the HLQ's are SGSS, #SG and DB2ADMN.  So how is it that I read the
>variable until the first period?
>
>
>
>Many thanks!!!
>
>
>
>(BTW, running SAS 9.1.2 under z/OS 1.4.)
>
>
>
>Keith McWhorter
>
>Senior Systems Programmer
>
>Georgia Technology Authority
>
>404-656-9068