Date: Tue, 16 Mar 2004 15:06:03 +0100
Reply-To: "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Subject: RE : Data from library on a temporary SAS data set
Content-Type: text/plain; charset="iso-8859-1"
Hi Stéphane,
Well, Christine does not indicate a period in the name (only between the name and the extension). So the reference here should be
file abc "u:\wieck\coest\data\c2files\&R._c2_dout.csv";
where the single period after &R gets removed only, concatenating the value of &R and _c2_dout (or whatever). Double periods are necessary only where a period already is present, including counting the present period.
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: Dennis Diskin [mailto:diskin.dennis@KENDLE.COM]
Sent: Tuesday, March 16, 2004 14:57
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: RE : Data from library on a temporary SAS data set
Christine,
1. When you use a macro variable witihin quotes, you must use double
quotes " instead of single ' for the macro variable to resolve.
2. If you have a period after the macro variable, it needs to be doubled
because the period is used to signal the end of the macro variable, so the
first one is ignored.
Thus your statement would be something like:
file abc "u:\wieck\coest\data\c2files\&R.._c2_dout.csv";
HTH,
Dennis Diskin
Christine Wieck <wieck@AGP.UNI-BONN.DE>
Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
03/16/2004 08:44 AM
Please respond to Christine Wieck
To: SAS-L@LISTSERV.UGA.EDU
cc:
Subject: Re: RE : Data from library on a temporary SAS data set
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
___________________________________________
