Direct Query -SQL error

[maheshkuttappa]

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;

[#2]

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;