![merge datasets in sas interview questions merge datasets in sas interview questions](https://blogs.sas.com/content/sastraining/files/2015/05/edited-2-Merging-SQL-vs.-Data-Step.jpg)
#Merge datasets in sas interview questions code#
What do you code to create a macro? End one?Ħ2. If you use a SYMPUT in a DATA step, when and where can you use the macro variable?Ħ1. How long can a macro variable be? A token?Ħ0. What is the difference between %LOCAL and %GLOBAL?ĥ9. For what purposes have you used SAS macros?ĥ8. How do you assign a macro variable to a SAS variable?ĥ7. Describe how you would create a macro variable.ĥ4. What system options would you use to help debug a macro?ĥ3. What is the purpose of using the N=PS option?ĥ2. How would you determine how far down on a page you have printed in order to print out footnotes?ĥ1. For what purpose(s) would you use the RETURN statement?ĥ0.
![merge datasets in sas interview questions merge datasets in sas interview questions](https://demo.vdocuments.mx/img/378x509/reader024/reader/2021010211/55cf9942550346d0339c7870/r-1.jpg)
![merge datasets in sas interview questions merge datasets in sas interview questions](https://cdn.cupdf.com/img/1200x630/reader016/image/20180731/54fd84204a7959d43c8b5451.png)
What would you use the trailing sign for?Ĥ9. What is the pound sign used for in the DATA _NULL_?Ĥ8. What is the purpose of the statement DATA _NULL_ ?Ĥ7. How would you use PROC CHART to look at the distribution? Describe the shape of the distribution.Ĥ6. How would you generate 1000 observations from a normal distribution with a mean of 50 and standard deviation of 20. Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLES”.Ĥ4. How do the IN= variables improve the capability of a MERGE?Ĥ3. Which data set is the controlling data set in the MERGE statement?Ĥ2. When would you choose to MERGE two data sets together and when would you SET two data sets?Ĥ1. What is a problem with merging two data sets that have variables with the same name but different data?Ĥ0. How would you combine 3 or more tables with different structures?ģ9. What happens in a one-on-one merge? When would you use one?ģ8. Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.ģ7. Code the MEANS to produce output to be used later.ģ6. Code the option that will allow MEANS to include missing numeric data to be included in the report.ģ5. Code a PROC MEANS that shows both summed and averaged output of the data.ģ4. Name the option to produce a frequency line items rather that a table.ģ2. Code the tables statement to produce a multi-level frequency.ģ1. Code the tables statement for a single-level (most common) frequency.ģ0. What are some differences between PROC SUMMARY and PROC MEANS?Ģ9. In PROC PRINT, can you print only variables that begin with the letter “A”?Ģ8. How would you keep SAS from overlaying the a SAS set with its sorted version?Ģ7. What SAS PROCs have you used and consider yourself proficient in using?Ģ6. If you were given several SAS data sets you were unfamiliar with, how would you find out the variable names and formats of each dataset?Ģ5. Have you ever used “Proc Merge”? (be prepared for surprising answers.)Ģ4. What is the difference between calculating the ‘mean’ using the mean function and PROC MEANS?Ģ3. In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_ x=1/3 if x=.3333 then put ‘fraction’ run Ģ2. How would you accomplish this in data step code? Using only PROC FORMAT.Ģ1. It needs to be displayed in the format “ddmonyy” if it’s before 1975, “dd mon ccyy” if it’s after 1985, and as ‘Disco Years’ if it’s between 19. What is the difference between: x=a+b+c+d and x=SUM(a,b,c,d) ?Ģ0. How would you determine the number of missing or nonmissing values in computations?ġ9. In ARRAY processing, what does the DIM function do?ġ8.
![merge datasets in sas interview questions merge datasets in sas interview questions](https://www.wisdomjobs.com/eunivdb/iquesimg/clinical-sas-interview-questions-answers.png)
#Merge datasets in sas interview questions mod#
How might you use MOD and INT on numerics to mimic SUBSTR on character strings?ġ7. Which date function advances a date, time or date/time value by a given interval?ġ6. What do the PUT and INPUT functions do?ġ4. What is the significance of the ‘OF’ in X=SUM(OF a1-a4, a6, a9) ?ġ3. When looking for contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?ġ2. What other SAS products have you used and consider yourself proficient in using?ġ1. Name several ways to achieve efficiency in your program. Which is worse: not testing your programs or not commenting your programs?Ĩ. Have you ever had to follow SOPs or programming guidelines?ħ. What percent of your program code is usually original and what percent copied and modified?Ħ. Do you observe any coding standards? What is your opinion of them?ĥ. What is your favorite operating system? Why?Ĥ. What is your favorite programming language and why?ģ. What has been your most common programming mistake?Ģ.