Hi Kurtbremser, Thanks for the quick response , as per below conversation i tried with one statement but it didn't work plz find below code  IF REFDT LE INTNX('DAY', TODAY(),-180) THEN DELETE; kindly share some solution for the above code issue  Thanks & Regards  Rohit   ... View more

Hi jklaverstijn Thanks for the quick response you're code working good but my expected o/p was not yet came i will share the log code < DATA NEWLIC; INFILE DATALINES; INPUT @1 LICNO $10.; IF LICNO = . THEN LICNO = 4; DATALINES; 203....412 ...3300421 9955..032. ; RUN; PROC PRINT DATA = NEWLIC; RUN; > below the output i got +++++++++++++++++++++++ Obs LICNO 1 4 2 4 3 4 +++++++++++++++++++++++++++++ but my expected output was 2030000412 0003300421 9955000320 i want to substitute non numeric to 0 like above . is the non numeric so i replaced with 0 in manual way kindly share some some solution for above one Thanks & Regards Rohit ... View more

HI KurtBremser, Thanks for the Replay & sorry for what i posted, in the hurry manner i posted the hard code kindly ignore the mistake and give some of the solution above issue Thanks & Regards Rohit ... View more

Hi jklaverstijn thanks for the quick replay but i got some issue wt you posted, below error i got kindly look it once LICNO = COALESCE(LICNO, 0); ________ ________ ________ 68 68 68 OR 68-185: The function COALESCE is unknown, or cannot be accessed. kindly plz give some solution for that one Thanks & Regard Rohit ... View more

INFILE LSFIV**0 TRUNCOVER; INPUT TEXT $CHAR26. CRTD_TS $CHAR26. TEXT $CHAR13. LICENCE_NO PD5. Format O/P file File LSFI2**1; /* Output version of LSFI*** */ PUT @1 LICENCE_NO Z10. +++++++++++++++++ licencec = PUT(licence_no,Z10.); with Delimiter Recout = 'D' || delimtr || trim (Left(licencec )) || Delimtr; =============================================== Actual i/p file in log master format CLST0*0 TLS27**_PAY**_CN**2020-06-08-08.32.18.129184 ü3* tM ====================================================== The o/p D|0000044479|"PY*_IN*_00#$$$1309.DAT"|20200717|"ACC"| +++++++++++++++++++++++++++++++++++++++++++++++++++ The Expected o/p D|1000044479|"PY*_IN*_00#$$1309.DAT"|20200717|"ACC"| the Actual o/p as per the above one getting missing the one value it reading only 9 positions only that the region the first position of the license it seems 0 instead of 1 so kindly plz provide the solution the above problem Thanks & Regards Rohit ... View more

Hi ed_sas_member Thank you very much it's working Thanks & Regards Rohit ... View more

Hi ed_sas_member Thanks for the quick response ya it's superb it's working fine But my small request is if the date is less then that it displays not valid like date < 31 display not valid above condition possible kindly gives some suggestions Thanks & Regards Rohit ... View more

Hi ed_sas_member, Thanks for the response it's working fine but my requirement is how to put a check point to stop the displaying the 20200140 and moreover, my expected output is 20200120 not 2020-01-20 i tried to give yymmdd8. but it shows Obs DATE 1 20-01-20 2 . above one i got so plz kindly respond on the above issue Thanks & Regards Rohit ... View more

Hi KurtBremser thanks for the response ya sure { DATA DT_FT; INFILE DATALINES; INPUT @1 DATE $CHAR8.; DATALINES; 20200120 20200140 ; RUN; PROC PRINT DATA = DT_FT; RUN; output: Obs DATE 1 20200120 2 20200140 my ask is how the second date has been updated it is greater than 31 right so my expected output is { 20200120 it printing fine but second, has to print error bez it is greater than 31 } plz kindly give some solution for the above issue Thanks & Regards Rohit ... View more

Hi KurtBremser Thanks for the quick response ys sure i will give the example plz find below { first the hdrdate = 20200120 it's in ccyymmdd format and it updated fine in table then i have given hdrdate = 20200140 for testing above date also updated my question is how come it updated a month have only 31 days it went beyond 31 days right how to put a checkpoint on the above issue Thanks & Regards Rohitkrishna ... View more

Hi Amir, Thanks for the response superb it's working fine, thanks a lot Thanks & Regards Rohit ... View more