BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Stretlow
Obsidian | Level 7
Hi there. Im struggling a little bit with a proc summary. I have a large data set that holds 3 variables: an IDNumber(Char) a date (date format) and a value (200.00) the whole period covers March to August I'm trying to summarise it so it outputs an average value per IDNumber for each month. I'd like the table in the following way:- Ive attached a sample table of how im trying to make the sample look
1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26

PROC SUMMARY should be able to do this as well. 

 

Something like

 

proc summary data=have nway;
    class IDNumber Date;
    format date monyy.;
    var value;
    output out=want mean=meanvalue;
run;
      

 

--
Paige Miller

View solution in original post

3 REPLIES 3
FredrikE
Rhodochrosite | Level 12

if yo like a report you can use the tabulate procedure followed by a transpose:

proc tabulate data=one out=two;

class idnumber month;

table idnumber, month*value*mean;

var value;

run;

 

proc transpose data=two out=three;

by idnumber;

id month;

var value_Mean;

run;

 

//Fredrik

Stretlow
Obsidian | Level 7

Hi.

 

Thank you for the response this is working perfectly thank you, clearly I was failing as I was using the wrong procedure !!

 

Last question if I may, if I wanted the same table but summed instead of mean would it be this

 

proc tabulate data=ZFinal out=Output;
class FDAccountNumber Month;
table FDAccountNumber, Month*Amount;
var Amount;
run;

 

 

PaigeMiller
Diamond | Level 26

PROC SUMMARY should be able to do this as well. 

 

Something like

 

proc summary data=have nway;
    class IDNumber Date;
    format date monyy.;
    var value;
    output out=want mean=meanvalue;
run;
      

 

--
Paige Miller

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 887 views
  • 0 likes
  • 3 in conversation