I Have few Test Cases all of them run using Proc sql and one key thing i have noticed that the variable / column value always set to  4000 bytes automatically but is there a way to dymically assign based on the values ? for each dataset . Because  dataset1  value might enough with  30 bytes but datset2 value might not be enough with  30 bytes .. so i need to tell the sas to allocate the memory (lenght ) based the data it process !   Is there anyway i can do it ? experts pls help me out  ... View more

  Hi There , I'm looking forward to create a customized report just like below and i gotta two set's named SOURCE and TARGET ,.. Certainly im very new to SAS programming and struggling to use it in brinig out to the PROC_REPORT FORMAT . I'certainly able to perform all of below in SQL (count , Dulpicates etc ) howver i'm not sure how to bring it them on this report   proc sql ; select count(*) as TO_NO_OF_RCD_IN_SRC from src_ais.covprmtemp2b2w ; quit ; proc sql ; select count(*) as TO_NO_OF_RCD_IN_TGT from src_ais.covprmtgt2b2w ; quit ; proc sql; select distinct 0 as NO_OF_DUPES_SRC from src_ais.covprmtemp2b2w where not exists (select cdnumpol,count(*) from src_ais.covprmtemp2b2w group by cdnumpol having count(*)>1) ;quit; proc sql; select distinct 0 as NO_OF_DUPES_TGT from src_ais.covprmtgt2b2w where not exists select cdnumpol,count(*) from src_ais.covprmtgt2b2w group by cdnumpol having count(*)>1 ;quit; I was trying with PRC_REPORT however it doesnt helped me much ..   Total Number of Records in Source 5245 Total Number of Records in Target 5245 Total Number of Duplicate Records in Source 0 Duplicate Records in Source 0 Total Number of Duplicate Records in Target 0 Duplicate Records in Target 0 Total number of Rows missing in Source 0 Total number of Rows missing in Target 0 Total Number of Rows having Mismatches 49 Total Number of Matching Rows 5196 Total number of field level mismatches 184 Total number of Records taken for comparison 5245   Your Help is muc appriciated ! ... View more