BookmarkSubscribeRSS Feed
mageshb
Calcite | Level 5

hi,

 

i  attached the dataset.Please code for accummulated.

 

syntax please

17 REPLIES 17
mageshb
Calcite | Level 5

Write a SAS program to calculate accumulated total sales till 15th April. Use aprsales dataset from SAS dataset repository.

Jagadishkatam
Amethyst | Level 16
Could you please provide sample data and expected output for better response.
Thanks,
Jag
mageshb
Calcite | Level 5
hi i attached the dataset
ballardw
Super User

@mageshb wrote:
hi i attached the dataset

Note that there are a number of potential issues why users of different operating systems or versions of SAS may not be able to read your data set. Provide data in the form of a data step. Then every one has the same data.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

mageshb
Calcite | Level 5
Hi jagadishkatam,

can you please provide ur email id# i have few more doubts.
mageshb
Calcite | Level 5

Write a SAS program to calculate accumulated total sales till 15th April. Use aprsales dataset from SAS dataset repository.

gauthamk28
Obsidian | Level 7

I'm unable to find your dataset here

 

Edit: Please unmark this from solution

mageshb
Calcite | Level 5
ya i will attach
mageshb
Calcite | Level 5
ya i attached sas7.dat
gauthamk28
Obsidian | Level 7

I'm usung mobile , I couldn't find your attached dataset here,can u copy few observations from your dataset and paste here or can u provide few observations of your sample data and expected output here 

art297
Opal | Level 21

Look up how to run proc means with a where statement

 

Art, CEO, AnalystFinder.com

 

Reeza
Super User

Homework? You have no attachment. 

 

And show what you've tried. 

art297
Opal | Level 21

You'll probably have to give a better description of what you want. If you only want the sum of the sales, there are a number of ways to get it. Here is one:

proc means data=aprsales sum;
  var saleamt;
run;

Art, CEO, AnalystFinder.com

 

 

mageshb
Calcite | Level 5
Write a SAS program to calculate accumulated total sales till 15th April. Use aprsales dataset from SAS dataset repository. i have dataset with label salesdate & salesamount, i just want calculate acumulated till april15 .k

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 17 replies
  • 3783 views
  • 1 like
  • 7 in conversation