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 |
What does the RUN statement do?
Under what circumstances would you code a SELECT construct instead of IF statements?
What are the ways in which macro variables can be created in sas programming?
How would you code a macro statement to produce information on the SAS log? This statement can be coded anywhere.
what is the primary variable in your study?
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
Describe the function and untility of the most difficult SAS macro that you have written.
What does P-value signify about the statistical data?
IS SAS COMPILER OR INTERPRETER? EXPLAIN?
3 Answers Aon Hewitt, HSBC, SCL, TCS,
Differentiate between ceil and floor functions.
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.
how many data types in sas? : Sas-administrator