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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.