Date:         Tue, 16 Mar 2004 14:44:37 +0100
Reply-To:     Christine Wieck <wieck@AGP.UNI-BONN.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Christine Wieck <wieck@AGP.UNI-BONN.DE>
Subject:      Re: RE : Data from library on a temporary SAS data set
Comments: To: "Groeneveld, Jim" <jim.groeneveld@vitatron.com>,
          Datametric <datametric@CLUB-INTERNET.FR>
In-Reply-To:  <81BFA8F7807F1349AD6C16AD00A1AB9BD3A827@AMSM1BMSGM01.ent.core.medtronic.com>
Content-Type: text/plain; charset="ISO-8859-1"

Dear Jim and Stéphane,

it seems, that this macro variable doesn't work at all with file references because I always get the error message:

ERROR: Physical file does not exist, u:\wieck\coest\data\c2files\&R._c2_dout.csv.

I have SAS version 8.2

Whereas, with the put statement, it works fine.

Regards, Christine


*********** REPLY SEPARATOR  ***********

On 16/03/2004 at 14:34 Groeneveld, Jim wrote:

>Hi Stéphane,
>
>Be careful, I think your code
>
>file in     u:\est\&R_data.csv
>file out   u:\est\&R_est.gms
>file out1 u:\est\&R_tval.gms
>
>should read, including a period:
>
>file in     u:\est\&R._data.csv
>file out   u:\est\&R._est.gms
>file out1 u:\est\&R._tval.gms
>
>because otherwise it would look for the macro variables R_data etc. The
>underline is a valid character in macro variable names as well.
>
>Regards - Jim.
>--
>.  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .
>
>Jim Groeneveld, MSc.
>Biostatistician
>Science Team
>Vitatron B.V.
>Meander 1051
>6825 MJ  Arnhem
>Tel: +31/0 26 376 7365
>Fax: +31/0 26 376 7305
>Jim.Groeneveld@Vitatron.com
>www.vitatron.com
>
>My computer remains home, but I will attend SUGI 2004.
>
>[common disclaimer]
>
>
>-----Original Message-----
>From: Datametric [mailto:datametric@CLUB-INTERNET.FR]
>Sent: Tuesday, March 16, 2004 13:58
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: RE : Data from library on a temporary SAS data set
>
>
>Hi,
>
>In order to resolve your problem, you have to create a macro variable :
>
>%let R = 360nc;
>
>file in     u:\est\&R_data.csv
>file out   u:\est\&R_est.gms
>file out1 u:\est\&R_tval.gms
>
>Be careful with the step :
>
>DATA _NULL_;
>set estimates;
>file out1;
>put "EST_360nc.C10" C10;
>put "EST_360nc.C11" C11;
>
>With the macro variable, you must use 2 dots with the object1.object2 form
>name :
>
>DATA _NULL_;
>set estimates;
>file out1;
>put "EST_&R..C10" C10;
>put "EST_&R..C11" C11;
>
>
>Stéphane.
>
>
>-----Message d'origine-----
>De : SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] De la part de
>Christine Wieck
>Envoyé : mardi 16 mars 2004 13:47
>À : SAS-L@LISTSERV.UGA.EDU
>Objet : Re: Data from library on a temporary SAS data set
>
>
>Dear SAS-Experts,
>
>thanks for the hints to solve my problem.
>
>Regarding your proposals with the macro variable, I have a second question:
>
>I do my estimations for several regions, therefore I have several data
>files. I have to address these regions at several places in my SAS program
>for in-and outputting and I try (since several days) to do this over some
>string variable or so which is just defined once and then used at several
>places (as I know it from Eviews and GAMS).
>
>I have the feeling that this could be done by this macro variable but
>couldn't find any reference to this in the user guides.
>
>My program looks like the following:
>
>------------------------------------
>
>file in     u:\est\360nc_data.csv
>file out   u:\est\360nc_est.gms
>file out1 u:\est\360nc_tval.gms
>
>data ...
>
>proc means...
>
>proc model....
>title '360nc'
>
>proc print....
>
>DATA _NULL_;
>set estimates;
>file out1;
>put "EST_360nc.C10" C10;
>put "EST_360nc.C11" C11;
>.....
>----------------------------------------
>
>I would like to replace this '360nc' by some variable.
>
>e.g.
>%R% = 360nc;
>
>file in     u:\est\%R%_data.csv
>file out   u:\est\%R%_est.gms
>file out1 u:\est\%R%_tval.gms
>
>Any advice?
>
>Thanks in advance,
>
>regards, Christine
>__________________________________________
>
>Dipl.- Ing. agr. Christine Wieck
>Institute for Agricultural Policy,
>Market Research and Economic Sociology
>Bonn University
>
>Nussallee 21
>D - 53115 Bonn
>Germany
>
>Phone: +49-228-73 23 26
>Fax:     +49-228-73 46 93
>e-mail: wieck@agp.uni-bonn.de
>Internet: http://www.agp.uni-bonn.de/agpo/staff/wieck/wieck_e.htm
>___________________________________________


__________________________________________

Dipl.- Ing. agr. Christine Wieck
Institute for Agricultural Policy,
Market Research and Economic Sociology
Bonn University

Nussallee 21
D - 53115 Bonn
Germany

Phone: +49-228-73 23 26
Fax:     +49-228-73 46 93
e-mail: wieck@agp.uni-bonn.de
Internet: http://www.agp.uni-bonn.de/agpo/staff/wieck/wieck_e.htm
___________________________________________