Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
i get following SQL error When I Direct Query SAS table any suggestion to resolve this issue .
SQL##f - SqlState: S1000, ErrorCode: 4294967295, ErrorMsg: [SAS][SAS ODBC Driver][SAS Server] SPDS_NOTE: Correct Syntax for select expression is:
DIRECT QUERY
dimension
DIV,
industry_subseg_wrtn,
payroll_gov_class,
POL_EFF_MO,
POL_EFF_YR,
measure
Sales
FROM X001.ABC_2014Q4;
Hi Manesh,
Remove the comma after the field POL_EFF_YR
// Removed comma
DIRECT QUERY
dimension
DIV,
industry_subseg_wrtn,
payroll_gov_class,
POL_EFF_MO,
POL_EFF_YR
measure
Sales
FROM X001.ABC_2014Q4;