topic print array in SAS Studio

print array

ydu180 — Wed, 26 Jul 2017 02:24:37 GMT

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;

Re: print array

Kurt_Bremser — Wed, 26 Jul 2017 05:27:24 GMT

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

Re: print array

Ksharp — Wed, 26 Jul 2017 11:36:23 GMT

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;

Re: print array

ballardw — Wed, 26 Jul 2017 14:44:05 GMT

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.