Date:         Mon, 26 Jun 2000 16:14:45 +0100
Reply-To:     David Johnson <David.Johnson@UK.ROYALSUN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     To: rpregenn <rpregenn@HEWITT.COM>
From:         David Johnson <David.Johnson@UK.ROYALSUN.COM>
Subject:      Re: Determine the number of existing titles
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset=iso-8859-1

Ross,

We use the following with a macro process that needs to change footnotes and
reset them.

  Proc SQL _Method STimer NoPrint;
    Select TEXT Into :MFootNte
      From SASHELP.VTITLE
      Where TYPE = 'F'  And  NUMBER = 1;
  Quit;

A title is type 'T' and you can get the highest number from the same
dictionary.  This doesn't tell you how many titles, you'd want a count(*) to be
calculated and populated to a variable for that.  However, it will implicitly
tell you which title number is next free.

regards

David






rpregenn@HEWITT.COM@AKH-WIEN.AC.AT
26/06/2000 15:41
___________________________________________________________________________

Please respond to rpregenn@HEWITT.COM
Sent by: SAS-L@AKH-WIEN.AC.AT
To: SAS-L@AKH-WIEN.AC.AT
cc:

Subject: Determine the number of existing titles

"THIS MESSAGE ORIGINATED ON THE INTERNET - Please read the detailed
disclaimer below"

----------------------------------------------------------------------

I would like to include title statements in a macro I am writting, but I do not
want to overwrite any titles that may exist before the macro call.  Does anyone
have any suggestions for how I can determine the number of existing title
statements?

Thanks in advance,
Ross



----------------------------------------------------------------------
The following message has been automatically added by the mail gateway
to comply with a Royal & Sun Alliance IT Security requirement:

"As this email arrived via the Internet you should be cautious about
its origin and content. Replies which contain sensitive
information or legal/contractual obligations are particularly
vulnerable. In these cases you should not reply unless you are
authorised to do so, and adequate encryption is employed.

If you have any questions, please speak to your local desktop
support team or IT security contact".
----------------------------------------------------------------------