I have this data: Age Pets Country height (cm) 35 3 US 165 65 2 UK 171 21 2 US 181 28 2 China 159 35 1 China 176 65 1 US 175 40 2 UK 178 And I want to summarize the variables using proc freq (so general summary statistics including n, mean, median, std, q1, q3, min, max) by 3 groups, US, UK and China. A sample table is: variable Group P-value US UK China age n mean median std Q1, q3 Min,max Height n … The aesthetics can be different by methods and preferences but wanted to know how should I organize the data and merge them into this desired way (summary statistics for each variable in rows, by country in columns). Ideally I want to use proc report to generate the table but if it's too much, I want to know how to most efficiently merge the table at least. Thank you so much!! Discussion is welcomed
... View more