topic Re: accumulated in SAS Programming

accumulated

mageshb — Sun, 14 May 2017 02:06:56 GMT

hi,

i attached the dataset.Please code for accummulated.

syntax please

accumulated

mageshb — Sun, 14 May 2017 01:51:40 GMT

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

Re: accumulated

Jagadishkatam — Sun, 14 May 2017 01:56:51 GMT

Could you please provide sample data and expected output for better response.

code

mageshb — Sun, 14 May 2017 01:58:55 GMT

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

Re: code

gauthamk28 — Sun, 14 May 2017 02:16:37 GMT

I'm unable to find your dataset here

Edit: Please unmark this from solution

Re: code

mageshb — Sun, 14 May 2017 02:02:27 GMT

ya i will attach

Re: code

mageshb — Sun, 14 May 2017 02:07:54 GMT

ya i attached sas7.dat

Re: accumulated

mageshb — Sun, 14 May 2017 02:08:54 GMT

hi i attached the dataset

Re: accumulated

mageshb — Sun, 14 May 2017 02:11:08 GMT

Hi jagadishkatam,

can you please provide ur email id# i have few more doubts.

Re: accumulated

art297 — Sun, 14 May 2017 02:13:46 GMT

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

Re: code

gauthamk28 — Sun, 14 May 2017 02:13:53 GMT

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

Re: accumulated

mageshb — Sun, 14 May 2017 02:17:08 GMT

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

Re: accumulated

art297 — Sun, 14 May 2017 02:30:23 GMT

look up the WHERE statement and how to use it

Art, CEO, AnalystFinder.com

Re: code

art297 — Sun, 14 May 2017 02:53:25 GMT

Look up how to run proc means with a where statement

Art, CEO, AnalystFinder.com

Re: code

Reeza — Sun, 14 May 2017 04:31:38 GMT

Homework? You have no attachment.

And show what you've tried.

Re: accumulated

Reeza — Sun, 14 May 2017 04:41:02 GMT

1. Please do not post the same question multiple times.

2. Take the time to detail your question. We could probably answer this question at least 5 ways off the top of my head. However, you've likely learned some techniques in your classes that your instructor is expecting to see.

3. Your question is incredibly basic and a google query really should have solved your problems. Back in my day I had to search old textbooks for answers 😉

If you're genuinely interested in learning we'll be happy to help you out. If you want to get answers to your homework, go study, post what you've tried and we'll help you work through it.

support.sas.com/training/tutorial -> YouTube videos + Free e-course (Programming or Statistics) on bottom right hand corner

http://stats.idre.ucla.edu/sas/modules/descriptive-statistics/

Re: accumulated

Kurt_Bremser — Sun, 14 May 2017 06:33:37 GMT

@mageshb: You need to use the right tool for such a task. This tool sits between your ears, and I promise (from experience) that firing it up doesn't hurt.

You have been given enough pointers right now that solving your issue should be a breeze with just a little work by yourself.

Re: accumulated

ballardw — Mon, 15 May 2017 14:36:41 GMT

@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-data-AKA-generate/ta-p/258712 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.