Analytic programing 4- data manipulation and formatting
Because Eileen Dover, the CEO of Good For You! Bakery, began her business with limited background in data architecture, some historical data that was saved in legacy systems is in bad shape. For example, sales date information was entered haphazardly, in different formats; sometimes sales amounts included a dollar sign and cents to the right of the decimal, and sometimes they didn’t; and the alphanumeric code she initially used to designate products is confusing to her new managers.
Ms. Dover wants to ensure that she can move data from her legacy system to SAS®. She had one of her new IT people produce a pipe-delimited data file in .txt format. He was not able to do much data validation/cleaning on his end, and Ms. Dover wants to know if this crucial step can be completed in SAS®. She wants you to do the following:
- Import the legacy data file (Week 4 Assignment Data) into SAS®. (Note that if you look at the .txt file using a text editing program such as Notepad, you can see anomalies in the data; for example, dates and dollar amounts are represented in different formats.)
- Create a report that:
- Lists sales, by month, with subtotals and a grand total
- Interprets all dates correctly and displays them in the same format
- Interprets all dollar values correctly and displays them in the format $99
- Add comments to the SAS® code to explain what each section of the code does, so that your team can apply similar to logic to cleaning/validating other data files.
Submit your SAS® program.