Multiple choice technology programming languages

In order to select a particular sheet- Ages in an excel for printing using proc print, select the correct option

  1. proc print data=inxls."Ages$"e;

  2. proc print data=inxls."Ages$"n;

  3. proc print data=inxls."Ages$"s;

  4. proc print data=inxls."Ages$";

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When accessing Excel sheets via SAS LIBNAME, the correct syntax uses the 'n' option for named ranges/sheets: data=inxls."Ages$"n. This tells SAS to treat 'Ages$' as a named range or sheet name within the Excel file. The 'n' option is specifically for naming convention handling.