Multiple choice technology programming languages

Choose the correct option for specifying the libname for an excel sheet

  1. libname 'example2.xls' outxls

  2. libname outxls excel 'example2.xls'

  3. libname outxls 'example2.xls'

  4. both 2 and 3

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

The correct syntax for assigning a libname to an Excel file in SAS is 'libname outxls excel 'example2.xls''. This specifies the libref (outxls), the engine (excel), and the physical file path. The Excel engine tells SAS to use the appropriate access method for Excel files.