12/15/2022 SAS advanced（考过）lab机经数据整理，可以直接在studio中执行

/***首先，特此感谢地里前辈们的辛勤耕耘和帮助！！**/
/***************************************************************************************************

其次，
     整理了一下SAS advance lab机经练习题中需要使用的数据和练习程序，如下：
1、lab机经数据文件的建立（文件名称为：lib.sas ,并已经在SAS studio中试验）：
2、文件中只用了一种数据输入模式，请大家在练习的时候，根据自己的需求和喜好，合理使用推荐的数据；
3、请大家在本文的最后，下载相关的文件（数据文件lib_file和程序文件coding_file）；
4、本文所使用的数据，是根据地里面前辈们所提供的数据。
5、请在使用数据的同时，对提供数据的
                                                   地里的前辈们
                                                致以崇高的敬意！！
***************************************************************************************************/
/*数据文件*/
data work.transact;
infile datalines;
input Rep $ Cost Ship;
datalines;
SMITH 200 50
SMITH 400 20
JONES 100 10
SMITH 600 100
JONES 100 5
;
run;
data pilots;
infile datalines;
input Id $ Name $ Jobcode $ Salary;
datalines;
001 Albert PT1 50000
002 Brenda PT1 70000
003 Carl PT1 60000
004 Donna PT2 80000
005 Edward PT2 90000
006 Flora PT3 100000
;
run;
data customer;
infile datalines;
input Customer_ID $ Amount;
datalines;
A112 105
A112 352
A005 930
B152 530
C592 952
T152 742
H125 656
A005 110
C592 150
B152 220
T152 110
;
run;
data year_1 ;
   a = 100 ;
run ;
data revenue ;
  set year_1 ;
  var1 = mdy(1,15,1960);
run;
data temp;
infile datalines;
input id $ amount;
datalines;
P 52
P 45
A 13
A 56
R 34
R 12
R 78
;
. ----run;
* Raw Data File;
data bytest_raw;
infile datalines;
. input id$ amount;
datalines;
B 52
C 12
A 13
B 34
C 45
A 56
C 78
;
run;
data class1;
infile datalines;
input name $ course $;
datalines;
Lauren MATH1
Patel MATH1
Chang MATH1
;
run;
data class2;
infile datalines;
input name $ course $;
datalines;
Smith MATH2
Farmer MATH2
Patel MATH2
Hillier MATH2
;
run;
data WORK.BDAYINFO;
infile datalines;
input Name $ Birthday : mmddyy10.;
datalines;
Alan 11/15/1950
Barb 08/23/1966
Carl 09/01/1963
;
run;
data work.new ;
length word $7 ;
amount = 4 ;
if amount = 4 then wrod = 'FOUR';
else if amount = 7 then word = 'SEVEN' ;
else wrod = 'NONE!!!' ;
amount = 7 ;
run ;
data employ_info ;
input id expense ;
cards ;
2542 100.00
3612 133.15
3612 188.12
2198 234.34
2198 111.12
2198 100.99
;
run ;
data work.labcase1;
infile datalines;
input name $ Cost Ship;
datalines;
SMITH 200 50
SMITH 400 20
JONES 100 10
SMITH 600 100
JONES 100 5
;
run;
data work.labcase2;
infile datalines;
input name $ Cost Ship;
datalines;
SMITH 200 50
SMITH 400 20
JONES 100 10
SMITH 600 100
JONES 100 5
newyorker 90000 850
whitehuman 10000 850
;
run;
data work.lab2case;
infile datalines;
input name $ did;
datalines;
zhang 1
li 5
wang 7
zhao 8
jin 9
xu 45
rong 12
tian 34
cai 56
;
run;
data work.lab3;
infile datalines ;
input region $ height weight;
datalines;
AE 200 20
WE 300 50
EE 500 60
QQ 600 70
JJ 700 99
;
run;
data work.cars;
infile datalines;
input make $ type $;
datalines;
honda suv
honda sedan
honda truck
toyota suv
toyota sedan
toyota truck
vw suv
vw sedan
vw truck
ford suv
ford sedan
ford truck
;
run;
data work.rebate;
infile datalines;
input make $ type $ rebate $;
datalines;
honda suv 9.556407486
honda sedan 6.350148985
toyota suv 7.174268158
toyota truck 5.552950811
vw suv 1.517456941
vw truck 6.994231845
ford suv 8.987915097
ford truck 8.625257191
;
run;
data work.lab5;
infile datalines;
input name $ height $ weight $;
datalines;
zhang 180 200
li 165 210
wang 175 195
zhao 168 185
jin 175 160
xu 165 161
rong 170 161
tian 168 191
cai 181 191
;
run;
data work.lab6;
infile datalines;
input name $ salary 11.6 DID $;
datalines;
zhang 8899.148357 1
zhang 4111.722812 5
. 1point 3acres zhang 690.7052162 1
zhang 8861.054447 5
zhang 6469.917483 3
zhang 324.0552641 5
zhang 2928.741896 3
zhang 7816.233655 5
zhang 3785.031482 3
;
run;
data work.lab7;
infile datalines;
input name $ salary 11.6 did $;
datalines;
zhang 8899.148357 1
.--li 4111.722812 5
wang 690.7052162 1
zhao 8861.054447 5
jin 6469.917483 3
xu 324.0552641 5
rong 2928.741896 3
tian 7816.233655 5
cai 3785.031482 3
;
run;
data work.lab13;
infile datalines;
input name $ n $ m $ p $ q $ s $ t $;
datalines;
zhang 7 7 3 8 3 3
li 3 . 7 0 5 1
wang 2 9 7 3 . 9
zhao . 5 5 5 9 .
jin . 2 9 . . 6
xu 9 7 5 6 8 6
rong 5 9 2 6 4 8
tian 3 . 3 2 6 1
cai 4 1 6 4 6 .
;
run;
data work.lab14;
infile datalines;
input name $ var12 $ var13 $ var14 $ var15 $;
datalines;
zhang 7 7 3 8
li 3 . 7 0
wang 2 9 7 3
zhao . 5 5 5
jin . 2 9 .
xu 9 7 5 6
rong 5 9 2 6
tian 3 . 3 2
cai 4 1 6 4
;
run;
data work.lab15;
infile datalines;
input name $ q1 $ q2 $ q3 $ q4 $ q5 $ q6 $ q7 $ q8 $ q9 $ q10 $;
datalines;
zhang A B C C A B C C A B
li B C E D B C E D B C
wang C C B B C C B B C C
zhao D E E D D E E D D E
jin E C D D E C D D E C
xu D C C A D C C A D C
rong C A A D C A A D C A
tian A C C D A C C D A C
cai C C A C C C A C C C
;
. Χrun;
data work.lab16;
infile datalines;
input name $ height1 10.8 height2 10.8 height3 10.8;
datalines;
zhang 55.68073158 17.36286971 6.683723652
li 46.15443044 27.20493545 40.98138739
wang 37.18154755 14.45504185 10.89584446
. 1point 3 acreszhao 8.673056717 50.37669866 7.753530363
jin 18.83496055 14.96355251 39.3066065
xu 19.07325707 18.67063944 16.3815719
rong 24.3756752 1.142659773 0.258769394
tian 53.97486316 45.24130604 3.437027384
cai 58.55725669 28.85827695 12.10446774
;
run;
data work.lab17;
infile datalines;
input name $ height 10.8;
datalines;
zhang 55.68073158
li 46.15443044
wang 37.18154755
zhao 8.673056717
jin 18.83496055
xu 19.07325707
rong 24.3756752
tian 53.97486316
cai 58.55725669
;
run;
data work.lab18;
infile datalines;
input name $ weight 10.8;
datalines;
zhang 55.68073158
li 46.15443044
wang 37.18154755
zhao 8.673056717
jin 18.83496055
xu 19.07325707
rong 24.3756752
tian 53.97486316
cai 58.55725669
;
run;
data work.lab19;
infile datalines;
input name $;
datalines;
Zhang,Yu
Wang,Xiaoer
Li,Xiaowu
Ding,Dayi
;
run;
data work.lab20;
infile datalines;
input name $ country_code $ country_name $ name1 $;
datalines;
zhang zhang zhang zhang
li 9 BB li
wang 7 CC wang
zhao 5 EE zhao
jin 5 FF jin
xu 2 GG xu
rong 3 HH rong
tian 5 KK tian
cai 7 NN cai
;
run;
data work.lab21;
infile datalines;
input name $ country_code $ counrty_name $;
datalines;
cai 7 NN
kim 12 XX
you 17 YY
no 18 ZZ
yes 20 AZ
;
run;
data work.transact;
.. infile datalines;
input Rep $ Cost Ship;
datalines;
SMITH 200 50
SMITH 400 20
JONES 100 10
SMITH 600 100
JONES 100 5
;
run;
data pilots;
infile datalines;
input Id $ Name $ Jobcode $ Salary;
datalines;
001 Albert PT1 50000
002 Brenda PT1 70000
003 Carl PT1 60000
004 Donna PT2 80000
005 Edward PT2 90000
006 Flora PT3 100000
;
run;
data customer;
infile datalines;
input Customer_ID $ Amount;
datalines;
A112 105
A112 352
A005 930
. .иB152 530
C592 952
T152 742
H125 656
A005 110
C592 150
B152 220
T152 110
;
run;
data year_1 ;
   a = 100 ;
run ;
data revenue ;
  set year_1 ;
  var1 = mdy(1,15,1960);
run;
data temp;
infile datalines;
input id $ amount;
datalines;
P 52
P 45
A 13
A 56
R 34
R 12
R 78
;
run;
* Raw Data File;
data bytest_raw;
infile datalines;
input id$ amount;
datalines;
B 52
C 12
A 13
B 34
C 45
A 56
C 78
;
run;
data class1;
infile datalines;
input name $ course $;
datalines;
Lauren MATH1
Patel MATH1
Chang MATH1
;
. 1point3acresrun;
data class2;
infile datalines;
input name $ course $;
datalines;
Smith MATH2
Farmer MATH2
Patel MATH2
Hillier MATH2
;
run;
data WORK.BDAYINFO;
infile datalines;
input Name $ Birthday : mmddyy10.;
datalines;
Alan 11/15/1950
Barb 08/23/1966
Carl 09/01/1963
;
run;
data work.new ;
length word $7 ;
amount = 4 ;
if amount = 4 then wrod = 'FOUR';
else if amount = 7 then word = 'SEVEN' ;
else wrod = 'NONE!!!' ;
amount = 7 ;
run ;
data employ_info ;
input id expense ;
cards ;
2542 100.00
3612 133.15
3612 188.12
2198 234.34
2198 111.12
2198 100.99
;
run ;
data work.labcase1;
infile datalines;
input name $ Cost Ship;
datalines;
SMITH 200 50
SMITH 400 20
JONES 100 10
SMITH 600 100
JONES 100 5
;
run;
data work.labcase2;
infile datalines;
input name $ Cost Ship;
datalines;
SMITH 200 50
SMITH 400 20
JONES 100 10
SMITH 600 100
JONES 100 5
newyorker 90000 850
whitehuman 10000 850
;
run;
data work.lab2case;
infile datalines;
input name $ did;
datalines;
zhang 1
li 5
wang 7
zhao 8
jin 9
xu 45
rong 12
tian 34
cai 56
;
run;
data work.lab3;
infile datalines ;
input region $ height weight;
datalines;
AE 200 20
WE 300 50
EE 500 60
QQ 600 70
JJ 700 99
;
run;
data work.cars;
infile datalines;
input make $ type $;
datalines;
honda suv
honda sedan
honda truck
toyota suv
toyota sedan
toyota truck
vw suv
vw sedan
vw truck
ford suv
ford sedan
ford truck
;
run;
data work.rebate;
infile datalines;
input make $ type $ rebate $;
datalines;
honda suv 9.556407486
honda sedan 6.350148985
toyota suv 7.174268158
toyota truck 5.552950811
vw suv 1.517456941
vw truck 6.994231845
ford suv 8.987915097
ford truck 8.625257191
;
run;
data work.lab5;
infile datalines;
input name $ height $ weight $;
datalines;
zhang 180 200
li 165 210
wang 175 195
zhao 168 185
jin 175 160
xu 165 161
rong 170 161
tian 168 191
cai 181 191
;
run;
data work.lab6;
infile datalines;
input name $ salary 11.6 DID $;
datalines;
zhang 8899.148357 1
zhang 4111.722812 5
zhang 690.7052162 1
zhang 8861.054447 5
zhang 6469.917483 3
zhang 324.0552641 5
zhang 2928.741896 3
zhang 7816.233655 5
zhang 3785.031482 3
;
run;
data work.lab7;
infile datalines;
input name $ salary 11.6 did $;
datalines;
zhang 8899.148357 1
li 4111.722812 5
wang 690.7052162 1
zhao 8861.054447 5
jin 6469.917483 3
xu 324.0552641 5
rong 2928.741896 3
tian 7816.233655 5
cai 3785.031482 3
;
run;
data work.lab13;
infile datalines;
input name $ n $ m $ p $ q $ s $ t $;
datalines;
zhang 7 7 3 8 3 3
li 3 . 7 0 5 1
wang 2 9 7 3 . 9
zhao . 5 5 5 9 .
jin . 2 9 . . 6
xu 9 7 5 6 8 6
rong 5 9 2 6 4 8
tian 3 . 3 2 6 1
cai 4 1 6 4 6 .
;
run;
data work.lab14;
infile datalines;
input name $ var12 $ var13 $ var14 $ var15 $;
datalines;
zhang 7 7 3 8
li 3 . 7 0
wang 2 9 7 3
zhao . 5 5 5
jin . 2 9 .
xu 9 7 5 6
rong 5 9 2 6
tian 3 . 3 2
cai 4 1 6 4
;
run;
data work.lab15;
infile datalines;
input name $ q1 $ q2 $ q3 $ q4 $ q5 $ q6 $ q7 $ q8 $ q9 $ q10 $;
datalines;
zhang A B C C A B C C A B
li B C E D B C E D B C
wang C C B B C C B B C C
zhao D E E D D E E D D E
jin E C D D E C D D E C
xu D C C A D C C A D C
rong C A A D C A A D C A
tian A C C D A C C D A C
cai C C A C C C A C C C
;
run;
data work.lab16;
infile datalines;
input name $ height1 10.8 height2 10.8 height3 10.8;
datalines;
zhang 55.68073158 17.36286971 6.683723652
li 46.15443044 27.20493545 40.98138739
wang 37.18154755 14.45504185 10.89584446
zhao 8.673056717 50.37669866 7.753530363
jin 18.83496055 14.96355251 39.3066065
xu 19.07325707 18.67063944 16.3815719
rong 24.3756752 1.142659773 0.258769394
tian 53.97486316 45.24130604 3.437027384
cai 58.55725669 28.85827695 12.10446774
;
run;
data work.lab17;
infile datalines;
input name $ height 10.8;
datalines;
zhang 55.68073158
li 46.15443044
wang 37.18154755
zhao 8.673056717
jin 18.83496055
xu 19.07325707
rong 24.3756752
tian 53.97486316
cai 58.55725669
;
run;
data work.lab18;
infile datalines;
input name $ weight 10.8;
datalines;
zhang 55.68073158
li 46.15443044
wang 37.18154755
zhao 8.673056717
jin 18.83496055
xu 19.07325707
rong 24.3756752
tian 53.97486316
cai 58.55725669
;
run;
data work.lab19;
infile datalines;
input name $;
datalines;
Zhang,Yu
Wang,Xiaoer
Li,Xiaowu
Ding,Dayi
;
run;
data work.lab20;
infile datalines;
input name $ country_code $ country_name $ name1 $;
datalines;
zhang zhang zhang zhang
li 9 BB li
wang 7 CC wang
zhao 5 EE zhao
jin 5 FF jin
xu 2 GG xu
rong 3 HH rong
tian 5 KK tian
cai 7 NN cai
;
run;
data work.lab21;
infile datalines;
input name $ country_code $ counrty_name $;
datalines;
cai 7 NN
kim 12 XX
you 17 YY
no 18 ZZ
yes 20 AZ
;
run;
/*建立好数据文件之后，如果使用sas studio，每次写程序前，运行一下数据文件即可！*/
/*在此预祝大家，考试取得好成绩！*/

rachellqqii 发表于 2023-1-28 12:49
哈咯，我是地里新人，目前还没有大米qaq , 请问可以email我一下这两份zip文件吗，真的非常感谢～
我的邮箱 ...

.1point3acres抱歉这段时间没有在地里，你可以去回答问题，看看“新人上路”模块。做个考试啥的，就能有100个大米呢！

CHINSING90 发表于 2023-5-16 09:51
. ----想问下 那个sas_adv_coding_file 里的 txt file 是 空白的吗？因为我下载了但sas_adv_coding_file zip 里面 ...

刚看到消息，再给你个程序的文件，请查收附件

想要奶茶自由 发表于 2023-6-27 16:23
感谢分享！楼主或许也能分享一下匹配的题目吗？不知道什么时候要用哪个dataset有点迷茫……

看程序里面，会用到dataset的名字

谢谢分享！

谢谢分享！

哈咯，我是地里新人，目前还没有大米qaq , 请问可以email我一下这两份zip文件吗，真的非常感谢～
我的邮箱是：wq80587@gmail.com

feiying8387 发表于 2023-2-23 11:59
抱歉这段时间没有在地里，你可以去回答问题，看看“新人上路”模块。做个考试啥的，就能有100个大米呢！

好的！感谢～

rachellqqii 发表于 2023-2-23 17:44
好的！感谢～

客气了，祝取得好成绩！

想问下 那个sas_adv_coding_file 里的 txt file 是 空白的吗？因为我下载了但sas_adv_coding_file zip 里面的 txt file 是空白的。

感谢分享！楼主或许也能分享一下匹配的题目吗？不知道什么时候要用哪个dataset有点迷茫……