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
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
> -----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.
> 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
> Lebanon, NH USA 03756
> (603) 653-6012 (voice)
> (603) 653-6013 (fax)
> (603) 252-5922 (cell)
> Kevin.F.Spratt@Dartmouth.Edu (e-mail)