Yes Linlin, My code won't handle the year, your code is correct and best to use. ... View more

Hi, Another way of doing it, data sample; input dt MMDDYY10. ; datalines ; 11/03/2012 04/11/2012 ; run; data sample1; set sample; dt1=compress(tranwrd(put(dt,MMDDYY10.),'0','')); run; Regards Sylas.J ... View more

Hi Nicnad, Remove the statement highlighted in the red font,you will get all the data and more details about the count variable increment. if you face other issue , could you please elaborate. data data work.ind14_15_16; set mylist.test end=eof; retain count_gafi count_sanction count_person; if _n_ eq 1 then do;      count_gafi=0;      count_sanction=0;      count_person=0; end; if index(lowcase(strip(objet)),"'bolivie','équateur','equateur','éthiopie','ethiopie','indonesie','kenya', 'nigeria','nigéria','pakistan', 'sao','sri lanka', 'thailand', 'thailande','tailande','turquie', 'tanzanie','viet','yemen','yémen'") >0 then count_gafi=count_gafi+1; else if index(lowcase(strip(objet)),"'bélarus','belarus', 'corée du nord', 'rpdc', 'coree du nord','ivoire' , 'congo', 'chine' , 'cuba' , 'érythrée' , 'erythree', 'iran' , 'iraq' , 'liberia' , 'libéria', 'libye' , 'myanmar', 'birmanie', 'somalie' , 'sierra' , 'soudan', 'syrie', 'zimbabwe'") >0 then count_sanction=count_sanction+1; else count_person = count_person + 1; /* If the record is not part of count_gafi or count_sanction, I want it to be part of count_person */ if eof; run; Regards Sylas.J ... View more

Hi Nicnad, Add the conditional statement in red font and delete the statement in blue font, data data work.ind14_15_16; set mylist.test end=eof; by objet; /*delete the statement, it might create problem in future if the data is not sorted based on objet*/ retain count_gafi count_sanction count_person; if _n_ eq 1 then do;      count_gafi=0;      count_sanction=0;      count_person=0; end; if index(lowcase(strip(objet)),"'bolivie','équateur','equateur','éthiopie','ethiopie','indonesie','kenya', 'nigeria','nigéria','pakistan', 'sao','sri lanka', 'thailand', 'thailande','tailande','turquie', 'tanzanie','viet','yemen','yémen'") >0 then count_gafi=count_gafi+1; else if index(lowcase(strip(objet)),"'bélarus','belarus', 'corée du nord', 'rpdc', 'coree du nord','ivoire' , 'congo', 'chine' , 'cuba' , 'érythrée' , 'erythree', 'iran' , 'iraq' , 'liberia' , 'libéria', 'libye' , 'myanmar', 'birmanie', 'somalie' , 'sierra' , 'soudan', 'syrie', 'zimbabwe'") >0 then count_sanction=count_sanction+1; else count_person = count_person + 1; /* If the record is not part of count_gafi or count_sanction, I want it to be part of count_person */ if eof; run; Regards Sylas.J ... View more

Hi Nicnad, I have highlighted with red font for the changes i have made in the below code, adding that to your code it will work data data work.ind14_15_16; set mylist.test end=eof; by objet; retain count_gafi count_sanction count_person; if _n_ eq 1 then do;      count_gafi=0;      count_sanction=0;      count_person=0; end; if index(lowcase(strip(objet)),"'bolivie','équateur','equateur','éthiopie','ethiopie','indonesie','kenya', 'nigeria','nigéria','pakistan', 'sao','sri lanka', 'thailand', 'thailande','tailande','turquie', 'tanzanie','viet','yemen','yémen'") then count_gafi=count_gafi+1; else if index(lowcase(strip(objet)),"'bélarus','belarus', 'corée du nord', 'rpdc', 'coree du nord','ivoire' , 'congo', 'chine' , 'cuba' , 'érythrée' , 'erythree', 'iran' , 'iraq' , 'liberia' , 'libéria', 'libye' , 'myanmar', 'birmanie', 'somalie' , 'sierra' , 'soudan', 'syrie', 'zimbabwe'") then count_sanction=count_sanction+1; else count_person = count_person + 1; /* If the record is not part of count_gafi or count_sanction, I want it to be part of count_person */ if eof; run; Regards Sylas.J ... View more

Hi Nicnad, If you want assign two variables as zero in the following code if _n_ eq 1 then count_gafi=0 count_sanction=0 count_person=0; You have to go for do statement and place semicolon at end of each variable assignement. Ex. if _n_ eq 1 then do; count_gafi=0; count_sanction=0; count_person=0; end; Regards Sylas.J ... View more

Hi Nicnad, Instead of  if lowcase(strip(object))  in code use the below code if  index(lowcase(strip(object)), " 'bolive','equater'...")  >  0 then count=count+1; Regards Sylas.J ... View more

Hi Nicnad, Following below code will give the count of the records in mytable1 dataset. Proc sort data=mytable; by object; run; data mytable1(keep=count); set mytable end=eof; by object; retain count; if _n_ eq 1 then count=0; if lowcase(strip(object)) in ('test1','test2','test3') then count=count+1; if eof; run; If you want to have all data in the mytable1 remove the word i highlighted in red. Regards Sylas.J ... View more