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 !
Create tables such that you have a variable that holds the text of the description and the count, append the sets together, print.
Use the same variable names in all of the sets so columns align when displaying.
@srinidelite wrote:
Can you please elaborate it?
Do you know how use a create table statement in SQL? That creates the separate data sets with the itens you need.
Then either a union or data step with set statement to combine the sets.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.