Answer Posted / dvsr
Without index if we executed the query it will go to the
full table scan. If any data set or table has the index
first query checks that particular If condition or where
condition in that column then it will go to the remaining
columns.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Given an unsorted data set, how to read the last observation to a new data set?
Explain data step in SAS
Mention what are the data types does SAS contain?
how do you want missing values handled? : Sas programming
What are the limitations for memory allocation for SAS variables
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
Describe the function and untility of the most difficult SAS macro that you have written.
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
How to limit decimal places for the variable using proc means?
what is the difference between floor and ceil functions in sas? : Sas-administrator
What is the basic syntax of a sas program?
Why double trailing @@ is used in input statement?
What is the order of application for output data set options, input data set options and SAS statements?
how to generate the test data in sas without input data? : Sas-administrator
what is the difference between infile and input? : Sas-administrator