The requirement is: Print a table containing the number of observations, median, mean, and standard deviation for temperatures for each of the two days individually.
The output I got is Does anyone know how to show like this
data hw6.hotdays_ydu18;
infile "/home/ydu180/hw6/hourly_temps.txt" dlm=' ';
do Day=1 to 2;
do Hour=1 to 24;
input Temp@@;
output;
end;
end;
run;
/*d*/
title2"Part 3d";
proc means data=hw6.hotdays_ydu18 N Median Mean STD;
var Temp:;
by Day;
run;
Use the output statement in proc means to create a new dataset, and use proc print from that.
For further help, post the .txt file as attachment, or copy/paste it into a {i} window
If you have SAS9.4 , try SQL instead.
proc sql;
select day,count(*) as N,median(temp) as median,mean(temp) as mean,std(temp) as std
from have
group by day;
quit;
One way:
proc tabulate data=hw6.hotdays_ydu18;
class day;
var temp;
table day,
n='Nobs' temp*(N Median Mode STD);
run;
Options available to specify different formats do control number of displayed digits.
The first n='Nobs' will show the count of the DAY variable value, the second is non-missing Temp values.
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!
Get started using SAS Studio to write, run and debug your SAS programs.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.