DATA Step, Macro, Functions and more

Macro Loop Over fail

Reply
Contributor
Posts: 44

Macro Loop Over fail

Hello,

I'm trying to work through a macro that continually fails.  This is a macro that should continue to loop and provide multiple output in the results. The error states that I am missing the variable 'Opco' but I have it listed in all my of data step codes.  

 

 

Here is the Error Log (Most of it, it is long error message).

libname weather2 meta library="weather2" metaout=data;
options symbolgen threads cpucount=actual cleanup;

   
%macro get_filenames(location);
filename _dir_ "%bquote(&location.)";
DATA filenames(keep=memname);
  handle=dopen( '_dir_' );
  if handle > 0 then DO;
    count=dnum(handle);
    DO i=1 to count;
      memname=dread(handle,i);
      output filenames;
    end;
  end;
  rc=dclose(handle);
run;
filename _dir_ clear;
%mend;


%get_filenames(/sas/data/imports);
 


data filenames (keep=memname opco);
   set filenames;
   if (substr(memname,1,6)="wbank_");
   opco = substr(memname,7,3);    *** created variable from positions 7-9: ace dpl pep*;
run;

proc sort data=filenames;
   by opco descending memname;
run;



data filenames;
   set filenames;
   by opco descending memname;
   if first.opco;
run;




 %macro LoopOverDatasets();
 %local datasetCount iter fullname;

 /***********************************************************************/;
 /*  Get number of datasets by counting the records in work.filenames   */;
 /***********************************************************************/;



proc sql noprint;
  select count(*)
  into :datasetCount
  from WORK.filenames;
quit;
  



/*initiate do-loop */;

%let iter=1;   ************ set to 3 to limit procedures;

%do	%while (&iter.<= &datasetCount. );

Proc sort data=filenames (keep=memname opco);  										
   by opco descending memname;  

    /* create variable fullname to retrieve weather data  */;

data work.dataset_list;
   set filenames (firstobs=&iter. obs=&iter.); *only read 1 record;
   by opco descending memname;
   Length passname $41.;
   locname = "'/sas/data/imports/";
   passname = catt(locname,memname);
   fullname = catt(passname,"'");
   output;
run;



Proc sql;
   select fullname
   into :fullname
   from work.dataset_list;
 
filename in_dat &fullname. lrecl=160;

proc import datafile= in_dat 
  dbms=dlm
  out=weath_updt
  replace;
  delimiter='09'x;
  getnames=no;
run; 

data weath_updt(drop=var3 var14 var15 pt yr mo da);
  set weath_updt;
  if var1 = 'CODE' THEN DELETE;
  rename var1 = CODE
         var2 = STATUS
		 var4 = TMP
		 var5 = DPT
		 var6 = HUM 
		 var7 = HID 
		 var8 = WCL 
		 var9 = WDR
		 var10 = WSP 
		 var11 = WET 
		 var12 = CC 
		 var13 = SSM;
  pt=index(var3," ");
  yr = substr(var3,1,4);
  mo = substr(var3,6,2);
  da = substr(var3,9,2);
  /*  HR = sum(substr(var3,pt+1),1);  */
  HOUR = sum(substr(var3,pt+1),1);
  DATE = mdy(mo,da,yr);
  format DATE date7.;
run;

data updt_data 
     updt_forecast;
   set weath_updt;  

   

 tmp_new=input(TMP,best8.); 										
 dpt_new=input(DPT,best8.); 
 hum_new=input(HUM,best8.);
 hid_new=input(HID,best8.); 
 wcl_new=input(WCL,best8.);
 wdr_new=input(WCL,best8.);
 wsp_new=input(WCL,best8.);
 wet_new=input(WCL,best8.);
 cc_new=input(WCL,best8.);
 ssm_new=input(WCL,best8.);


   if status = "O" then output updt_data;
     else output updt_forecast;	 

drop TMP;	 	
drop DPT;			
drop HUM; 			
drop HID; 	
drop WCL;			
drop WDR;			
drop WSP;			
drop WET;	
drop CC ;		
drop SSM;	

rename tmp_new=TMP;
rename dpt_new=DPT;
rename hum_new=HUM;
rename hid_new=HID;
rename wcl_new=WCL;
rename wdr_new=WDR;
rename wsp_new=WSP;
rename wet_new=WET;
rename cc_new=CC;	
rename ssm_new=SSM;

run;



data Weather_data_2;
   /*Set Weather2.Weather_data2; */					
Set Weather2.Weather_ACTUAL;


proc sort data=Weather_data_2;
   by DATE HOUR/*HR*/;
run;


proc sort data=updt_data;
   by DATE HOUR/*HR*/;
run;


data weather2.Weather_data_2b;
   merge Weather_data_2(in=w) updt_data(in=u);
   by DATE HOUR/*HR*/;
   if (w) or (u and not w);
run;


data Weather_Frcast;
   Set Weather2.Weather_Forecast;



 tmp_new=input(TMP,best8.); 
 dpt_new=input(DPT,best8.); 
 hum_new=input(HUM,best8.);
 hid_new=input(HID,best8.); 
 wcl_new=input(WCL,best8.);
 wdr_new=input(WCL,best8.);
 wsp_new=input(WCL,best8.);
 wet_new=input(WCL,best8.);
 cc_new=input(WCL,best8.);
 ssm_new=input(WCL,best8.);

drop TMP;	 	
drop DPT;			
drop HUM; 			
drop HID; 	
drop WCL;			
drop WDR;			
drop WSP;			
drop WET;	
drop CC ;		
drop SSM;	

rename tmp_new=TMP;
rename dpt_new=DPT;
rename hum_new=HUM;
rename hid_new=HID;
rename wcl_new=WCL;
rename wdr_new=WDR;
rename wsp_new=WSP;
rename wet_new=WET;
rename cc_new=CC;	
rename ssm_new=SSM;

/***********************************************************************************/


proc sort data=Weather_Frcast;
   by DATE /*HOUR*/ HR;
run;

proc sort data=updt_forecast;
   by DATE HOUR;
  run;


  		
data updt_forecast;
set updt_forecast;
HR=Hour;
drop hour;
run;
	


data Weather_Frcast;
   merge Weather_Frcast(in=w) updt_forecast(in=u);
   by DATE HR;
   if (w) or (u and not w);
run;

proc sort data=Weather_Frcast;
   by DATE /*HOUR*/ HR;


data Weather2.WForecast;
   set Weather_Frcast;
run;

	

    /*increment the iterator of the loop*/;

%let iter=%eval(&iter.+1);

%end;  *end of do-loop;
%MEND LoopOverDatasets; 




/* Recreate file list to prove the update files have been removed. ;   */
 
%macro get_filenames(location);
filename _dir_ "%bquote(&location.)";
data filenames(keep=memname opco); 																 
  handle=dopen( '_dir_' );
  if handle > 0 then do;
    count=dnum(handle);
    do i=1 to count;
      memname=dread(handle,i);
      output filenames;
    end;
  end;
  rc=dclose(handle);
run;
filename _dir_ clear;
%mend;

%get_filenames(/sas/data/imports);

 

 
data filenames;
   set filenames;
   by opco descending memname;
  if first.opco; 

data filenames;
   set filenames;
   proc print;
   title "list most recent" ;
run;


/*
%mend;

/*call the macro for next pass through list of filenames*/



%LoopOverDatasets()
run;

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WEATHER2.WFORECAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 149

SYMBOLGEN: Macro variable ITER resolves to 150

SYMBOLGEN: Macro variable DATASETCOUNT resolves to 157

ERROR: The variable opco in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 150

SYMBOLGEN: Macro variable ITER resolves to 150

ERROR: BY variable opco is not on input data set WORK.FILENAMES.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.DATASET_LIST may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set WORK.DATASET_LIST was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.02 seconds

 

NOTE: No rows were selected.

SYMBOLGEN: Macro variable FULLNAME resolves to

ERROR: Invalid physical name.

ERROR: Error in the FILENAME statement.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.02 seconds

cpu time 0.02 seconds

 

 

ERROR: File WORK.WEATH_UPDT.DATA does not exist.

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

353:153 353:178 353:203 353:228 353:9

NOTE: Character values have been converted to numeric values at the places given by: (Line)Smiley SadColumn).

479 The SAS System 08:40 Friday, November 10, 2017

353:2 353:37 353:40 353:43

WARNING: The variable var14 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var15 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var2 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var4 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var5 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var6 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var7 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var8 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var9 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var10 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var11 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var12 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var13 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.WEATH_UPDT may be incomplete. When this step was stopped there were 0 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

35189:154 35189:193 35189:222 35189:250 353:27 353:55 353:83 353:111 353:138 353:166

NOTE: Variable TMP is uninitialized.

NOTE: Variable DPT is uninitialized.

NOTE: Variable HUM is uninitialized.

NOTE: Variable HID is uninitialized.

NOTE: Variable WCL is uninitialized.

NOTE: Variable status is uninitialized.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: There were 0 observations read from the data set WORK.WEATH_UPDT.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

NOTE: There were 948656 observations read from the data set WEATHER2.WEATHER_ACTUAL.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.38 seconds

cpu time 0.38 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

480 The SAS System 08:40 Friday, November 10, 2017

NOTE: PROCEDURE SORT used (Total process time):

real time 0.33 seconds

cpu time 0.73 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: There were 0 observations read from the data set WORK.UPDT_DATA.

NOTE: The data set WEATHER2.WEATHER_DATA_2B has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.41 seconds

cpu time 0.41 seconds

 

 

NOTE: There were 307 observations read from the data set WEATHER2.WEATHER_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

481 The SAS System 08:40 Friday, November 10, 2017

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WEATHER2.WFORECAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 150

SYMBOLGEN: Macro variable ITER resolves to 151

SYMBOLGEN: Macro variable DATASETCOUNT resolves to 157

ERROR: The variable opco in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 151

SYMBOLGEN: Macro variable ITER resolves to 151

ERROR: BY variable opco is not on input data set WORK.FILENAMES.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.DATASET_LIST may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set WORK.DATASET_LIST was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: No rows were selected.

SYMBOLGEN: Macro variable FULLNAME resolves to

ERROR: Invalid physical name.

ERROR: Error in the FILENAME statement.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.02 seconds

482 The SAS System 08:40 Friday, November 10, 2017

cpu time 0.02 seconds

 

 

ERROR: File WORK.WEATH_UPDT.DATA does not exist.

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

353:153 353:178 353:203 353:228 353:9

NOTE: Character values have been converted to numeric values at the places given by: (Line)Smiley SadColumn).

353:2 353:37 353:40 353:43

WARNING: The variable var14 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var15 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var2 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var4 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var5 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var6 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var7 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var8 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var9 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var10 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var11 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var12 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var13 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.WEATH_UPDT may be incomplete. When this step was stopped there were 0 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

35228:154 35228:193 35228:222 35228:250 353:27 353:55 353:83 353:111 353:138 353:166

NOTE: Variable TMP is uninitialized.

NOTE: Variable DPT is uninitialized.

NOTE: Variable HUM is uninitialized.

NOTE: Variable HID is uninitialized.

NOTE: Variable WCL is uninitialized.

NOTE: Variable status is uninitialized.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: There were 0 observations read from the data set WORK.WEATH_UPDT.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.02 seconds

 

NOTE: There were 948656 observations read from the data set WEATHER2.WEATHER_ACTUAL.

483 The SAS System 08:40 Friday, November 10, 2017

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.38 seconds

cpu time 0.39 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.32 seconds

cpu time 0.70 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: There were 0 observations read from the data set WORK.UPDT_DATA.

NOTE: The data set WEATHER2.WEATHER_DATA_2B has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.41 seconds

cpu time 0.42 seconds

 

 

NOTE: There were 307 observations read from the data set WEATHER2.WEATHER_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

484 The SAS System 08:40 Friday, November 10, 2017

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WEATHER2.WFORECAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 151

SYMBOLGEN: Macro variable ITER resolves to 152

SYMBOLGEN: Macro variable DATASETCOUNT resolves to 157

ERROR: The variable opco in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 152

SYMBOLGEN: Macro variable ITER resolves to 152

ERROR: BY variable opco is not on input data set WORK.FILENAMES.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.DATASET_LIST may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set WORK.DATASET_LIST was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

NOTE: No rows were selected.

SYMBOLGEN: Macro variable FULLNAME resolves to

ERROR: Invalid physical name.

ERROR: Error in the FILENAME statement.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

485 The SAS System 08:40 Friday, November 10, 2017

 

 

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.02 seconds

cpu time 0.03 seconds

 

 

ERROR: File WORK.WEATH_UPDT.DATA does not exist.

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

353:153 353:178 353:203 353:228 353:9

NOTE: Character values have been converted to numeric values at the places given by: (Line)Smiley SadColumn).

353:2 353:37 353:40 353:43

WARNING: The variable var14 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var15 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var2 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var4 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var5 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var6 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var7 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var8 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var9 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var10 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var11 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var12 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var13 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.WEATH_UPDT may be incomplete. When this step was stopped there were 0 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

35267:154 35267:193 35267:222 35267:250 353:27 353:55 353:83 353:111 353:138 353:166

NOTE: Variable TMP is uninitialized.

NOTE: Variable DPT is uninitialized.

NOTE: Variable HUM is uninitialized.

NOTE: Variable HID is uninitialized.

NOTE: Variable WCL is uninitialized.

NOTE: Variable status is uninitialized.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

486 The SAS System 08:40 Friday, November 10, 2017

NOTE: There were 0 observations read from the data set WORK.WEATH_UPDT.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 948656 observations read from the data set WEATHER2.WEATHER_ACTUAL.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.41 seconds

cpu time 0.39 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.33 seconds

cpu time 0.72 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: There were 0 observations read from the data set WORK.UPDT_DATA.

NOTE: The data set WEATHER2.WEATHER_DATA_2B has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.41 seconds

cpu time 0.41 seconds

 

 

NOTE: There were 307 observations read from the data set WEATHER2.WEATHER_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Input data set is empty.

487 The SAS System 08:40 Friday, November 10, 2017

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WEATHER2.WFORECAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.02 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 152

SYMBOLGEN: Macro variable ITER resolves to 153

SYMBOLGEN: Macro variable DATASETCOUNT resolves to 157

ERROR: The variable opco in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 153

SYMBOLGEN: Macro variable ITER resolves to 153

ERROR: BY variable opco is not on input data set WORK.FILENAMES.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.DATASET_LIST may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set WORK.DATASET_LIST was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

488 The SAS System 08:40 Friday, November 10, 2017

 

NOTE: No rows were selected.

SYMBOLGEN: Macro variable FULLNAME resolves to

ERROR: Invalid physical name.

ERROR: Error in the FILENAME statement.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.02 seconds

cpu time 0.02 seconds

 

 

ERROR: File WORK.WEATH_UPDT.DATA does not exist.

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

353:153 353:178 353:203 353:228 353:9

NOTE: Character values have been converted to numeric values at the places given by: (Line)Smiley SadColumn).

353:2 353:37 353:40 353:43

WARNING: The variable var14 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var15 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var2 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var4 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var5 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var6 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var7 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var8 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var9 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var10 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var11 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var12 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var13 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.WEATH_UPDT may be incomplete. When this step was stopped there were 0 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

35306:154 35306:193 35306:222 35306:250 353:27 353:55 353:83 353:111 353:138 353:166

NOTE: Variable TMP is uninitialized.

NOTE: Variable DPT is uninitialized.

NOTE: Variable HUM is uninitialized.

NOTE: Variable HID is uninitialized.

NOTE: Variable WCL is uninitialized.

NOTE: Variable status is uninitialized.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

489 The SAS System 08:40 Friday, November 10, 2017

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: There were 0 observations read from the data set WORK.WEATH_UPDT.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

NOTE: There were 948656 observations read from the data set WEATHER2.WEATHER_ACTUAL.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.38 seconds

cpu time 0.39 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.34 seconds

cpu time 0.74 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: There were 0 observations read from the data set WORK.UPDT_DATA.

NOTE: The data set WEATHER2.WEATHER_DATA_2B has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.44 seconds

cpu time 0.43 seconds

 

 

NOTE: There were 307 observations read from the data set WEATHER2.WEATHER_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

490 The SAS System 08:40 Friday, November 10, 2017

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WEATHER2.WFORECAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 153

SYMBOLGEN: Macro variable ITER resolves to 154

SYMBOLGEN: Macro variable DATASETCOUNT resolves to 157

ERROR: The variable opco in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 154

SYMBOLGEN: Macro variable ITER resolves to 154

491 The SAS System 08:40 Friday, November 10, 2017

 

ERROR: BY variable opco is not on input data set WORK.FILENAMES.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.DATASET_LIST may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set WORK.DATASET_LIST was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: No rows were selected.

SYMBOLGEN: Macro variable FULLNAME resolves to

ERROR: Invalid physical name.

ERROR: Error in the FILENAME statement.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.02 seconds

cpu time 0.03 seconds

 

 

ERROR: File WORK.WEATH_UPDT.DATA does not exist.

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

353:153 353:178 353:203 353:228 353:9

NOTE: Character values have been converted to numeric values at the places given by: (Line)Smiley SadColumn).

353:2 353:37 353:40 353:43

WARNING: The variable var14 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var15 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var2 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var4 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var5 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var6 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var7 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var8 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var9 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var10 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var11 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var12 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var13 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.WEATH_UPDT may be incomplete. When this step was stopped there were 0 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

492 The SAS System 08:40 Friday, November 10, 2017

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

35345:154 35345:193 35345:222 35345:250 353:27 353:55 353:83 353:111 353:138 353:166

NOTE: Variable TMP is uninitialized.

NOTE: Variable DPT is uninitialized.

NOTE: Variable HUM is uninitialized.

NOTE: Variable HID is uninitialized.

NOTE: Variable WCL is uninitialized.

NOTE: Variable status is uninitialized.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: There were 0 observations read from the data set WORK.WEATH_UPDT.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

NOTE: There were 948656 observations read from the data set WEATHER2.WEATHER_ACTUAL.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.39 seconds

cpu time 0.40 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.34 seconds

cpu time 0.72 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: There were 0 observations read from the data set WORK.UPDT_DATA.

NOTE: The data set WEATHER2.WEATHER_DATA_2B has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.41 seconds

cpu time 0.40 seconds

 

493 The SAS System 08:40 Friday, November 10, 2017

 

NOTE: There were 307 observations read from the data set WEATHER2.WEATHER_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.02 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WEATHER2.WFORECAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 154

SYMBOLGEN: Macro variable ITER resolves to 155

SYMBOLGEN: Macro variable DATASETCOUNT resolves to 157

ERROR: The variable opco in the DROP, KEEP, or RENAME list has never been referenced.

494 The SAS System 08:40 Friday, November 10, 2017

 

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 155

SYMBOLGEN: Macro variable ITER resolves to 155

ERROR: BY variable opco is not on input data set WORK.FILENAMES.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.DATASET_LIST may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set WORK.DATASET_LIST was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: No rows were selected.

SYMBOLGEN: Macro variable FULLNAME resolves to

ERROR: Invalid physical name.

ERROR: Error in the FILENAME statement.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.02 seconds

 

 

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.02 seconds

cpu time 0.02 seconds

 

 

ERROR: File WORK.WEATH_UPDT.DATA does not exist.

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

353:153 353:178 353:203 353:228 353:9

NOTE: Character values have been converted to numeric values at the places given by: (Line)Smiley SadColumn).

353:2 353:37 353:40 353:43

WARNING: The variable var14 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var15 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var2 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var4 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var5 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var6 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var7 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var8 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var9 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var10 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var11 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var12 in the DROP, KEEP, or RENAME list has never been referenced.

495 The SAS System 08:40 Friday, November 10, 2017

WARNING: The variable var13 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.WEATH_UPDT may be incomplete. When this step was stopped there were 0 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

35384:154 35384:193 35384:222 35384:250 353:27 353:55 353:83 353:111 353:138 353:166

NOTE: Variable TMP is uninitialized.

NOTE: Variable DPT is uninitialized.

NOTE: Variable HUM is uninitialized.

NOTE: Variable HID is uninitialized.

NOTE: Variable WCL is uninitialized.

NOTE: Variable status is uninitialized.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: There were 0 observations read from the data set WORK.WEATH_UPDT.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 948656 observations read from the data set WEATHER2.WEATHER_ACTUAL.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.39 seconds

cpu time 0.40 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.33 seconds

cpu time 0.72 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

496 The SAS System 08:40 Friday, November 10, 2017

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: There were 0 observations read from the data set WORK.UPDT_DATA.

NOTE: The data set WEATHER2.WEATHER_DATA_2B has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.41 seconds

cpu time 0.42 seconds

 

 

NOTE: There were 307 observations read from the data set WEATHER2.WEATHER_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WEATHER2.WFORECAST has 307 observations and 14 variables.

497 The SAS System 08:40 Friday, November 10, 2017

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 155

SYMBOLGEN: Macro variable ITER resolves to 156

SYMBOLGEN: Macro variable DATASETCOUNT resolves to 157

ERROR: The variable opco in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 156

SYMBOLGEN: Macro variable ITER resolves to 156

ERROR: BY variable opco is not on input data set WORK.FILENAMES.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.DATASET_LIST may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set WORK.DATASET_LIST was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

NOTE: No rows were selected.

SYMBOLGEN: Macro variable FULLNAME resolves to

ERROR: Invalid physical name.

ERROR: Error in the FILENAME statement.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.02 seconds

cpu time 0.02 seconds

 

 

ERROR: File WORK.WEATH_UPDT.DATA does not exist.

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

353:153 353:178 353:203 353:228 353:9

NOTE: Character values have been converted to numeric values at the places given by: (Line)Smiley SadColumn).

353:2 353:37 353:40 353:43

WARNING: The variable var14 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var15 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var2 in the DROP, KEEP, or RENAME list has never been referenced.

498 The SAS System 08:40 Friday, November 10, 2017

WARNING: The variable var4 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var5 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var6 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var7 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var8 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var9 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var10 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var11 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var12 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var13 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.WEATH_UPDT may be incomplete. When this step was stopped there were 0 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

35423:154 35423:193 35423:222 35423:250 353:27 353:55 353:83 353:111 353:138 353:166

NOTE: Variable TMP is uninitialized.

NOTE: Variable DPT is uninitialized.

NOTE: Variable HUM is uninitialized.

NOTE: Variable HID is uninitialized.

NOTE: Variable WCL is uninitialized.

NOTE: Variable status is uninitialized.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: There were 0 observations read from the data set WORK.WEATH_UPDT.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 948656 observations read from the data set WEATHER2.WEATHER_ACTUAL.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.38 seconds

cpu time 0.38 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.34 seconds

cpu time 0.74 seconds

 

499 The SAS System 08:40 Friday, November 10, 2017

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 948656 observations read from the data set WORK.WEATHER_DATA_2.

NOTE: There were 0 observations read from the data set WORK.UPDT_DATA.

NOTE: The data set WEATHER2.WEATHER_DATA_2B has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.41 seconds

cpu time 0.42 seconds

 

 

NOTE: There were 307 observations read from the data set WEATHER2.WEATHER_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

 

NOTE: Input data set is empty.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: There were 0 observations read from the data set WORK.UPDT_FORECAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

500 The SAS System 08:40 Friday, November 10, 2017

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WORK.WEATHER_FRCAST has 307 observations and 14 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

NOTE: There were 307 observations read from the data set WORK.WEATHER_FRCAST.

NOTE: The data set WEATHER2.WFORECAST has 307 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 156

SYMBOLGEN: Macro variable ITER resolves to 157

SYMBOLGEN: Macro variable DATASETCOUNT resolves to 157

ERROR: The variable opco in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

SYMBOLGEN: Macro variable ITER resolves to 157

SYMBOLGEN: Macro variable ITER resolves to 157

ERROR: BY variable opco is not on input data set WORK.FILENAMES.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.DATASET_LIST may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set WORK.DATASET_LIST was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

NOTE: No rows were selected.

SYMBOLGEN: Macro variable FULLNAME resolves to

ERROR: Invalid physical name.

ERROR: Error in the FILENAME statement.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /sas/config/Lev1/SASApp/IN_DAT.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.02 seconds

cpu time 0.02 seconds

 

 

501 The SAS System 08:40 Friday, November 10, 2017

ERROR: File WORK.WEATH_UPDT.DATA does not exist.

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

353:153 353:178 353:203 353:228 353:9

NOTE: Character values have been converted to numeric values at the places given by: (Line)Smiley SadColumn).

353:2 353:37 353:40 353:43

WARNING: The variable var14 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var15 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var2 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var4 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var5 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var6 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var7 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var8 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var9 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var10 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var11 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var12 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable var13 in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.WEATH_UPDT may be incomplete. When this step was stopped there were 0 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

 

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

35462:154 35462:193 35462:222 35462:250 353:27 353:55 353:83 353:111 353:138 353:166

NOTE: Variable TMP is uninitialized.

NOTE: Variable DPT is uninitialized.

NOTE: Variable HUM is uninitialized.

NOTE: Variable HID is uninitialized.

NOTE: Variable WCL is uninitialized.

NOTE: Variable status is uninitialized.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WDR in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WSP in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable WET in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable CC in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable SSM in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: There were 0 observations read from the data set WORK.WEATH_UPDT.

NOTE: The data set WORK.UPDT_DATA has 0 observations and 14 variables.

NOTE: The data set WORK.UPDT_FORECAST has 0 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

NOTE: There were 948656 observations read from the data set WEATHER2.WEATHER_ACTUAL.

NOTE: The data set WORK.WEATHER_DATA_2 has 948656 observations and 14 variables.

NOTE: DATA statement used (Total process time):

real time 0.39 seconds

cpu time 0.39 seconds

502

Super User
Super User
Posts: 7,955

Re: Macro Loop Over fail

Posted in reply to tobyfarms

Sorry, that is just one big wall of text.  Maybe start with what you are actually trying to do as you have a load of loops and reads and renames and such like, most of which can be got rid of very simply.  For instance, you use proc import to read in a tab delimited file.  Drop that, write a datastep import (you can get the code directly from the log) and put that in your code.  In this way you will read in the file correctly, assign labels and names in the one step.  Secondly, rather than taking directory listings, then creating loops and such like, simplify your code:

%macro Do_Something (fname=);
...
%mend Do_Something;

filename xyz pipe...;

data _null_;
  infile xyz;
  input;
  call execute(cats('%Do_Something (',_input_,');'));
run;

This code will create a %Do_Something() call for each line returned by the pipe - a dataset is a loop, so you can use that to yuor advantage.

Super User
Super User
Posts: 7,050

Re: Macro Loop Over fail

Posted in reply to tobyfarms

Turn on the MPRINT option so you can see the SAS code that your macro generated.

Most likely right before the error you overwrote your FILENAMES dataset with something different.

Ask a Question
Discussion stats
  • 2 replies
  • 77 views
  • 0 likes
  • 3 in conversation