topic Re: SAS Studio Copy Dataset to Clipboard in SAS Studio

SAS Studio Copy Dataset to Clipboard

tedway — Wed, 17 Jul 2019 12:27:16 GMT

How do I copy a dataset to my clipboard in SAS Studio? There are situations when I want to copy a whole dataset or just specific rows to my clipboard so that I can paste in another application. I know I can always export it to Excel or whatever, but just being able to copy directly to the clipboard is really handy. Selecting the rows and hitting Ctrl+C doesn't work.

Re: SAS Studio Copy Dataset to Clipboard

ballardw — Wed, 17 Jul 2019 15:20:51 GMT

The contents of SAS data sets are in a pretty proprietary format and almost nothing would be able to use "pasted" data at data set or row level.

If you don't want to "export" then you could run Proc Print for the desired rows (observations numbers using the OBS= and FirstObs= data set options) and copy from the result window.

Or describe what you want to do with that pasted data. We often see people taking data from SAS to perform actions that can be done directly in SAS.

Re: SAS Studio Copy Dataset to Clipboard

Reeza — Wed, 17 Jul 2019 15:24:40 GMT

Not a way afaik, but there's the macro in the library about creating sample data and if you use that you can have it pasted to the log so you can copy/paste it.

Or similarily, run PROC PRINT and copy from there.

There used to be a feature in Base where you right click a data set and it opened in Excel or HTML, that was handy.