Question-: How do you cancel the previously assigned FOOTNOTE and TITLE statement?
Answer: As we discussed previously all the FOOTNOTE and TITLE statements are global, if you want to cancel those before your next step, you have declared null FOOTNOTE and TITLE statement. By specify no values to title and footnote.
Question-: In the output report you want to change the header of the column which is different than variable name, how can you achieve that?
Answer: You can use LABEL statement for that.
Question-: If you want to have label assigned permanently for a variable then how can you achieve that?
Answer: If you assign label in the DATA step itself then it would save the label with the data and in future whenever you use the PROC PRINT statement, it would use that label in the output. However, in case of PRINT PROC you still have to use label option to get displayed the label but with the other procedure this is not the requirement.
Question-: When you use the SUM statement then it is mandatory to provide the var statement?
Answer: No, its not mandatory. It is optional. You do not need to name the variables in a VAR statement if you specify them in the SUM statement, but you can. If you choose not to name the variables in the VAR statement as well, then the SUM statement determines their order in the output.