hi,
i attached the dataset.Please code for accummulated.
syntax please
Write a SAS program to calculate accumulated total sales till 15th April. Use aprsales dataset from SAS dataset repository.
@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.
Write a SAS program to calculate accumulated total sales till 15th April. Use aprsales dataset from SAS dataset repository.
I'm unable to find your dataset here
Edit: Please unmark this from solution
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
Look up how to run proc means with a where statement
Art, CEO, AnalystFinder.com
Homework? You have no attachment.
And show what you've tried.
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.