Hi, I am trying to build a stored process with a "Multiple value" dynamic selection for the Date field(which was initially in Datatime20. format). Prompt is picking this date column as "Date" in prompt manager and as type "Timestamp" in Info Map Studio. I am recieving the following error: proc sql; create table temp as select distinct colA, colB, date, sum(colD), sum(colE) from libref.dataset WHERE %_eg_WhereParam( DATE, Date, IN, TYPE=D) _ 22 200 WARNING: Apparent invocation of macro _EG_WHEREPARAM not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, (, +, -, BTRIM, CALCULATED, CASE, EXISTS, INPUT, The SAS System NOT, PUT, SUBSTRING, TRANSLATE, USER, ^, ~. Later I have to group it by colA and colB as well. But I am stuck with this error. I have tried to google it out, but all in vain. Please advise. NOTE: I am working on SAS EG 4.2. and later I want to use this stored process in BI Dashboard 4.3. Thanks!!
... View more