The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
WORK.EMPLOYEE
fname age
Bruce 30
Dan 40
WORK.SALARY
fname salary
Bruce 25000
Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
merge work.employee work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?
A. 3
B. 4
C. 5
D. No variables are output to the data set as the program fails to execute due to errors.
Disclaimer
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.
Other brand and product names are trademarks of their respective companies.
This blog is not responsible for any kind of copyright violation. This blog just collects the links hosted or posted by other servers/people/search engines.The creator of this page or the ISP(s) hosting any content on this site take no responsibility for the way you use the information provided on this site.If anybody has any copyright claim on it and doesn’t wish the information provided to be shown on our site, please do respond to this email. We shall remove them off immediately. Any inconvenience is regretted. Please do mention your exact grievance/problems with respect to certain third party links. We assure you that appropriate action will be taken off. Thank you
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.
Other brand and product names are trademarks of their respective companies.
This blog is not responsible for any kind of copyright violation. This blog just collects the links hosted or posted by other servers/people/search engines.The creator of this page or the ISP(s) hosting any content on this site take no responsibility for the way you use the information provided on this site.If anybody has any copyright claim on it and doesn’t wish the information provided to be shown on our site, please do respond to this email. We shall remove them off immediately. Any inconvenience is regretted. Please do mention your exact grievance/problems with respect to certain third party links. We assure you that appropriate action will be taken off. Thank you
11 comments:
Answer: B
Name age salary totsal
Bruce 30 25000 25000
Bruce 30 35000 60000
Dan 40 25000 85000
its A
Answer A
The answer is A
Correct answer is B (4 observations).
Data Employee;
Input name $ age;
Datalines;
Bruce 30
Dan 40
;
Data SALARY;
infile datalines truncover;
Input name $ salary ;
Datalines;
Bruce 40000
Bruce 35000
Dan 37000
Dan
;
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
proc print data = empsalary;
run;
4 variables
SAS GURU IS right....answer is 4
GURU Of SAS GURU....
The answer is 4. The confusion is arising because the question is asking how many VARIABLES are in the output dataset, not how many OBSERVATIONS.
it is asking for variables and not observations
so answer is B 4 variables
FNAME, AGE, SALARY AND TOTSAL(NEW VARIABLE CREATED) = 4 VARIABLES.
For latest and updated SAS certification dumps in PDF format contact us at completeexamcollection@gmail.com.
Refer our blog for more details
http://completeexamcollection.blogspot.in/2015/12/sas-certification-dumps.html
Post a Comment