Statistics
SOLUTION: SAS Code Project – Studypool
SOLUTION: SAS Code Project – Studypool.
STA 402/502 TERM PROJECT DESCRIPTION
Overview. Project work focuses on drawing data from complicated sources to prepare a new data set that is
ready for a statistical analysis. Projects are programming intensive and use computational tools discussed in
class, found in the text, or included in SAS.
Students are given a list of general topic areas from which data sets will be assigned. The instructor then assigns
a specific collection of data sets and a project task to each student. Project tasks consist of obtaining, cleaning,
extracting, transforming, combining and displaying data sets.
Four project phases (100 points, for 25% of the course grade)
See the course syllabus and Canvas assignments for timeline and due dates.
Project selection (4 points). Please complete the online survey to indicate the general topic area of the
available course data sets that you would like to work with. Within a few days, the instructor will provide you
with access to your assigned data sets and an assigned task that you will complete for your project.
Grading rubric for project selection phase: 4 points – Full credit for completing the survey.
Progress update (16 points). Please submit:
•
•
Your current project SAS code as a SAS program file (*.sas).
A PDF document containing the following material organized in this order:
1. Your name, class section, and the original statement from the instructor of your assigned task.
2. Progress report [2-4 pages] including a description of your project progress so far, your plans for
proceeding, and questions to the instructor on how to proceed. Please include enough detail
that the instructor can understand what you’ve done and can provide guidance on moving
forward with your project.
3. Example graphs and/or tables produced by your code, if any.
4. Your current SAS code.
Grading rubric for progress update phase:
4 points – PDF file organization (see above).
12 points – Code in progress. Full credit for submitting code that’s relevant to the project.
Preliminary review (32 points). By this stage you are expected to have completed the core aspects of data
input, preparation and display that underlie your assigned task. (It’s okay if you still have work left to do on code
flexibility, code documentation, redundant/repetitive code, or refining graphs/tables.) Please submit:
• Your current project SAS code as a SAS program file (*.sas file).
• A PDF document containing the following material organized in this order:
1. Your name, class section, and the original statement from the instructor of your assigned task.
2. Tables and graphs produced by your code, with up to 2 pages of narrative explanation of the
displays. Please write this section so that it can be understood by another STA 402/502 student
who is not familiar with your assigned data set or your code.
3. Plans for completing the project and questions (if any) to the instructor.
4. Your current SAS code.
Grading rubric for preliminary review phase:
4 points – PDF file organization (see above).
p.1
8 points – Graphs and/or tables.
Grading Criteria: Do the displays address the core aspects of the assigned task?
Excellent
Good
In progress
A Start
8 points
7 points
6-5 points
4-3 points
Task displays are
Includes examples of
Some displays for
Displays show data
appropriately
all displays required task are present and set features, but do
annotated.
for task.
others are lacking.
not address task.
0 points
None
included.
20 points – Code completeness.
Grading criteria: Are the core aspects of data input, preparation and display complete for the assigned
task?
Excellent
Good
In progress
A start
20 points
19-17 points
16-14 points
13-11 points
0 points
Assigned coding task Core aspects of task
Data input and
Data input and
None
is nearly complete.
code are ready,
preparation done,
preparation tasks
included.
except for minor
but still need to
not yet completed
issues and code
address some key
or correct.
flexibility.
subtasks.
Final submission (48 points). To complete the project, the graphs and tables produced by your code
should be carefully constructed and annotated. Your SAS program(s) should include all code needed for data
input, data preparation, tables and graphs per the assigned task. Your code should be fully documented and
structured for readability, use macros where appropriate, and include no redundant or repetitive code. Please
submit:
• Your final documented SAS code as SAS program file(s), packaged according to the instructions on the
final page of this document.
• A PDF document containing the following material organized in this order:
1. Your name, class section, and the original statement from the instructor of your assigned task.
2. Tables and graphs produced by your code to demonstrate that the assigned task has been
completed, with narrative explanation of the displays. Please write this section so that it can be
understood by another STA 402/502 student who is not familiar with your assigned data set or
your code.
3. Your final documented SAS code.
Grading rubric for final submission:
4 points – PDF file organization (see above).
8 points – Code presentation.
Grading criteria: Is the code easy to understand? Is documentation appropriate? Is repetitive and
unnecessary code avoided?
Excellent
Good
In progress
A Start
8 points
7 points
6-5 points
4-3 points
0 points
Thorough, accurate
No unnecessary
Sparse comments
Few comments.
Bare
comments. Elegant, code. Easy to read.
or awkward
Difficult to
code.
efficient code.
Good commenting,
formatting.
understand what is
formatting, and
Redundant or
being attempted.
object names.
repetitive code.
p.2
8 points – Code correctness.
Grading Criteria: Does the code run correctly and produce the displays required by the assigned task?
Excellent
Good
In progress
A Start
8 points
7 points
6-5 points
4-3 points
0 points
Coding solution
Code runs correctly
Code is complete
Code is incomplete No code.
provides extra value
and produces the
but cannot be run
and does not
beyond task (such as
required displays.
without errors or
address core tasks.
speed, storage use,
some modification.
robustness, etc.)
8 points – Code flexibility.
Grading criteria: Do macros provide the flexibility required by the assigned task?
Excellent
Good
In progress
A Start
7 points
6 points
5-4 points
3 points
Macros provide
Macros provide
Some flexibility
Mere existence of
useful flexibility
requested flexibility.
implemented, but
macro code or
beyond assigned
not fully addressing
macro variables.
task.
assigned task.
8 points – Graphs and/or Tables.
Grading Criteria: Are displays well designed and appropriately annotated?
Excellent
Good
In progress
A Start
8 points
7 points
6-5 points
4-3 points
Creative displays
Well-designed and
Some displays or
Unsuitable displays
that yield strong
appropriately
annotations
and annotations.
insights.
annotated displays.
awkward.
6 points – Overall Project Execution.
Grading criteria: Is the solution appropriate in complexity and scope?
Excellent
Good
In progress
10 points
9 points
7-6 points
Task addressed
Appropriate
Some important
innovatively or
approach and effort. gaps in approach or
independently.
effort.
A Start
5-4 points
Weak effort.
Lightweight or
unsuitable
approach.
0 points
None
included.
0 points
None
included.
0 points
No submission.
6 points – Responsiveness to instructor feedback.
Grading criteria: Were the instructor’s comments and suggestions on coding and draft report suitably
addressed by the end?
Excellent
Good
In progress
6 points
5-4 points
3-2 points
0 points
All comments and suggestions
Major comments and
Some major comments
No major
fully addressed or resolved.
suggestions addressed
and suggestions not
suggestions
Or no suggestions were needed
or resolved, but some
adequately addressed.
or comments
during the preliminary review.
minor items not
addressed.
addressed.
p.3
Project Code Preparation for Final Submission
The instructor will run your final SAS code to make sure that it works without errors, that it works for other
parameter choices made by the instructor, and that it creates output matching the output shown in your report.
Please include a detailed header comment block at the beginning of your main SAS file indicating what the
program does and giving clear instructions on how to use the code. The instructions in your header comments
should:
A. Explain the method by which the instructor can run your code to set things up, if this requires a
separate action.
B. Explain how, after the setup actions, to invoke the macro(s) by which the user makes selections
according to the specifications of your assigned task.
C. Provide, as examples, the particular macro invocations needed to create the output shown in your
report.
The instructor will place your submitted SAS file(s) (with *.sas extensions) in a folder that also contains copies of
the datasets that you originally found in your assigned Google Drive folder. Please organize your macro SAS file
so that the instructor can use one of the following two methods to run your code.
METHOD 1. The instructor opens a SAS file labeled clearly as the main *.sas file. Just before the header
comment block, there is just one %LET statement where the instructor specifies the folder. After changing
the folder, the instructor runs the entire file so that it defines whatever macros are needed and sets up
whatever new files or data sets are needed. Then the instructor opens a new SAS Editor window to type and
run invocations of the user-oriented flexible macro that accomplishes your assigned task.
METHOD 2. The instructor opens a SAS file labeled clearly as the main *.sas file and then runs the entire file
so that it defines whatever macros are needed and sets up whatever new files or data sets are needed. Then
the instructor opens a new SAS Editor window to type and run invocations of the user-oriented flexible
macro that accomplishes your assigned task. (For this method, one or more of your user-oriented macros
may need to request the instructor’s folder as one of its input parameters.)
Important Notes
• Your code should not automatically invoke the macro that provides the user flexibility, but it can invoke
macros used for setting up files and data sets.
• Your instructions should not require the user to select particular parts of your code to run. The user
should run your entire file at once to set up everything and then call your macro(s) on their own.
• Examples of the two methods above available. See the programs GradesOverTime_method1.sas and
GradesOverTime_method2.sas on Canvas.
Reminders on code presentation and documentation. Please include light comments throughout your code,
along with meaningful variable and dataset names, sensible indentation and spacing for readability, RUN/QUIT
statements for PROCs and DATA steps, and DATA= clauses in PROC statements. To avoid superfluous code,
please perform (wherever possible) multiple actions in a single PROC or DATA step rather than using multiple
PROC and DATA steps in sequence to perform a small number of adjustments. Please avoid repetitive or
redundant code by using macros, loops and/or arrays.
p.4
Wenshu Yang / STA402 A / Term Project: Assigned Task
Please save this document for your records.
Your assigned project using dataset(s) in the general topic of Hospitality and Travel can be found in the airbnb folder
at the following link:
• https://drive.google.com/drive/folders/1oFp652vbcrU8vi73rfHVFPb0XETf47CK
Please refer to the file README-airbnb.txt if you have not already done so.
Here is your assigned task for the term project:
• Choose a city that you’re interested in. You may use one of the cities in the project folder or download the
same format of Airbnb data for another city. If someone plans to visit this city for 5 days and they plan to
find a place to live on Airbnb, could you give them some information about what types of rooms are
available, the prices, the typical modes of transportation, and so on for each neighborhood? Give them
some suggestions. Write your code as a SAS macro program so that it can be applied to analyze at least
one other city.
Purchase answer to see full
attachment
Overview. Project work focuses on drawing data from complicated sources to prepare a new data set that is
ready for a statistical analysis. Projects are programming intensive and use computational tools discussed in
class, found in the text, or included in SAS.
Students are given a list of general topic areas from which data sets will be assigned. The instructor then assigns
a specific collection of data sets and a project task to each student. Project tasks consist of obtaining, cleaning,
extracting, transforming, combining and displaying data sets.
Four project phases (100 points, for 25% of the course grade)
See the course syllabus and Canvas assignments for timeline and due dates.
Project selection (4 points). Please complete the online survey to indicate the general topic area of the
available course data sets that you would like to work with. Within a few days, the instructor will provide you
with access to your assigned data sets and an assigned task that you will complete for your project.
Grading rubric for project selection phase: 4 points – Full credit for completing the survey.
Progress update (16 points). Please submit:
•
•
Your current project SAS code as a SAS program file (*.sas).
A PDF document containing the following material organized in this order:
1. Your name, class section, and the original statement from the instructor of your assigned task.
2. Progress report [2-4 pages] including a description of your project progress so far, your plans for
proceeding, and questions to the instructor on how to proceed. Please include enough detail
that the instructor can understand what you’ve done and can provide guidance on moving
forward with your project.
3. Example graphs and/or tables produced by your code, if any.
4. Your current SAS code.
Grading rubric for progress update phase:
4 points – PDF file organization (see above).
12 points – Code in progress. Full credit for submitting code that’s relevant to the project.
Preliminary review (32 points). By this stage you are expected to have completed the core aspects of data
input, preparation and display that underlie your assigned task. (It’s okay if you still have work left to do on code
flexibility, code documentation, redundant/repetitive code, or refining graphs/tables.) Please submit:
• Your current project SAS code as a SAS program file (*.sas file).
• A PDF document containing the following material organized in this order:
1. Your name, class section, and the original statement from the instructor of your assigned task.
2. Tables and graphs produced by your code, with up to 2 pages of narrative explanation of the
displays. Please write this section so that it can be understood by another STA 402/502 student
who is not familiar with your assigned data set or your code.
3. Plans for completing the project and questions (if any) to the instructor.
4. Your current SAS code.
Grading rubric for preliminary review phase:
4 points – PDF file organization (see above).
p.1
8 points – Graphs and/or tables.
Grading Criteria: Do the displays address the core aspects of the assigned task?
Excellent
Good
In progress
A Start
8 points
7 points
6-5 points
4-3 points
Task displays are
Includes examples of
Some displays for
Displays show data
appropriately
all displays required task are present and set features, but do
annotated.
for task.
others are lacking.
not address task.
0 points
None
included.
20 points – Code completeness.
Grading criteria: Are the core aspects of data input, preparation and display complete for the assigned
task?
Excellent
Good
In progress
A start
20 points
19-17 points
16-14 points
13-11 points
0 points
Assigned coding task Core aspects of task
Data input and
Data input and
None
is nearly complete.
code are ready,
preparation done,
preparation tasks
included.
except for minor
but still need to
not yet completed
issues and code
address some key
or correct.
flexibility.
subtasks.
Final submission (48 points). To complete the project, the graphs and tables produced by your code
should be carefully constructed and annotated. Your SAS program(s) should include all code needed for data
input, data preparation, tables and graphs per the assigned task. Your code should be fully documented and
structured for readability, use macros where appropriate, and include no redundant or repetitive code. Please
submit:
• Your final documented SAS code as SAS program file(s), packaged according to the instructions on the
final page of this document.
• A PDF document containing the following material organized in this order:
1. Your name, class section, and the original statement from the instructor of your assigned task.
2. Tables and graphs produced by your code to demonstrate that the assigned task has been
completed, with narrative explanation of the displays. Please write this section so that it can be
understood by another STA 402/502 student who is not familiar with your assigned data set or
your code.
3. Your final documented SAS code.
Grading rubric for final submission:
4 points – PDF file organization (see above).
8 points – Code presentation.
Grading criteria: Is the code easy to understand? Is documentation appropriate? Is repetitive and
unnecessary code avoided?
Excellent
Good
In progress
A Start
8 points
7 points
6-5 points
4-3 points
0 points
Thorough, accurate
No unnecessary
Sparse comments
Few comments.
Bare
comments. Elegant, code. Easy to read.
or awkward
Difficult to
code.
efficient code.
Good commenting,
formatting.
understand what is
formatting, and
Redundant or
being attempted.
object names.
repetitive code.
p.2
8 points – Code correctness.
Grading Criteria: Does the code run correctly and produce the displays required by the assigned task?
Excellent
Good
In progress
A Start
8 points
7 points
6-5 points
4-3 points
0 points
Coding solution
Code runs correctly
Code is complete
Code is incomplete No code.
provides extra value
and produces the
but cannot be run
and does not
beyond task (such as
required displays.
without errors or
address core tasks.
speed, storage use,
some modification.
robustness, etc.)
8 points – Code flexibility.
Grading criteria: Do macros provide the flexibility required by the assigned task?
Excellent
Good
In progress
A Start
7 points
6 points
5-4 points
3 points
Macros provide
Macros provide
Some flexibility
Mere existence of
useful flexibility
requested flexibility.
implemented, but
macro code or
beyond assigned
not fully addressing
macro variables.
task.
assigned task.
8 points – Graphs and/or Tables.
Grading Criteria: Are displays well designed and appropriately annotated?
Excellent
Good
In progress
A Start
8 points
7 points
6-5 points
4-3 points
Creative displays
Well-designed and
Some displays or
Unsuitable displays
that yield strong
appropriately
annotations
and annotations.
insights.
annotated displays.
awkward.
6 points – Overall Project Execution.
Grading criteria: Is the solution appropriate in complexity and scope?
Excellent
Good
In progress
10 points
9 points
7-6 points
Task addressed
Appropriate
Some important
innovatively or
approach and effort. gaps in approach or
independently.
effort.
A Start
5-4 points
Weak effort.
Lightweight or
unsuitable
approach.
0 points
None
included.
0 points
None
included.
0 points
No submission.
6 points – Responsiveness to instructor feedback.
Grading criteria: Were the instructor’s comments and suggestions on coding and draft report suitably
addressed by the end?
Excellent
Good
In progress
6 points
5-4 points
3-2 points
0 points
All comments and suggestions
Major comments and
Some major comments
No major
fully addressed or resolved.
suggestions addressed
and suggestions not
suggestions
Or no suggestions were needed
or resolved, but some
adequately addressed.
or comments
during the preliminary review.
minor items not
addressed.
addressed.
p.3
Project Code Preparation for Final Submission
The instructor will run your final SAS code to make sure that it works without errors, that it works for other
parameter choices made by the instructor, and that it creates output matching the output shown in your report.
Please include a detailed header comment block at the beginning of your main SAS file indicating what the
program does and giving clear instructions on how to use the code. The instructions in your header comments
should:
A. Explain the method by which the instructor can run your code to set things up, if this requires a
separate action.
B. Explain how, after the setup actions, to invoke the macro(s) by which the user makes selections
according to the specifications of your assigned task.
C. Provide, as examples, the particular macro invocations needed to create the output shown in your
report.
The instructor will place your submitted SAS file(s) (with *.sas extensions) in a folder that also contains copies of
the datasets that you originally found in your assigned Google Drive folder. Please organize your macro SAS file
so that the instructor can use one of the following two methods to run your code.
METHOD 1. The instructor opens a SAS file labeled clearly as the main *.sas file. Just before the header
comment block, there is just one %LET statement where the instructor specifies the folder. After changing
the folder, the instructor runs the entire file so that it defines whatever macros are needed and sets up
whatever new files or data sets are needed. Then the instructor opens a new SAS Editor window to type and
run invocations of the user-oriented flexible macro that accomplishes your assigned task.
METHOD 2. The instructor opens a SAS file labeled clearly as the main *.sas file and then runs the entire file
so that it defines whatever macros are needed and sets up whatever new files or data sets are needed. Then
the instructor opens a new SAS Editor window to type and run invocations of the user-oriented flexible
macro that accomplishes your assigned task. (For this method, one or more of your user-oriented macros
may need to request the instructor’s folder as one of its input parameters.)
Important Notes
• Your code should not automatically invoke the macro that provides the user flexibility, but it can invoke
macros used for setting up files and data sets.
• Your instructions should not require the user to select particular parts of your code to run. The user
should run your entire file at once to set up everything and then call your macro(s) on their own.
• Examples of the two methods above available. See the programs GradesOverTime_method1.sas and
GradesOverTime_method2.sas on Canvas.
Reminders on code presentation and documentation. Please include light comments throughout your code,
along with meaningful variable and dataset names, sensible indentation and spacing for readability, RUN/QUIT
statements for PROCs and DATA steps, and DATA= clauses in PROC statements. To avoid superfluous code,
please perform (wherever possible) multiple actions in a single PROC or DATA step rather than using multiple
PROC and DATA steps in sequence to perform a small number of adjustments. Please avoid repetitive or
redundant code by using macros, loops and/or arrays.
p.4
Wenshu Yang / STA402 A / Term Project: Assigned Task
Please save this document for your records.
Your assigned project using dataset(s) in the general topic of Hospitality and Travel can be found in the airbnb folder
at the following link:
• https://drive.google.com/drive/folders/1oFp652vbcrU8vi73rfHVFPb0XETf47CK
Please refer to the file README-airbnb.txt if you have not already done so.
Here is your assigned task for the term project:
• Choose a city that you’re interested in. You may use one of the cities in the project folder or download the
same format of Airbnb data for another city. If someone plans to visit this city for 5 days and they plan to
find a place to live on Airbnb, could you give them some information about what types of rooms are
available, the prices, the typical modes of transportation, and so on for each neighborhood? Give them
some suggestions. Write your code as a SAS macro program so that it can be applied to analyze at least
one other city.
Purchase answer to see full
attachment