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
Revision as of 13:20, 14 February 2012 by Art297 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.

Note: Work in progress. When completed this page will include a link to the paper, all of the code presented in the paper, and the powerpoint.

Online Materials

View the pdf for HYPERTEXT.

You can also see the PowerPoint Presentation.

This could be a link to a zip file with sample data.

Also consider including some sample code:

the <source> tag provides SAS syntax highlighting and offsets it nicely

Contact Info User:art297