I have the following error:
NOTE: Moving DONNEES.FIWM014C to WRKCHGT.FIWM014C (memtype=DATA).
NOTE: There were 0 observations read from the data set DONNEES.FIWM014C.
NOTE: The data set WRKCHGT.FIWM014C has 0 observations and 25 variables.
NOTE: PROCEDURE DATASETS used:
real time 0.12 seconds
cpu time 0.03 seconds
NOTE: There were 0 observations read from the data set WRKCHGT.FIWM014C.
11 The SAS System 14:39 Wednesday, July 5, 2006
NOTE: The data set DONNEES.FIWM014C has 0 observations and 25 variables.
NOTE: The data set DONNEES.FIWM014C_SEPHO has 0 observations and 25 variables.
NOTE: The data set RECYCLE.FIWM014C has 0 observations and 25 variables.
NOTE: DATA statement used:
real time 0.33 seconds
cpu time 0.04 seconds
ERROR: There is no data set to modify.
ERROR: There is no data set to modify.
ERROR: There is no data set to modify.
NOTE: Statements not processed because of errors noted above.
NOTE: The SAS System stopped processing this step because of errors.
Here is the source of the program:
%let table=&sysparm; /* Le nom de la table est passé en parametre lors de l'appel */
libname wrkchgt clear;
libname wrkchgt '/workspace/chg6283';
* libname wrkchgt 'c:\temp';
* libname donnees 'C:\Documents and Settings\Administrator\My Documents\My SAS Files\V8\data';
* %let table='fiwm010r' 'fiwm014t' 'fiwm014c' 'fiwm015t' 'fiwm015c' 'fiwm016t' 'fiwm016c' 'fiwm01at' 'fiwm01ac';
%put "sysparm table="&table;
%macro rattra;
proc datasets lib=donnees nolist;
copy out=wrkchgt move;
select &table;
quit;
/* déplacer la table depuis donnees ou recycle vers wrkchgt */
data donnees.&table
donnees.&table._sepho
recycle.&table
;
attrib NUM_PROG length=4
CLI length=7 format=F14. informat=F14.
CONT length=4 format=F7. informat=F7.
NUM_EVT length=6
TYP_EVTV length=4
VAL_EVT length=4
VAL_PUE length=4
MT_EU length=6
MT_DE length=6
QTE length=4
NBR_UE length=6
NUM_PRD length=6
COD_PROV length=4
VAL_PAI length=4
DATE_CRE length=6 format=DDMMYY10. informat=DATE9.
DATE_EVT length=6 format=DDMMYY10. informat=DATE9.
NUM_ENT length=6
UNIT_MES length=6
COD_OEVT length=4
NUM_OP length=$8
COD_PRD length=$5
SIG_CRE length=$6
SIG_CREA length=$3
DATE_CREA length=6 format=DDMMYY10.
;
set wrkchgt.&table;
/* faire un drop des 2 variables cli et cont */
%if &table = fiwm010r %then %do;
drop CLI CONT;
%end;
if SIG_CREA = 'FIW' then SIG_CREA = 'M10';
if NUM_PROG = 1 and
CONT = 3301
then
output donnees.&table._sepho;
else
output donnees.&table;
run;
Proc datasets lib=donnees nolist;
index create PROGEVT=(NUM_PROG NUM_EVT);
index create CLICONT=(NUM_PROG CLI CONT);
run;quit;
%mend;
%rattra;
[/color red]
Thanks,
Raul
NOTE: Moving DONNEES.FIWM014C to WRKCHGT.FIWM014C (memtype=DATA).
NOTE: There were 0 observations read from the data set DONNEES.FIWM014C.
NOTE: The data set WRKCHGT.FIWM014C has 0 observations and 25 variables.
NOTE: PROCEDURE DATASETS used:
real time 0.12 seconds
cpu time 0.03 seconds
NOTE: There were 0 observations read from the data set WRKCHGT.FIWM014C.
11 The SAS System 14:39 Wednesday, July 5, 2006
NOTE: The data set DONNEES.FIWM014C has 0 observations and 25 variables.
NOTE: The data set DONNEES.FIWM014C_SEPHO has 0 observations and 25 variables.
NOTE: The data set RECYCLE.FIWM014C has 0 observations and 25 variables.
NOTE: DATA statement used:
real time 0.33 seconds
cpu time 0.04 seconds
ERROR: There is no data set to modify.
ERROR: There is no data set to modify.
ERROR: There is no data set to modify.
NOTE: Statements not processed because of errors noted above.
NOTE: The SAS System stopped processing this step because of errors.
Here is the source of the program:
%let table=&sysparm; /* Le nom de la table est passé en parametre lors de l'appel */
libname wrkchgt clear;
libname wrkchgt '/workspace/chg6283';
* libname wrkchgt 'c:\temp';
* libname donnees 'C:\Documents and Settings\Administrator\My Documents\My SAS Files\V8\data';
* %let table='fiwm010r' 'fiwm014t' 'fiwm014c' 'fiwm015t' 'fiwm015c' 'fiwm016t' 'fiwm016c' 'fiwm01at' 'fiwm01ac';
%put "sysparm table="&table;
%macro rattra;
proc datasets lib=donnees nolist;
copy out=wrkchgt move;
select &table;
quit;
/* déplacer la table depuis donnees ou recycle vers wrkchgt */
data donnees.&table
donnees.&table._sepho
recycle.&table
;
attrib NUM_PROG length=4
CLI length=7 format=F14. informat=F14.
CONT length=4 format=F7. informat=F7.
NUM_EVT length=6
TYP_EVTV length=4
VAL_EVT length=4
VAL_PUE length=4
MT_EU length=6
MT_DE length=6
QTE length=4
NBR_UE length=6
NUM_PRD length=6
COD_PROV length=4
VAL_PAI length=4
DATE_CRE length=6 format=DDMMYY10. informat=DATE9.
DATE_EVT length=6 format=DDMMYY10. informat=DATE9.
NUM_ENT length=6
UNIT_MES length=6
COD_OEVT length=4
NUM_OP length=$8
COD_PRD length=$5
SIG_CRE length=$6
SIG_CREA length=$3
DATE_CREA length=6 format=DDMMYY10.
;
set wrkchgt.&table;
/* faire un drop des 2 variables cli et cont */
%if &table = fiwm010r %then %do;
drop CLI CONT;
%end;
if SIG_CREA = 'FIW' then SIG_CREA = 'M10';
if NUM_PROG = 1 and
CONT = 3301
then
output donnees.&table._sepho;
else
output donnees.&table;
run;
Proc datasets lib=donnees nolist;
index create PROGEVT=(NUM_PROG NUM_EVT);
index create CLICONT=(NUM_PROG CLI CONT);
run;quit;
%mend;
%rattra;
[/color red]
Thanks,
Raul