DATA Step, Macro, Functions and more

Adding two same dates

Accepted Solution Solved
Reply
Contributor
Posts: 46
Accepted Solution

Adding two same dates

Hi,

can some one help me with the dates. I have two dates e.g. 3/10/17 and I brought 4 apples on this date and I have the same date 3/10/17 and I brought 2 apples again. How do I get the total apples 6 on 3/10/17?

 

Any help.

 

Thank you

M


Accepted Solutions
Solution
‎03-30-2017 04:09 PM
PROC Star
Posts: 7,492

Re: Adding two same dates

Posted in reply to Malathi13

Use sum in either proc summary, proc means or proc sql. For the first two, use your date variable as a class variable, for sql, use the group by statement.

 

Art, CEO, AnalystFinder.com

 

View solution in original post


All Replies
Solution
‎03-30-2017 04:09 PM
PROC Star
Posts: 7,492

Re: Adding two same dates

Posted in reply to Malathi13

Use sum in either proc summary, proc means or proc sql. For the first two, use your date variable as a class variable, for sql, use the group by statement.

 

Art, CEO, AnalystFinder.com

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 124 views
  • 0 likes
  • 2 in conversation