Thank you for your help. The solution does not seem to be working. I get the following error message in the log 30 +***************************************; 31 +*first time only to create data set *; 32 +****************************************; 33 +/*data sasdat.SasiGoalDb; new1; run;*/ 34 +/*ALL FROM HERE TO ODS SHOULD BE COMMENTED OUT 35 +THE FIRST TIME DATA ARE ENTERED*/ 36 +*comment this out the first time through - THIS CREATES A VARIABLE 37 + TO CHECK THE NUMBER OF ROWS IN THE PERMANENT DATA SET BEFORE 38 + NEW DATA IS APPENDED; 39 +Proc sql; 40 +create view temp1 41 +as select count(*) as count1 from sasdat.SasiGoalDb; NOTE: SQL view WORK.TEMP1 has been defined. 42 +nrow=put("&count1", 2.); WARNING: Apparent symbolic reference COUNT1 not resolved. 42 +nrow=put("&count1", 2.); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order.
... View more