BiX %XLSX2SAS Macro

  • Simple macro call with parameters to control the transformation process.
  • No DDE and No CSV files are involved. SAS/BASE only macro that can be run on any SAS Platform (Windows/Server UNIX/LINUX) on any SAS version from 9.1.3 and above
  • Selection of input XLSX file and Output SAS data set are the only required parameters.
  • Other optional parameters controls selection of a range of cells within the spreadsheet.
  • Up to 1,048,576 Excel rows and columns “A” through “ZZZ”.
%XLSX2SAS Macro syntax%XLSX2SAS Macro syntax

%XLSX2SAS Macro syntax


Top of Page
  • Macro call can be done from within SAS Enterprise Guide GUI.
%XLSX2SAS within SAS EG%XLSX2SAS within SAS EG

%XLSX2SAS within SAS EG


Top of Page
  • Macro call can be done from within SAS DI Studio GUI.
%XLSX2SAS within SAS DI%XLSX2SAS within SAS DI

%XLSX2SAS within SAS DI


Top of Page
  • The macro can be invoked using an interactive GUI.
  • GUI is available both on Windows and on Unix/Linux platforms.
%XLSX2SAS Interactive GUI - Supplying Mandatory Parameters%XLSX2SAS Interactive GUI - Supplying Mandatory Parameters

%XLSX2SAS Interactive GUI – Supplying Mandatory Parameters


Top of Page
  • Optional parameters can control which rows and columns are to be read into the SAS data set.
  • Column labels can be transformed into SAS variables labels.
  • Special parameter XLSXMIX handles scenarios where columns in Excel have mixed type of data.
%XLSX2SAS Interactive GUI - Supplying Optional Parameters%XLSX2SAS Interactive GUI - Supplying Optional Parameters

%XLSX2SAS Interactive GUI – Supplying Optional Parameters


Top of Page
  • Named profiles can save specific set of parameters.
  • The profiles can speed up the repetitive work of reading Excel files.
%XLSX2SAS Interactive GUI -Saving as Profile%XLSX2SAS Interactive GUI -Saving as Profile

%XLSX2SAS Interactive GUI -Saving as Profile


Top of Page