Hi All,
When I am running below peice of code, I am getting error message :
/****Code *****/
%put %str(NOTE: Creating indexes in Parallel...);
proc datasets lib = VL00 nolist;
modify VL0004_005D_Employee_Sensitive (asyncindex=YES);
index create VL0004_004D_Employee_Sk ;
index create Employee_Id ;
index create Person_Id ;
quit;
/*****Log ********/
MPRINT(ETLS_LOADER): ;
NOTE: Creating indexes in Parallel...
MPRINT(ETLS_LOADER): proc datasets lib = VL00 nolist;
MPRINT(ETLS_LOADER): modify VL0004_005D_Employee_Sensitive (asyncindex=YES);
MPRINT(ETLS_LOADER): index create VL0004_004D_Employee_Sk ;
NOTE: Because ASYNC operations create indexes in parallel, the status for all defined indexes will be determined at closing time.
NOTE: Simple index VL0004_004D_Employee_Sk has been defined.
MPRINT(ETLS_LOADER): index create Employee_Id ;
ERROR: Specified resource already exists.
MPRINT(ETLS_LOADER): index create Person_Id ;
MPRINT(ETLS_LOADER): quit;
NOTE: Statements not processed because of errors noted above.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set.
NOTE: PROCEDURE DATASETS used (Total process time):
real time 1.55 seconds
cpu time 0.00 seconds
What sort of engine is used by library VL00 ? SPDE ?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.