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;
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?
Which SAS-version are you using?
SAS Version 7.12 HF4 (7.100.2.3458)
I also do have active SAS/ACCESS Interface to PC Files (it is on)
@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.
sorry, 9.04, that is?
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.