Question-: If you are sorting the data by multiple variables and put the DESCENDING keyword just before that first variable, what it does?
Answer: In this case data would be sorted in descending order by the first variable only, if you want to sort in the descending order for more than one variable then put the DESCENDING keyword in front of that each variable.
Question-: What is the problem if you don’t use the OUT= option in PROC sort?
Answer: In this case your existing data would be overwritten by newly sorted data.
Question-: What is the use of PAGEBY statement?
Answer: If you use the PAGEBY option for any variable then it would create a new page in the output. Also, please note that whatever variable you have specified in the PAGEBY statement must also specified in the BY statement.
Question-: How many footnote and title we can assign?
Answer: You can specify at the max 10 of each, and also please note that both FOOTNOTE and TITLE are global statements. You can place them anywhere withing or before the PRINT procedure. And they apply to all subsequent output. FOOTNOTE is equal to FOOTNOTE1 and similarly TITLE is equivalent to TITLE1.