i have written this sample code i need to convert this finnish date into date9. format. because when i run actual code trough putty it retrieve the finnish date from server and getting issue while comparing with sysdate9. options mprint mlogic symbolgen; /*options locale=English_unitedstates;*/ %macro tt; data one; a=%sysfunc(strip('30. heinäkuuta 2018 09:52:06')); call symputx('a',a); run; %put &a; /*%let d=%length(&a);*/ /*%put &d;*/ %let b=%sysfunc(strip(%sysfunc(substr(&a,1,(%length(&a)-8))))); %put &b; %LET date_d9=%sysfunc(inputn(&b.,nldate10.),date9.); %put y=&date_d9.; %mend; %tt; ******************************************** log--> MLOGIC(TT): Beginning execution. MPRINT(TT): data one; MPRINT(TT): a='30. heinäkuuta 2018 09:52:06'; MPRINT(TT): call symputx('a',a); MPRINT(TT): run; NOTE: The data set WORK.ONE has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(TT): %PUT &a SYMBOLGEN: Macro variable A resolves to 30. heinäkuuta 2018 09:52:06 30. heinäkuuta 2018 09:52:06 2 The SAS System 12:43 Wednesday, August 1, 2018 MLOGIC(TT): %LET (variable name is B) SYMBOLGEN: Macro variable A resolves to 30. heinäkuuta 2018 09:52:06 SYMBOLGEN: Macro variable A resolves to 30. heinäkuuta 2018 09:52:06 MLOGIC(TT): %PUT &b SYMBOLGEN: Macro variable B resolves to 30. heinäkuuta 2018 30. heinäkuuta 2018 MLOGIC(TT): %LET (variable name is DATE_D9) SYMBOLGEN: Macro variable B resolves to 30. heinäkuuta 2018 WARNING: Argument 1 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. MLOGIC(TT): %PUT y=&date_d9. SYMBOLGEN: Macro variable DATE_D9 resolves to . y=. MLOGIC(TT): Ending execution. 42 43 GOPTIONS NOACCESSIBLE; 44 %LET _CLIENTTASKLABEL=; 45 %LET _CLIENTPROCESSFLOWNAME=; 46 %LET _CLIENTPROJECTPATH=; 47 %LET _CLIENTPROJECTNAME=; 48 %LET _SASPROGRAMFILE=; 49 50 ;*';*";*/;quit;run; 51 ODS _ALL_ CLOSE; 52 53 54 QUIT; RUN; 55
... View more