topic Re: Copying a SAS table to Excel in SAS Programming

Copying a SAS table to Excel

lg2 — Tue, 05 Jun 2018 22:00:05 GMT

/* Create dim table report for google sheet */
proc sql;
create table DXCLASS as
select
* put(..xyz)
from
xyz
where
DIAGNOSIS_ID
;
quit;

I have created a dimension table and i have got the results in a table .I want to copy the table to an excel.How to copy my results of the table from sas to an excel,

Edit: via @Reeza - to modify the subject line to be more descriptive.

Re: coying a table

Reeza — Tue, 05 Jun 2018 21:59:22 GMT

The term for this is exporting data.

You can use PROC EXPORT or a LIBNAME statement. This was asked recently here:

https://communities.sas.com/t5/Base-SAS-Programming/How-to-Export-sas7bdat-file-into-excel/m-p/467713

@lg2 wrote:

/* Create dim table report for google sheet */
proc sql;
create table DXCLASS as
select
* put(..xyz)
from
xyz
where
DIAGNOSIS_ID
;
quit;

I have created a dimension table and i have got the results in a table .I want to copy the table to an excel.How to copy my results of the table from sas to an excel,

Re: Copying a SAS table to Excel

SuryaKiran — Tue, 05 Jun 2018 23:36:52 GMT

Additionally, In case if your are using SAS Enterprise Guide then you can send your data to excel without any coding required.

Re: Copying a SAS table to Excel

Reeza — Wed, 06 Jun 2018 00:05:37 GMT

@SuryaKiran EG, SAS Studio, and Base all have that option, but it’s not saved in your code or as a step in your process so I usually never recommend it, or use it. Having the file path to knowing where the output is and no manual steps is the easiest solution.

Re: Copying a SAS table to Excel

error_prone — Wed, 06 Jun 2018 08:57:27 GMT

In recent version of Enterprise Guide, you can change the default output-format of a program to Excel an use any outputting procedure to create an excel-file (that has to be saved manually). If you need the export always, using proc export or ods excel is recommended.