Date:         Mon, 19 May 1997 14:29:51 CST
Reply-To:     "Johnson, Bruce" <bjohnson@SACHS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Johnson, Bruce" <bjohnson@SACHS.COM>
Subject:      Re: problem with macro variable reference
Comments: To: "Maria M. Corrada" <mcorrada@WELCHLINK.WELCH.JHU.EDU>

     Try this:
 
     filename test2 "d:\sasdata\icon&fname..dbf";
 
 
______________________________ Reply Separator _________________________________
Subject: problem with macro variable reference
Author:  "Maria M. Corrada" <mcorrada@WELCHLINK.WELCH.JHU.EDU> at Internet
Date:    5/16/97 12:34 PM
 
 
I wonder if someone can help me understand why the following code is not
working. It is probably someting simple but I'm new to macros.
 
%let fname=0597;
filename test2 'd:\sasdata\icon&fname..dbf';
proc dbf db4=test2 out=out2;
 
data main.icon&fname;
     set out2;
     length id 4 contact 4 date 4 typecont 3;
     format id 4. contact 5.2  typecont 2.;
proc contents;
run;
 
It tells me - ERROR: Cannot open DBASE file.
I know is a problem with the way i'm referencing the macro variable
because when I use instead 'd:\sasdata\icon0597.dbf'  the program works
correctly.
 
Any help would be appreciated.
Thanks
 
=====================================
Maria M. Corrada, Sc.M.
Johns Hopkins University
Alzheimer's Disease Research Center
5501 Hopkins Bayview Circle Rm 1B.82
Baltimore, MD 21224
Voice: (410)550-3068
Fax:   (410)550-3369