Hi,   Im trying to  resolve a value of start_date which has a value of date value as  numeric (21032). im trying to resolve to see what date value it has , when i run %put end_date: %sysfunc(inputn(&end_date.,worddate18.),date9.); it in sas eg it is resolving to something like 28jun2017, but when i execute same code in batch mode it is resolving to null(.) see below. any idea ?   SYMBOLGEN: Macro variable START_DATE resolves to 21032 SYMBOLGEN: Macro variable END_DATE resolves to 21032 537 538 %put &start_date &end_date; 21032 21032 539 540 %put start_date: %sysfunc(inputn(&start_date.,worddate18.),date9.); SYMBOLGEN: Macro variable START_DATE resolves to 21032 WARNING: Argument 2 to function INPUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. The result of the operations have been set to a missing value. start_date: . 541 %put end_date: %sysfunc(inputn(&end_date.,worddate18.),date9.); SYMBOLGEN: Macro variable END_DATE resolves to 21032 WARNING: Argument 2 to function INPUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. The result of the operations have been set to a missing value. end_date: . ... View more

    hi ,   I have a report which is productionized , i want to fetch the data from starting date of every year to till date.   Foe example : if i run the report today , it needs to see the start date of this year 2017 as  i.e 01jan2017 :   if i run the report next year it needs to fetch data from "01Jan2018" dynamically .   Is there any solution for this .     ... View more

Hi I have data some thing like below     account id 94345 42 94345 26 94345 18 94345 34 94345 42 94345 18     and i want something like this with distinct data in the id field after concatenating,Can any one help me with this !   account new id 94345 42,26,18,34     ... View more