Date:         Thu, 21 Sep 2006 19:29:25 -0700
Reply-To:     Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: Error handling in a macro
In-Reply-To:  <8AD8F86B3312F24CB432CEDDA71889F2026DF873@ex06.GHCMASTER.GHC.ORG>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

on 9/20/2006 2:34 PM Pardee, Roy said the following:
> I believe you can query the # of rows/columns in a dset out of
> dictionary.tables.  Search help for 'dictionary tables' & you should
> come to some useful stuff...

For some kinds of tables.  You have to know how the data set was created
and potentially modified to determine whether this approach will work
for you.


>
> HTH,
>
> -Roy
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Kevin F. Spratt
> Sent: Wednesday, September 20, 2006 2:16 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Error handling in a macro
>
> Suppose you have a macro that calls for three parameters,
>
> A = a SAS data set with the raw data
> B = no of groups (NG)
> C = a 2nd SAS data set.
>
> If the second data set is not specified (no data set present) or when it
> is converted to a matrix that is not NG x NG I would like to keep the
> macro from bombing by substituting an NG X NG identity matrix.
>
> How?
>
> I'm running SAS 9.1.3 on Windows XP Professional.
>
> I saw in the archives an old SAS-L posting that featured a function
> called dsnexst that checked for the existence of a SAS data set in the
> MVS OS environment but have not seen (or don't know how to look for)
> anything similar in SAS 9.1 under Windows.
>
> As always, any assistance greatly appreciated.
>
>
>
> ______________________________________________________________________
>
> Kevin F. Spratt, Ph.D.
> Department of Orthopaedic Surgery
> Dartmouth Medical School
> One Medical Center Drive
> DHMC
> Lebanon, NH   USA  03756
> (603) 653-6012                          (voice)
> (603) 653-6013                          (fax)
> (603) 252-5922                          (cell)
> Kevin.F.Spratt@Dartmouth.Edu            (e-mail)
> _______________________________________________________________________