Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ERROR: There is no data set to modify.

Status
Not open for further replies.

qchac

Programmer
Nov 25, 2005
11
RO
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
 
Raul,
You are trying to make an INDEX on a dataset (table) that has no records. Why not check to see if there are records in the current dataset before you run the PROC DATASET code.
Klaz
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top