|
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
___________________________________________
| 
