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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: