Thanks for your help in advance, new to SAS. I'm gathering customers info and now in this section, I am bringing the sales agents and their offices.
The complete error is as follows in the log, with no other notes:
"ERROR: Describe error: IColumnsInfo: : GetColumnInfo Failed. : Deferred prepare could not be completed.: Statements(s) could not be prepared.: Incorrect syntax near '='. "
My libnames and everything else above this code works (this is the third section in a very long code).
I scrutinized this code for now more than 8 hours and paid particular attention to all sections containing the = sign, I cannot figure out why I get the error.
Thank you so much for another pair of eyes.
proc sql;
&EDR.;
create table FS_WRKR as
select * from connection to edr_civ
(Select distinct
c.SERIAL_NUM_IDENTIF as SerialNum
,c.CASE_NAME
,c.COUNTY_CODE
,PGM.PGM_CODE
,PGM.CASE_ID
,pgm.pgm_ID
,o.OFFICE_NUM_IDENTIF as OfficeNum
,o.OFFICE_NAME
,o.regn_code as Region_Code
,o.DISTR_CODE
,o.office_ID
,usw.WRKR_NUM_IDENTIF AS WRKRNUM
,usw.pos_ID
,s.FIRST_NAME AS WRKR_FNAME
,s.LAST_NAME AS WRKR_LNAME
,s.county_code
,pa.PGM_ID as paID
,pa.BEG_DATE as paBeg
,pa.END_DATE as paEnd
,pa.POS_ID
,spo.BEG_DATE as spoBeg
,spo.END_DATE as spoEnd
,pos.ID as PosID
,pos.office_ID
,u.unit_num_identif AS unitnum
,u.unit_name
From dbo. [case] as c,
dbo.pgm,
dbo.PGM_ASSIGN,
dbo.OFFICE,
dbo.UNIT,
dbo.POS,
dbo.STAFF,
dbo.UVW_STAFF_WRKR,
dbo.STAFF_POS_ASSIGN
where ((c.id = pgm.case_id)
and (PGM.ID = PGM_ASSIGN.PGM_ID)
and (OFFICE.ID = POS.OFFICE_ID)
and (UNIT.ID = POS.UNIT_ID)
and (POS.ID = STAFF_POS_ASSIGN.POS_ID)
and (STAFF.ID = STAFF_POS_ASSIGN.STAFF_ID)
and (UVW_STAFF_WRKR.POS_ID = PGM_ASSIGN.POS_ID) )
and (STAFF.COUNTY_CODE = '33')
and (CASE.COUNTY_CODE = '33')
and (PGM_ASSIGN.END_DATE >= '02/01/2020'
PGM_ASSIGN.END_DATE >= STAFF_POS_ASSIGN.BEG_DATE)
and (STAFF_POS_ASSIGN.END_DATE >= '02/01/2020'
STAFF_POS_ASSIGN.END_DATE >= PGM_ASSIGN.BEG_DATE)
ORDER BY PGM_ASSIGN.PGM_ID,
PGM_ASSIGN.BEG_DATE desc);
disconnect from edr_civ;
Quit;
