y******6 发帖数: 47 | 1 我也攒点人品:以下题目一个是从银行(risk analyst)一个是从市场调查公司(
statistician)
1. What is left join. What's the difference between left join and right join.
2. Example: the original data set has the input like:
Company Location Profits
A BJ 15,000
SH 56,000
B GZ 34,555
HK 43,222
etc. You want to manipulate the data like:
Company Location Profits
A BJ 15,000
A SH 56,000
B GZ 34,555
B HK 43,222
How to achieve it in SAS.
3. Why do you use proc GLM instead of proc Anova to perform Anova analysis.
4. Why do you build linear mixed models instead of using linear models.
5. Did you do training set and validation set to test your models? What's
the result. (faint, I don't think neither my supervisor nor my boss has ever
told me to do things like that. Since my primary job is to test the differences)
6. How to interprete coefficient of variation?
| s*******r 发帖数: 769 | 2 thanks for sharing. But these questions seem easy though.
join.
【在 y******6 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 我也攒点人品:以下题目一个是从银行(risk analyst)一个是从市场调查公司( : statistician) : 1. What is left join. What's the difference between left join and right join. : 2. Example: the original data set has the input like: : Company Location Profits : A BJ 15,000 : SH 56,000 : B GZ 34,555 : HK 43,222 : etc. You want to manipulate the data like:
| C******y 发帖数: 2007 | | o**m 发帖数: 828 | 4 zan bless
join.
【在 y******6 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 我也攒点人品:以下题目一个是从银行(risk analyst)一个是从市场调查公司( : statistician) : 1. What is left join. What's the difference between left join and right join. : 2. Example: the original data set has the input like: : Company Location Profits : A BJ 15,000 : SH 56,000 : B GZ 34,555 : HK 43,222 : etc. You want to manipulate the data like:
| y******6 发帖数: 47 | 5 Well, I guess the questions are quite simple, indeed. But I failed to answer
number2 while I was interviewed. The banking questions are more related to
the projects I have been involved. But I didn't do a great job in the
presentation part or they need someone who's more experienced. | l**n 发帖数: 131 | | l*********s 发帖数: 5409 | 7 Don't worry. Failing these simple questions is embarrassing, however, they
resemble little practical importance. If you know how pigs work, how pigs
taste, I don't think it really matters if you know that pigs are all called
"swine".
answer
to
【在 y******6 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Well, I guess the questions are quite simple, indeed. But I failed to answer : number2 while I was interviewed. The banking questions are more related to : the projects I have been involved. But I didn't do a great job in the : presentation part or they need someone who's more experienced.
| k*******a 发帖数: 772 | 8 试一下,肯定有更好的办法
data a;
input company $ 1-2 city $ profit comma18.;
datalines;
A BJ 15,000
SH 56,000
B GZ 34,555
HK 43,222
;
data a(drop=lagcompany);
set a;
lagcompany=lag(company);
if company=' ' then company=lagcompany;
proc print data=a; run;
【在 l**n 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 谁来给解答一下第二个问题
| s******r 发帖数: 1524 | 9 you code only works for lag=2;
retain would work for 2+ missing line data.
【在 k*******a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 试一下,肯定有更好的办法 : data a; : input company $ 1-2 city $ profit comma18.; : datalines; : A BJ 15,000 : SH 56,000 : B GZ 34,555 : HK 43,222 : ; : data a(drop=lagcompany);
| k*******a 发帖数: 772 | 10 it worked for me with lag just now, but not sure why it is not working, so i
tried retain...
data a;
input company $ 1-2 city $ profit comma18.;
datalines;
A BJ 15,000
JJ 12,335
jr 12,345
BB 12,445
B GZ 34,555
HK 43,222
;
data a(drop=rcompany);
set a;
if company=' ' then company=rcompany;
rcompany=company;
retain rcompany;
proc print data=a; run;
【在 s******r 的大作中提到】![](/moin_static193/solenoid/img/up.png) : you code only works for lag=2; : retain would work for 2+ missing line data.
|
|