Apologies as it is still not clear to me. I have changed the old_data and New_data file path to my existing files. %let old_data= c:\Users\56029\Desktop\Compare\Existing.xlsx ; *Existing data path; %let new_data= c:\Users\56029\Desktop\Compare\Revised.xlsx ; *Revised data path; Are you referring to change the old and new data path to where the actual files are? ... View more

Thanks for the detailed information. But what is libname old v9 "&old_data." and New Libname? When I try to run the data step after the new and Old linrary, it shows ERROR: Library OLD does not exist. Could you please explain? Thanks ... View more

They both are big dataset with 81 columns and 100k rows. I am only looking at the variables, I have mentioned in the sample datasets. Could you please elaborate your response? Thanks ... View more

Both datasets have all variables in common. ... View more

Log: 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH='C:\Users\5604829\Desktop\Documents\Comparing files.egp'; 6 %LET _CLIENTPROJECTPATHHOST='MMD5CG24212BN'; 7 %LET _CLIENTPROJECTNAME='Comparing files.egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=SVG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported 21 ENCODING='utf-8' 22 STYLE=HTMLBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation 26 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 Proc sort data=existing; 29 by DM9_Consumer_ID; 30 run; NOTE: There were 104291 observations read from the data set WORK.EXISTING. NOTE: The data set WORK.EXISTING has 104291 observations and 81 variables. NOTE: Compressing data set WORK.EXISTING decreased size by 46.38 percent. Compressed is 571 pages; un-compressed would require 1065 pages. NOTE: PROCEDURE SORT used (Total process time): real time 1.47 seconds user cpu time 0.68 seconds system cpu time 0.26 seconds memory 73047.96k OS Memory 101816.00k Timestamp 06/27/2024 12:52:44 PM Step Count 11 Switch Count 5 Page Faults 1 Page Reclaims 26109 Page Swaps 0 Voluntary Context Switches 22 Involuntary Context Switches 186 Block Input Operations 0 Block Output Operations 0 31 32 Proc sort data=revised; 33 by DM9_Consumer_ID; 34 run; 2 The SAS System 10:52 Thursday, June 27, 2024 NOTE: There were 104291 observations read from the data set WORK.REVISED. NOTE: The data set WORK.REVISED has 104291 observations and 81 variables. NOTE: Compressing data set WORK.REVISED decreased size by 46.85 percent. Compressed is 566 pages; un-compressed would require 1065 pages. NOTE: PROCEDURE SORT used (Total process time): real time 1.38 seconds user cpu time 0.68 seconds system cpu time 0.25 seconds memory 73043.28k OS Memory 101816.00k Timestamp 06/27/2024 12:52:45 PM Step Count 12 Switch Count 5 Page Faults 1 Page Reclaims 26690 Page Swaps 0 Voluntary Context Switches 25 Involuntary Context Switches 160 Block Input Operations 0 Block Output Operations 0 35 36 Data differences; 37 merge existing (in=a) revised (in=b); 38 by _all_; 39 if a and b and (existing ne revised); 40 run; NOTE: Variable existing is uninitialized. NOTE: Variable revised is uninitialized. NOTE: There were 104291 observations read from the data set WORK.EXISTING. NOTE: There were 104291 observations read from the data set WORK.REVISED. NOTE: The data set WORK.DIFFERENCES has 0 observations and 83 variables. NOTE: DATA statement used (Total process time): real time 1.35 seconds user cpu time 0.80 seconds system cpu time 0.07 seconds memory 2049.46k OS Memory 31136.00k Timestamp 06/27/2024 12:52:47 PM Step Count 13 Switch Count 5 Page Faults 0 Page Reclaims 218 Page Swaps 0 Voluntary Context Switches 34 Involuntary Context Switches 106 Block Input Operations 0 Block Output Operations 0 41 42 Proc print data=differences; 43 run; NOTE: No observations in data set WORK.DIFFERENCES. NOTE: PROCEDURE PRINT used (Total process time): real time 0.03 seconds user cpu time 0.00 seconds 3 The SAS System 10:52 Thursday, June 27, 2024 system cpu time 0.00 seconds memory 905.28k OS Memory 31136.00k Timestamp 06/27/2024 12:52:47 PM Step Count 14 Switch Count 0 Page Faults 0 Page Reclaims 56 Page Swaps 0 Voluntary Context Switches 13 Involuntary Context Switches 2 Block Input Operations 0 Block Output Operations 0 44 45 %LET _CLIENTTASKLABEL=; 46 %LET _CLIENTPROCESSFLOWNAME=; 47 %LET _CLIENTPROJECTPATH=; 48 %LET _CLIENTPROJECTPATHHOST=; 49 %LET _CLIENTPROJECTNAME=; 50 %LET _SASPROGRAMFILE=; 51 %LET _SASPROGRAMFILEHOST=; 52 53 ;*';*";*/;quit;run; 54 ODS _ALL_ CLOSE; 55 56 57 QUIT; RUN; ... View more

Thanks, that worked!! ... View more

Hi, Proc contents shows: Variable = Month, Type = Num, Len = 8, format = YYMMN6., Informat = Blank ... View more

Here is the log when I include the where clause ( which does not produce any data): NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 Proc sql; 29 create table Test as 30 select a.ACCOUNT_ID, 31 a.FINREP_CURR_SEGMENT, 32 a.FINREP_CURR_SEGMENT_REASON, 33 a.DPD, 34 a.DRAWN_EXPOSURE, 35 b.Month 36 from Aug_Nov_check as a 37 inner join FSFINREP.FINREP_LM_AF_DET as b on a.ACCOUNT_ID = b.ACCOUNT_ID 38 where b.Month in (202311, 202310, 202309, 202308); NOTE: Table WORK.TEST created, with 0 rows and 6 columns. 39 quit; NOTE: PROCEDURE SQL used (Total process time): real time 3.40 seconds user cpu time 0.02 seconds system cpu time 0.02 seconds memory 5298.21k OS Memory 40624.00k Timestamp 01/23/2024 12:43:19 PM Step Count 48 Switch Count 8 Page Faults 4 Page Reclaims 105 Page Swaps 0 Voluntary Context Switches 121 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 0 ... View more

But the excel file that I imported (Nov_BF) does have Account_ID and from the sample dataset you can see that there is Account_ID in the Finrep_sorted as well. Then why it is showing that there is no account_id? ... View more