what are 5 ways to perform a table lookup in sas? : Sas-administrator



what are 5 ways to perform a table lookup in sas? : Sas-administrator..

Answer / Gaurav Bhardwaj

"1. Merge Procedure (MERGE): Used to combine two or more data sets by matching common variables.
2. BY Statement: Used within the procedure to sort and process the data set row by row based on a specific variable.
3. IF THEN ELSE Statement: Used to conditionally select rows from one data set based on values in another data set.
4. Macro: Used to create and execute SAS code dynamically based on conditions or user input.
5. Hash Objects: A powerful tool for table lookup that allows efficient processing of large datasets."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SAS Interview Questions

What does the RUN statement do?

1 Answers   Quintiles,


Under what circumstances would you code a SELECT construct instead of IF statements?

7 Answers   Accenture,


What are the ways in which macro variables can be created in sas programming?

1 Answers  


How would you code a macro statement to produce information on the SAS log? This statement can be coded anywhere.

8 Answers  


what is the primary variable in your study?

3 Answers   Accenture,


What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here

2 Answers  


Describe the function and untility of the most difficult SAS macro that you have written.

1 Answers  


What does P-value signify about the statistical data?

1 Answers  


IS SAS COMPILER OR INTERPRETER? EXPLAIN?

3 Answers   Aon Hewitt, HSBC, SCL, TCS,


Differentiate between ceil and floor functions.

1 Answers  


How would you generate 1000 observations from a normal distribution with a mean of 50 and standard deviation of 20. How would you use PROC CHART to look at the distribution? Describe the shape of the distribution.

1 Answers  


how many data types in sas? : Sas-administrator

1 Answers  


Categories