Write and run SAS programs in your web browser

print array

Reply
Contributor
Posts: 23

print array

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 WechatIMG250.jpegDoes anyone know how to show like this WechatIMG251.jpeg

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;
Super User
Posts: 7,868

Re: print array

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 10,048

Re: print array

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;
Super User
Posts: 11,343

Re: print array

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.

Ask a Question
Discussion stats
  • 3 replies
  • 205 views
  • 0 likes
  • 4 in conversation