Details:
Read in the Price and Volume Excel sheets.
On you price data, decide on three companies that you want to work with.
Create a new variable Price_Change to reflect the closing price minus the opening price.
Create a new variable Percent_Change to reflect the Price_Change divided by the Open price. Format this new variable percent7.2.
Generate a PDF list data report in the Journal format containing Company, Date, Open, Close, Price_Change and Percent_Change - in that order.
Generate a PDF summary statistics report for Percent_Change for each company including only the mean, minimum, maximum, median and standard deviation.
Create a line chart of the Close price by company over time. All companies should be on the same graph, each represented by its own respective line. Be sure to include a legend.
Deliverables:
- Submit an Enterprise Guide Project (.egp file) including all of your steps. The project should run start to finish and not include any unnecessary steps.
- Create appropriate titles and footnotes for the listing report, summary statistics report and line chart.
- Rename task nodes to be descriptive of what they are accomplishing.
-Submit a screenshot of the process flow and the pdf copies generated.
Which step are you having problems with?
Describe what you have attempted and any result.
Which step are you having problems with?
Describe what you have attempted and any result.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.