As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

Copy and Paste Almost Anything

From sasCommunity
Jump to: navigation, search


Every day, data appear on computer screens in various formats. The data might be in the form of Excel spreadsheets, wiki pages, html, pdf, Word documents or medium that is available to display data forms and tables. And, quite often, the files or pages include more than just the data of interest, as there might also be text, pictures, and additional data tables. But, with any of those formats, one can typically highlight and copy just the data they desire to their computer's clipboard. However, since there currently isn't a PROC IMPORT dbms=clipbrd option, how can one paste such data into a SAS® dataset? The present paper provides code that we believe can be used to accomplish most such tasks and, at the same time, provides examples of features that we think should be available in PROC IMPORT for all dbms options.

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

Wednesday, April 25, 2012
Asia 5

Contact Info User:art297