Thanks for your suggestion and I'd like to program it, but could you please explain the method more clearly? I have understood the meaning of IF-THEN/ELSE, but I don't know which codes should be used in <insert code to reassign variables> and <insert code>? and where I should put these codes? Besides, is it one step of your previous suggestion or a different method? 1. Use PROC PRINTTO to direct your log to a file 2. Read the file (it's a text file) to extract the _N_ 3. That's the records you need to fix. the following is the code and results which I have provided, so you don't need to check previous questions. 1 data S.Publications ;
2 infile 'R:/L/P/Publications.csv' DLM = ',' DSD missover lrecl = 32767
2 ! firstobs = 3 ;
3 input pat_publn_id :29. publn_auth :$29. publn_nr :$29. publn_nr_original :$29. publn_kind
3 ! :$29. appln_id :29. publn_date :YYMMDD10. publn_lg :$29. publn_first_grant:29. publn_claims
3 ! :29. ;
4 format publn_date :YYMMDDd10. ;
5 run ;
NOTE: Data file S.PUBLICATIONS.DATA is in a format that is native to another host, or the
file encoding does not match the session encoding. Cross Environment Data Access will be
used, which might require additional CPU resources and might reduce performance.
NOTE: The infile 'R:/L/P/Publications.csv' is:
Filename=R:\L\P\Publications.csv,
RECFM=V,LRECL=32767,
File Size (bytes)=5635168276,
Last Modified=11 September 2017 20:15:18 o'clock,
Create Time=15 March 2018 15:41:54 o'clock
NOTE: Invalid data for appln_id in line 68262946 33-34.
NOTE: Invalid data for publn_date in line 68262946 36-44.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+---
68262946 390735978,HK,1053433,09/465,054,A1,275562685,2010-03-26, ,0,0 62
pat_publn_id=390735978 publn_auth=HK publn_nr=1053433 publn_nr_original=09/465 publn_kind=054
appln_id=. publn_date=. publn_lg=2010-03-26 publn_first_grant=. publn_claims=0 _ERROR_=1
_N_=68262944
NOTE: Invalid data for appln_id in line 68280355 33-34.
NOTE: Invalid data for publn_date in line 68280355 36-44.
68280355 390753387,HK,1092990,60/523,466,A1,275562719,2010-03-26, ,0,0 62
pat_publn_id=390753387 publn_auth=HK publn_nr=1092990 publn_nr_original=60/523 publn_kind=466
appln_id=. publn_date=. publn_lg=2010-03-26 publn_first_grant=. publn_claims=0 _ERROR_=1
_N_=68280353
NOTE: Invalid data for publn_date in line 98594248 33-33.
98594248 184,,A ,930063756,9999-12-31, ,0,0 35
pat_publn_id=184 publn_auth= publn_nr=A publn_nr_original=930063756 publn_kind=9999-12-31
appln_id=. publn_date=. publn_lg=0 publn_first_grant=. publn_claims=. _ERROR_=1 _N_=98594246
NOTE: Invalid data for publn_date in line 98614935 36-36.
98614935 148740,,A ,930101529,9999-12-31, ,0,0 38
pat_publn_id=148740 publn_auth= publn_nr=A publn_nr_original=930101529 publn_kind=9999-12-31
appln_id=. publn_date=. publn_lg=0 publn_first_grant=. publn_claims=. _ERROR_=1 _N_=98614933
NOTE: Invalid data for publn_date in line 98619964 36-36.
98619964 165714,,A ,930111753,9999-12-31, ,0,0 38
pat_publn_id=165714 publn_auth= publn_nr=A publn_nr_original=930111753 publn_kind=9999-12-31
appln_id=. publn_date=. publn_lg=0 publn_first_grant=. publn_claims=. _ERROR_=1 _N_=98619962
NOTE: Invalid data for publn_date in line 98673026 33-33.
98673026 790,,A1,930090062,9999-12-31, ,0,0 35
pat_publn_id=790 publn_auth= publn_nr=A1 publn_nr_original=930090062 publn_kind=9999-12-31
appln_id=. publn_date=. publn_lg=0 publn_first_grant=. publn_claims=. _ERROR_=1 _N_=98673024 really thanks for your help.
... View more