Copy and Paste from Excel to SAS

From sasCommunity
Jump to: navigation, search

Abstract

Most, if not all, of us are far too familiar with the problems that one can confront when trying to import an Excel workbook into a SAS® dataset. Numeric fields might be imported as character fields, dates might be imported as either character fields or dates that are sixty (60) years earlier than what they actually represent, and fields containing time values might be imported as representing one-half of a second when they actually represent 43,200 seconds. While such discrepancies can be corrected by following the use of PROC IMPORT with a carefully written datastep, the present paper presents an alternative that only requires one step, uses less code, only requires base SAS and, on our test data, ran almost fifty (50) times faster than using PROC IMPORT.

Online Materials

Click here to view the paper

Click here to download the SAS code described in this paper

Powerpoint Presentation

The presentation is shown in the box, below, but the behavior is different for different browsers. With Chrome, the pdf menu will appear if you move your pointer to the lower part of the box. Click on the menu's far left item, then you can PgDn through the presentation. Also, with Chrome's menu, one of the icons will let you save the file so that you can open it, directly, using the free Adobe Reader. With Explorer the menu appears if you move your pointer toward the upper part of the box, but is only needed if you want to save the pdf. With Firefox, clicking the >> symbol at the upper-righthand corner of the box lets you save the file.

When and Where

/**********************
Date: Tuesday, September 24, 2013 (MWSUG)
Time: 1:00pm-1:10pm
Where: House Room B
Section: Rapid Fire
**********************/

Contact Info

art297@rogers.com User:art297