so, if we make the hypothesis that records with none unique key get a _IORC_ value of zero because for the same agreement_nbr they have multiple datemiss and datechea, and in that case the two variables RCLASS2 AND RCLASS2P need to be remapped to new values.   and how to deal with warning ? WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. GCNA_BRANCH= DATECHEA=25-11-04 DATEMISS=24-11-04 DATANNUL=. ASSPREC=WA BASETAR=1 CIEDISTR= CODEFPQ=1 COURTIER=0024 DATEORIG=201811 AGREEMENT_NBR=aaa-4315 POL_SYNC=M27-9337 POL_TEST= PRIMANNU=775 PROFGAFF=SECRETAIRE COMPTABLE RAIS_SOC=IN SECTASSU=P SERVICE= SOURCAFF=N STATUT=N TERR_REP=04 POLICE=aaa315- TERME=- PROVINCE=QC POL_CONV=P BROKER_GROUP_IND= PIP=1 POLICY=aaa4315 ANASS=6 NEWREN=R RCLASS2=COMMAUTO RCLASS2P=COMMIRCA PRIORCUR=C TRANS=DIR MOIS=202509 FPROV=QC. CIE=A TRANSFER=R RCLASS3=PERSAUTO POLICY_INCEPTION_DT= POLICY_EXPIRY_DT= GENRE_GC= _ERROR_=1 _IORC_=1230015 _N_=1     How to see the value of each _IORC_ ... View more

I have found the issue Effectively, the variable is not found into all datsets. The option DKRICOND=NOWARNING will do the job. ... View more

It is a good idea.  I have 14 datasets to check, using proc contents.  I will come back after to let you know what I have found ... View more

I agree with you that the diff function could be use. But my colleages are famillar with proc compare ... View more

Yes you are right, that will do the same ... View more

for Mr. Miller here's my complete script   data paths; length path $200; input path $; datalines; /dwh_actuariat/sasprocess/prodmens/HYFIprep/output /dwh_actuariat/sasprocess/prodmens/HYFIp/output ; run; /************************************************************/ %macro readfile(path,fname,suffix); DATA &fname.; INFILE "&path./&fname..&suffix"; INPUT Cie $ 1 province $ 2-3 branch $ 4-7 priorcur $ 8 polsrc $ 9 mois $ 10-15 lob $ 16-23 Trans $ 24-26 WP 27-41 EP 42-56 EU 57-71 WU 72-86 POLCNT 87-102 POLEARN 103-117 UW_CIE $ 118 DIST_CIE $ 119 OB_IND $ 120-124 BROKER_GROUP_IND $ 125-126 GCNA_BRANCH $ 127-128 POLICY_CATEGORY $ 129 NETWORK_PROVIDER $ 130-134 AFFINITY_IND $ 135 ; RUN; %mend readfile; /*******************************************************/ %macro readtxtfile; %let yearmin=2024; %let yearmax=2025; %let prefix=HyFIPrems; %let suffix=txt; %let path=/dwh_actuariat/sasprocess/prodmens/HYFIprep/output; %do year = &yearmin %to &yearmax; %if &year. ne &yearmax. %then %let maxmonth=12; %else %let maxmonth=7; %do month =01 %to &maxmonth.; %let formatted_month = %sysfunc(putn(&month, Z2.)); %let fname=&prefix.&year.&formatted_month.; %put &fname..&suffix.; %readfile(&path,&fname,&suffix); PROC APPEND BASE=&prefix. DATA=&fname.; RUN; %end; %end; %mend readtxtfile; /******************************************/ *%readtxtfile; %macro readtxtfile2(path); %let yearmin=2025; %let yearmax=2025; %let minmonth=1; %let maxmonth=7; %let prefix=HyFIPrems; %let suffix=txt; %do year = &yearmin %to &yearmax; %do month =&minmonth. %to &maxmonth.; %let formatted_month = %sysfunc(putn(&month, Z2.)); %let fname=&prefix.&year.&formatted_month.; %put &fname..&suffix.; %readfile(&path,&fname,&suffix); %let substring=prep; %if %sysfunc(find(&path. , &substring.)) > 0 %then %do; PROC APPEND BASE=&prefix. DATA=&fname.; RUN; %end; %else %do; PROC APPEND BASE=&prefix._org DATA=&fname.; RUN; %end; %end; %end; %mend readtxtfile2; %macro process; proc sql noprint; select path into :path_list separated by ' ' from paths; quit; %put &=path_list; %let i = 1; %do %while (%qscan(&path_list, &i. ,%str( )) ne ); %let current_path = %scan(&path_list, &i. , %str( )); %put &=current_path; %readtxtfile2(&current_path); %let i = %eval(&i. + 1); %end; %mend process; %process; ... View more

Why did you replace the %scan by %pscan and the '' by %str() and ne ) Please explain. Your script work perfectly ... View more

I will replace the %put by another macro function. ... View more

Well I want to use the macro process to passed as parameter the two different paths.  Then I will replace the %put statement by another macro function that is loading all the txt files into that folder into a sas dataset. ... View more