topic Re: Saving output tables to Excel by writing code in SAS Enterprise Guide

Saving output tables to Excel by writing code

Ivan555 — Tue, 21 May 2019 08:09:50 GMT

Hello!

In accordance with the exsample as a result I do have two tables.

The goal is to save them as *.xlsx files on path "C:\" by writing code. (without any manual use of build-in servises like Export button).

Is it possible in SAS?

Thx for consideration.

proc sql;
create table t1 (id int, typ int, dt char(8), qty int);
insert into t1 
values (1, 2, '20190325', 50)
 values (2, 2, '20190320', 15)
  values (3, 3, '20190401', 50);
  
create table t2 as (id int, typ int, dt char(8));
 values (4, 3, '20190405')
    values (5, 1, '20190406');

quit;

Re: Saving output tables to Excel by writing code

Ivan555 — Tue, 21 May 2019 08:29:34 GMT

have found LIBNAME function, i am writing like

LIBNAME xdb EXCEL 'C:\!lib\1.xlsx';

and i am getting errors

ERROR: The EXCEL engine cannob be found.

ERROR: Error in the LIBNAME statement.

I have to install the Excel engine.. or what?

Re: Saving output tables to Excel by writing code

andreas_lds — Tue, 21 May 2019 09:04:38 GMT

Which SAS-version are you using?

Re: Saving output tables to Excel by writing code

Ivan555 — Tue, 21 May 2019 09:39:35 GMT

SAS Version 7.12 HF4 (7.100.2.3458)

I also do have active SAS/ACCESS Interface to PC Files (it is on)

Re: Saving output tables to Excel by writing code

andreas_lds — Tue, 21 May 2019 10:29:31 GMT

@Ivan555 wrote:

SAS Version 7.12 HF4 (7.100.2.3458)

I also do have active SAS/ACCESS Interface to PC Files (it is on)

This looks like a version number of SAS Enterprise Guide, but i asked for the version of your sas-installation.

When you execute

%put &=SYSVLONG;

The version-number is printed to the log.

Re: Saving output tables to Excel by writing code

Ivan555 — Tue, 21 May 2019 12:11:08 GMT

sorry, 9.04, that is?