BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Malathi13
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21

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

1 REPLY 1
art297
Opal | Level 21

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

 

CFC_SAS_Communities_400x225.jpgCFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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