I would like an answer to this question too.
But for now, I change the Y/N character column into 1/0 numeric column. IF int_type = 'Y' THEN int_type_flag = 1 ELSE 0;
Then I use this code
proc report data=in;
column r_type b_type int_type_flag;
define r_type b_type/ group;
define int_type_flag / analysis SUM;
run;
Hi:
Can you show all the code that you are using so far, including the code that you have used to create int_type_flag???
cynthia
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.