Log in to UTS Canvas

Step- 1

Log in to UTS Canvas

Dashboard (uts.edu.au)Id- Jayanta.banik@student.uts.edu.auPassword- GopalGovindo@111

SAS Studio Details

Id- Jayanta.banik@student.uts.edu.auPassword- GopalGovindo@222

Step-2

Go to Dashborad

Go to SAS ( 26777)

Go to Assignment

Go to Upcoming Assignment- Data Analysis and reporting (Individual)

Look at the Instruction

Go to A2 store Finders

Go to Store by Keyword

Click on Food

Click on Little Bumble Reusabale Food Wrap ( The Store I have selected)

Click on the Store details in the below of Little Bumble Reusabale Food Wrap

You can see Product , Review , Categories and pages ( Excel already attached in this folder)

Assessment overview:

The purpose of this assessment is to manipulate a raw dataset. This means checking for missing values, duplicates, inconsistent entries (wrong values), variable names and labels, format, etc.(You can create new variables from the existing ones if you want to.)

Instructions:

Choose some online stores that interest you from theA2 Store FinderLinks to an external site.orthe list of available storesDownload the list of available stores, and request the data for those stores. The list is not the dataset, it is an index of the datasets.

Download the datasets for the stores you chose, and explore them.

Transform the raw datainto a structured formandto create a report that provides insightsto the analyst for further and more complex analyses. So try to tell a story with your report do analyses that mean something!

Automate and save your code, and generate a PDF report using ODS.

Prepare a brief video response to specific questions about the task. Questions will be available 1 week before due date.

What to submit:

Submit your code(Note that the code has to be automated once it is done, if you press run, you need to be able to do manipulation, run analyses and create the report!)

Submit your report inPDFformat(generated by your code using ODS)

Submit your Program Summary inPDFformat(generate it from the SAS Studio toolbar and print it to a PDF)

Submit your video response

How to submit:

You will submit this assignment on this page, and will be marked on your own assignment confidentially.

(Note that a20%penalty applies for each day after the deadline 5 days later = 0 points!)

Once you're ready to submit your assignment, click theStart Assignmentbutton.

Click on Upload Fileto upload your PDF report, Program Summary, .sas code, and video (you can also optionally add any comments to your submission here).

Then, click theSubmit Assignmentbutton, and you're done!

Good luck!

Rubric

A2 rubric

A2 rubric

Criteria Ratings Pts

This criterion is linked to a Learning OutcomeManipulation

This criteria assesses your ability to manipulate the data. The procedures you adopt and the quality of the code will be measured here. 50pts

This criterion is linked to a Learning OutcomeReport

This criteria assesses your ability to produce a report. Specifically, the type of analyses and the outlook of the report will be considered. 50pts

Total Points:100

Assessment 2 guidance and discussion

Assessment 2 is your chance to show mastery of all the techniques covered in the subject, and that you know the right situation to apply each technique.

You have a choice of many datasets to work with. They will allow you to demonstrate a range of SAS skills, and all require data cleaning.

You need to write your own questions. Please spend some time exploring and understanding the data. Find out where it came from and how it was put together. Look for interesting threads to follow.

If you're trying to do something interesting and SAS has got you a bit confused, ask me about it. I will bend over backwards to help students who are doing something interesting.

Index of analytical techniquesKnow what technique you want but can't remember where SAS hides it or where the video is? Try theIndex of Analytical Techniques.

Using SAS for your FBA assignment? Then theIndex of Analytical Techniquesis definitely what you need. And congratulations on doubling your study productivity...

Data preparation and cleaning you will probably use:

PROC IMPORT

PROC CONTENTS

Filter rows

Remove duplicates

Handle missing values

Macros

Formatting

Custom formatting

Use of functions

Change variable type

Conditional processing

Labels

Merging

Analysis and formatting you will probably use:

Proc Univariate

Proc Means (enhanced with use of appropriate options)

Proc Freq (enhanced with use of appropriate options)

Proc Sort

Proc Print (do not proc print more than a screenful of anything)

Graphs

Remove technical headings (e.g The UNIVARIATE Procedure) from report output

Add descriptive headings and titles

Subsetting columns

Export report

Your analysis needs to:

examine variables in ways that make sense

uncover findings of interest

provide insights that could lead to further analysis or decision-making

However:

You don't need to interpret your findings

You don't need to make business recommendations

You don't need to write interpretation or commentary into your report

Hints:

make sure your script runs completely with one click of the "run" button, in a fresh SAS session with an empty working library

check the log for errors and FIX THEM, your script should run with zero errors

if any table in your report is more than a page long it's probably not the right way to do the analysis, think again

remove as much irrelevant output from your report as you can, so that it's readable and presentable

What should be in your submission?

4 filesshould be in your submission:

The SAS program (.sas code / .sas file) -- in .sas format

The analysis report (or report) -- in PDF format as generated by SAS.

AProgram SummaryA video response

How do I make my report PDF?

There is only one way: useODS PDFDon'tsave your results tab and turn that into a PDF

Don'tput screenshots into a Word document and export that to PDF

Don'tturn your .sas file into a PDF