I got the following message when I ran a query:
"NOTE: The query requires remerging summary statistics back with the original data."
I looked on-line in SAS Technical Support, but did not really understand what I read. Can someone "out there" please help and tell me if this is a serious error, and possible what I should do to eliminate it? Thank you so much!!
Here is my query and a preliminary data step:
data makechoice;
%let endfiscaldate = 31Aug&fiscalyr;
%let position_dates = ( DatePart(EMPLOYEE_POSITION.POSITION_END_DATE) BETWEEN "&&fiscal_date"d AND "&&endfiscaldate"d);
run;
%mend fiscal_year;
%fiscal_year;
/**********************************************************************************************
/*** Using SQL, creates the primary data table. ***
/*********************************************************************************************/
PROC SQL;
CREATE TABLE HFA033Step01 AS SELECT
EMPLOYEE.NAME as EMPLOYEE_NAME FORMAT = $40.,
EMPLOYEE_POSITION.POSITION_END_DATE,
EMPLOYEE_POSITION.POSITION_CONTRACT_TYPE_DESC as POSITION_DESC FORMAT = $40.,
EMPLOYEE_POSITION.POSITION as POSITION FORMAT = $40.,
EMPLOYEE_POSITION.POSITION_TITLE as POSITION_TITLE FORMAT = $40.,
EMPLOYEE_POSITION.POSITION_STATUS as POSITION_STATUS FORMAT = $40.,
EMPLOYEE_POSITION.ASSIGNMENT_GRADE as ASSIGNMENT_GRADE FORMAT = $40.,
EMPLOYEE_POSITION.ASSIGNMENT_SALARY_GROUP_DESC as SALARY_GROUP_DESC FORMAT = $40.,
MAX(EMPLOYEE_POSITION.ANNUAL_SALARY) as ANNUAL_SALARY,
EMPLOYEE_POSITION.POSITION_EMPLOYEE_CLASS as EMPLOYEE_CLASS FORMAT = $40.,
EMPLOYEE_POSITION.POSITION_EMPLOYEE_CLASS_DESC as EMPLOYEE_CLASS_DESC FORMAT = $40.,
POSITION_BUDGET.FISCAL_YEAR as FISCAL_YEAR,
POSITION_BUDGET.FISCAL_YEAR_START_DATE,
POSITION_BUDGET.FISCAL_YEAR_END_DATE,
POSITION_BUDGET.POSITION FORMAT = $40.
FROM ODSH.EMPLOYEE AS EMPLOYEE
LEFT JOIN ODSH.EMPLOYEE_POSITION AS EMPLOYEE_POSITION ON (EMPLOYEE.PERSON_UID = EMPLOYEE_POSITION.PERSON_UID)
LEFT JOIN ODSH.POSITION_BUDGET AS POSITION_BUDGET ON (EMPLOYEE_POSITION.POSITION = POSITION_BUDGET.POSITION)
WHERE ( EMPLOYEE.TERMINATION_DATE IS NULL ) AND
( EMPLOYEE_POSITION.POSITION_END_DATE IS NOT NULL )AND
( EMPLOYEE_POSITION.POSITION_CONTRACT_TYPE_DESC = 'Primary' ) AND
( EMPLOYEE_POSITION.POSITION_STATUS NE 'T' ) AND
( POSITION_BUDGET.FISCAL_YEAR = "&fiscalyear" ) AND
&Position_Dates
GROUP BY EMPLOYEE_NAME
ORDER BY EMPLOYEE_NAME;
QUIT;