ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I access a SAS systems file and save it in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/14870-how-can-i-access-sas-systems-file-save-excel.html)

pmw101

How can I access a SAS systems file and save it in Excel
 
I have a SAS systems file (labelled and formatted data) I no longer have
access to SAS, but would still like to access and save the data using Excel.
Any hints?

Jerry W. Lewis

JMP and S-PLUS both will read SAS datasets. I don't think that R has
that functionality yet. I understand that SAS offers a data viewer, but
I don't know if you can copy and paste from it.

Jerry

pmw101 wrote:

I have a SAS systems file (labelled and formatted data) I no longer have
access to SAS, but would still like to access and save the data using Excel.
Any hints?



Jerry W. Lewis

Here is a link to download the SAS viewer
http://www.sas.com/apps/demosdownloa...ckageID=000176
Some threads in SAS newsgroups suggest that you may be able to
copy/paste from it.

Jerry

Jerry W. Lewis wrote:

JMP and S-PLUS both will read SAS datasets. I don't think that R has
that functionality yet. I understand that SAS offers a data viewer, but
I don't know if you can copy and paste from it.

Jerry

pmw101 wrote:

I have a SAS systems file (labelled and formatted data) I no longer
have access to SAS, but would still like to access and save the data
using Excel. Any hints?




All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com