Hello
I want to convert sas data set into summary report (Two -way summary report).
The summary report should NOT aggregate any value and just display it
Required summary report
What is the way to do it please?
data have;
input cat1 $ cat2 $ value;
cards;
a 1 10
a 2 20
a 3 30
b 1 40
b 2 50
b 3 60
c 1 70
c 2 80
c 3 90
;
Run;
DEFINE cat1 as GROUP, cat2 as ACROSS, and value as ANALYSIS. Combine cat2 and value with a comma in the COLUMN statement. This will work with your data as the cat1/cat2 combinations are unique.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.