The SAS set WORK CHECK has an index on the variable Code and the following SAS program is submitted.
proc sort data=WORK.CHECK;
by Code;
run;
What describes the result of submitting SAS program?
The SAS set WORK CHECK has an index on the variable Code and the following SAS program is submitted.
proc sort data=WORK.CHECK;
by Code;
run;
What describes the result of submitting SAS program?
When a SAS dataset with an index on a variable is sorted by that indexed variable, the index remains unaffected. The sort operation sorts the dataset but does not alter or delete the existing index. This means the index on the variable Code will be unaffected by the sort operation.
ERROR: Indexed data set cannot be sorted in place unless the FORCE option is used.