I am trying to run this part of code ... proc sql; create table &lib1..PR_&str. as select a.*, count(*) as NumYears from &lib1..PR_&str. a group by %group_by_RiskCollectiveTY(lvl=&RCTY.); quit; %chk_err; data &lib1..ILLC_&SEL_IL.&str. (drop = HILLY COASTAL SEASON_DESC CROP_GROUP_DESC CROP_DESC NOTIFIED_AREA DAIU PY_Cred_Z AveLC_Unc ProductBaseRate Var_LCRC NumYears LEVEL1_NAME LEVEL2_NAME IL_Weight LossCostCap IL_LossCostCap IndemnityLevel); set &lib1..PR_&str.; run; then I am getting error like : MPRINT(RUN_PRICE_MODEL): proc sql; 2695 + Level3_Code,hilly,crop_group_code,crop_code,season_code,NOTIFIED_AREA,NOTIFIED_AREA_CODE; MPRINT(RUN_PRICE_MODEL): create table work.PR_GJKHAMuth as select a.*, count(*) as NumYears from work.PR_GJKHAMuth a group by Level1_Code, Level2_Code, Level3_Code,hilly,crop_group_code,crop_code,season_code,NOTIFIED_AREA,NOTIFIED_AREA_CODE; NOTE: The query requires remerging summary statistics back with the original data. WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem. NOTE: Table WORK.PR_GJKHAMUTH created, with 90 rows and 37 columns. 2695 + quit; MPRINT(RUN_PRICE_MODEL): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds Memory 123427k OS Memory 137952k Timestamp 25-08-2015 16:56:08 2695 + ; data work.ILLC_90_AppliedGJKHAMuth (drop = HILLY COASTAL SEASON_DESC CROP_GROUP_DESC CROP_DESC MPRINT(RUN_PRICE_MODEL): ; 2696 + NOTIFIED_AREA DAIU PY_Cred_Z AveLC_Unc ProductBaseRate Var_LCRC NumYears LEVEL1_NAME LEVEL2_NAME IL_Weight LossCostCap IL_LossCostCap 2697 + IndemnityLevel); set work.PR_ MPRINT(RUN_PRICE_MODEL): data work.ILLC_90_AppliedGJKHAMuth (drop = HILLY COASTAL SEASON_DESC CROP_GROUP_DESC CROP_DESC NOTIFIED_AREA DAIU PY_Cred_Z AveLC_Unc ProductBaseRate Var_LCRC NumYears LEVEL1_NAME LEVEL2_NAME IL_Weight LossCostCap IL_LossCostCap IndemnityLevel); 2698 +GJKHAMuth; run; 3179 The SAS System 15:24 Tuesday, August 25, 2015 MPRINT(RUN_PRICE_MODEL): set work.PR_ GJKHAMuth; ERROR: File WORK.PR_.DATA does not exist. ERROR: File WORK.GJKHAMUTH.DATA does not exist. MPRINT(RUN_PRICE_MODEL): run; WARNING: The variable HILLY in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable COASTAL in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable SEASON_DESC in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable CROP_GROUP_DESC in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable CROP_DESC in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable NOTIFIED_AREA in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable DAIU in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable PY_Cred_Z in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable AveLC_Unc in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable ProductBaseRate in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Var_LCRC in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable NumYears in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable LEVEL1_NAME in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable LEVEL2_NAME in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable IL_Weight in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable LossCostCap in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable IL_LossCostCap in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable IndemnityLevel 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.ILLC_90_APPLIEDGJKHAMUTH may be incomplete. When this step was stopped there were 0 observations and 0 variables. And also I ma getting this typer of Error Abruptly. Not always at Same type Error. Its taking space in the data set name. So please help on this .
... View more