首页
网站开发
桌面应用
管理软件
微信开发
App开发
嵌入式软件
工具软件
数据采集与分析
其他
首页
>
> 详细
MS3251代写、代做Python/Java程序
项目预算:
开发周期:
发布时间:
要求地区:
MS3251 Analytics Using SAS
Assignment 2
• You must complete the assignment by yourself. Exchanging ideas with classmates is
encouraged, but you must not cross the line between discussion and collaboration.
Showing your work to your classmates is a non-acceptable collaboration. All identified
collaboration work will have a 0 mark.
• Complete all questions. Put all of your SAS code into one PDF file. You must mark each
question’s answer as SAS comment statements in the code, such as /*Task 1*/. Name
your code file as nnnnnnnn.pdf, where nnnnnnnn is your full name.
• You should set all irrelevant statements in your code as SAS comment statements. Be
aware that your SAS code created under a non-English operating system may contain
extraneous characters when viewed in an English operating system. You are responsible
for ensuring your submitted code is free of these characters. All extraneous characters in
your submitted code will be considered errors.
• Utilising codes not included in the course notes will not be accepted as correct answers,
even though they are not wrong.
• When running in SAS OnDemand Studio, your submitted SAS code should be error-free.
• You must submit your code file via the link Assignment 2 under the Assignments section
of the course on Canvas. If you submit your file more than once, only the latest submitted
file will be marked. The assignment is due at 06:00 AM on 4 December 2024. Two marks
shall be deducted for every 1 minute or less late. The submission link will be closed at
06:30 AM on 4 December 2024. Submission by other methods will not be accepted.
Tasks
Download Assignment2.zip from the Assignments folder under the Files section. Expand the
zipped file for the following:
• Profile_2016.sas7bdat
• Flying_2016.sas7bdat
• Redemption_2016.sas7bdat
• Variables_Disctionary.xlsx
The variable descriptions can be found in Variables_Dictionary.xlsx. Do not change the
contents of these data sets unless you are told to do so explicitly.
You are asked to write an SAS program for the tasks below. Unless stated explicitly, you can
deploy multiple DATA steps and SAS procedures for each task.
Task 1:
Define a SAS library named xxxxxxxx for the folder containing the three SAS data sets in your
SAS Studio account, where xxxxxxxx is your given name (or first name). Use only the first eight
letters if your given name is longer than eight characters. For example, if your name is CHEN
Da Wen, the library name should be ‘dawen’.
Task 2:
Write a SAS program for the following activities: • Create a new data set named Profile that includes all columns and rows from
Profile_2016. Store Profile in the SAS Work library.
• Add a new column named Tenure to Profile. Calculate a member’s tenure as full years
from their join date to 1 January 2017. For example, if a member’s join date is 1 August
1996, their tenure on 1 January 2017 would be 20.
• Print a report showing the range (maximum minus minimum) of Tenure values in the
Profile. There is no need to include the report in your submitted code.
Task 3:
Write a SAS program for the following activities:
• Sort the observations in Profile by Member_ID.
• Sort the observations in Redemption_2016 by Member_ID and store the sorted data set
in a temporary SAS data set.
• Sort the observations in Flying_2016 by Member_ID and store the sorted data set in a
temporary SAS data set.
Task 4:
Write one SAS DATA step to reshape the sorted Flying_2016 data set by collapsing
observations with the same Member_Id into a single observation. Name this new SAS data
set Flying and store it in the SAS Work library. For each observation in Flying, create if needed
and keep only the following variables (the order of the variables is not specified) in the data
set:
Variable Name Description
Member_Id Member’s identity.
Air_CityU Number of times the member had flown with CityU Airlines (i.e.
Airline value = ‘CityU’) in 2016. Equal 0 if none.
Air_NonCityU Number of times the member had flown with non-CityU Airlines
(i.e. Airline value ^= ‘CityU’) in 2016. Equal 0 if none.
FlyBonus_Earned Total bonus points earned by the member from flying in 2016.
Task 5:
Write one SAS DATA step for all of the following activities:
• Merge the sorted Profile and Flying data sets by Member_ID. Name the merged data
set Profile1 and store it in the SAS Work library.
• Keep all columns from both data sets in Profile1.
• For members who did not fly in 2016, set Air_CityU and Air_NonCityU to 0.
• For members who did not earn bonus points from flying in 2016, set FlyBonus_Earned to
0.
Task 6:
Write one SAS DATA step for all of the following activities:
• Merge the sorted Redemption_2016 and Profile1 by Member_ID. Name the merged data
set Profile2.
• Sum the redemption points for each member in 2016. If a member had no redemption in
2016, set the sum to 0. Store these sums in a new column named Redeemed in Profile2. • Replace each member’s bonus point balance in Profile2 with a new balance value,
calculated as bonus point balance at the end of 2015 + bonus points earned from flying in
2016 – bonus points redeemed in 2016. {P.S. Some bonus point balances in the data set
may be negative. Keep them in the data set. No adjustment is required.}
• Each Member_ID appears only once in Profile2.
• Drop the variables Date and Redeemed_point from the sorted Redemption_2016 in
Profile2.
Task 7:
Write a SAS program to report the following statistics and information without requiring
further manual calculations:
a) The number of male members who flew only with CityU Airlines in 2016.
b) The number of members who had no bonus point redemptions in 2016.
c) The top 1000 bonus points earners in 2016.
There is no need to include the reports in your submitted code.
Task 8:
Write a SAS program to generate a report on the number of members in Profile2 for each of
the following bonus point balance groups:
a) 100,000 or lower
b) 100,001 – 300,000
c) 300,001 – 500,000
d) 500,001 or higher
You are not allowed to use the DATA step for this task. The report should look exactly like
this:
There is no need to include the reports in your submitted code.
{Hint: First, create a user-defined format for the bonus point balance groups. Next, use an
appropriate report procedure to write the results, including the formatted bonus point
balance values, to a SAS dataset. Finally, print that SAS dataset with the required title, labels,
and formats.}
-END-
软件开发、广告设计客服
QQ:99515681
邮箱:99515681@qq.com
工作时间:8:00-23:00
微信:codinghelp
热点项目
更多
代做 program、代写 c++设计程...
2024-12-23
comp2012j 代写、代做 java 设...
2024-12-23
代做 data 编程、代写 python/...
2024-12-23
代做en.553.413-613 applied s...
2024-12-23
代做steady-state analvsis代做...
2024-12-23
代写photo essay of a deciduo...
2024-12-23
代写gpa analyzer调试c/c++语言
2024-12-23
代做comp 330 (fall 2024): as...
2024-12-23
代写pstat 160a fall 2024 - a...
2024-12-23
代做pstat 160a: stochastic p...
2024-12-23
代做7ssgn110 environmental d...
2024-12-23
代做compsci 4039 programming...
2024-12-23
代做lab exercise 8: dictiona...
2024-12-23
热点标签
mktg2509
csci 2600
38170
lng302
csse3010
phas3226
77938
arch1162
engn4536/engn6536
acx5903
comp151101
phl245
cse12
comp9312
stat3016/6016
phas0038
comp2140
6qqmb312
xjco3011
rest0005
ematm0051
5qqmn219
lubs5062m
eee8155
cege0100
eap033
artd1109
mat246
etc3430
ecmm462
mis102
inft6800
ddes9903
comp6521
comp9517
comp3331/9331
comp4337
comp6008
comp9414
bu.231.790.81
man00150m
csb352h
math1041
eengm4100
isys1002
08
6057cem
mktg3504
mthm036
mtrx1701
mth3241
eeee3086
cmp-7038b
cmp-7000a
ints4010
econ2151
infs5710
fins5516
fin3309
fins5510
gsoe9340
math2007
math2036
soee5010
mark3088
infs3605
elec9714
comp2271
ma214
comp2211
infs3604
600426
sit254
acct3091
bbt405
msin0116
com107/com113
mark5826
sit120
comp9021
eco2101
eeen40700
cs253
ece3114
ecmm447
chns3000
math377
itd102
comp9444
comp(2041|9044)
econ0060
econ7230
mgt001371
ecs-323
cs6250
mgdi60012
mdia2012
comm221001
comm5000
ma1008
engl642
econ241
com333
math367
mis201
nbs-7041x
meek16104
econ2003
comm1190
mbas902
comp-1027
dpst1091
comp7315
eppd1033
m06
ee3025
msci231
bb113/bbs1063
fc709
comp3425
comp9417
econ42915
cb9101
math1102e
chme0017
fc307
mkt60104
5522usst
litr1-uc6201.200
ee1102
cosc2803
math39512
omp9727
int2067/int5051
bsb151
mgt253
fc021
babs2202
mis2002s
phya21
18-213
cege0012
mdia1002
math38032
mech5125
07
cisc102
mgx3110
cs240
11175
fin3020s
eco3420
ictten622
comp9727
cpt111
de114102d
mgm320h5s
bafi1019
math21112
efim20036
mn-3503
fins5568
110.807
bcpm000028
info6030
bma0092
bcpm0054
math20212
ce335
cs365
cenv6141
ftec5580
math2010
ec3450
comm1170
ecmt1010
csci-ua.0480-003
econ12-200
ib3960
ectb60h3f
cs247—assignment
tk3163
ics3u
ib3j80
comp20008
comp9334
eppd1063
acct2343
cct109
isys1055/3412
math350-real
math2014
eec180
stat141b
econ2101
msinm014/msing014/msing014b
fit2004
comp643
bu1002
cm2030
联系我们
- QQ: 9951568
© 2021
www.rj363.com
软件定制开发网!