Thanks for your help, Now i have retrieved a value in date9. Except that when i want to put this value in table like this: data derivedData; set derivedData; format &codename2 Date9.; &codeName2=&dateDisplay; run; the message error is: MPRINT(DERIVEDTABLE): data derivedData; MPRINT(DERIVEDTABLE): set derivedData; MPRINT(DERIVEDTABLE): format OTH_DYSFUN_STARTDATE_NUM Date9.; NOTE: Line generated by the macro variable "DATEDISPLAY". 24 01JAN2013 _______ 22 MPRINT(DERIVEDTABLE): OTH_DYSFUN_STARTDATE_NUM=01JAN2013; MPRINT(DERIVEDTABLE): run; ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=.
... View more