Import and Output XML Files with SAS Yi Zhao

XML files are widely used in transporting data from different operating systems or data storages. Processing XML files efficiently becomes one of the necessary technical skills for SAS programmers. This paper presents four aspects in importing and exporting XML files with SAS. They include: (1). Using XML engine LIBNAME and data step to import or output data between XML and SAS datasets. (2). Using PROC COPY. (3). Developing XMLMap to facilitate the conversion; and (4). Importing XML file to Excel and converting it to SAS dataset. Sample program codes and tips are provided and discussed.