How to import an excel file into SAS

jflo36 — Thu, 15 Oct 2015 19:18:52 GMT

how can I import an excel file into sas? I am new to SAS.

Re: How to import an excel file into SAS

LinusH — Thu, 15 Oct 2015 19:39:44 GMT

Search for "import excel" at support.sas.com.

Re: How to import an excel file into SAS

MikeZdeb — Sat, 17 Oct 2015 02:01:28 GMT

Hi. Another approach is to treat the XLS file as a data set. Use a LIBNAME statement and use the SHEET name within the XLS file as shiown in the data step ...

libname x 'z:\test.xls';

data gas_el (keep=dt days eld delc gpd dgas);
set x.'sheet1$'n;
eld = kwh/days; delc = elec/days;
gpd = therms/days; dgas = gas/days;
label
eld = 'KWHS/DAY'
gpd = 'THERMS/DAY'
delc = 'ELEC $/DAY'
dgas = 'GAS $/DAY'
dt = 'DATE'
days = 'DAYS USE'
;
format dt monyy. gas elec delc dgas dollar7.2 eld gpd 5.1;
run;

libname x clear;

data set GAS_EL ...
DAYS ELEC THERMS/ GAS
Obs DATE USE KWHS/DAY $/DAY DAY $/DAY

   1    DEC14     34       13.6        $2.45       8.1       $4.95
2    NOV14     29       11.2        $1.77       5.6       $3.65
3    OCT14     32       12.6        $2.16       2.2       $2.04
4    SEP14     30       13.1        $2.30       0.9       $1.29
5    AUG14     28       15.4        $2.67       0.6       $1.21
6    JUL14     33       14.8        $2.53       0.5       $1.08
7    JUN14     27       15.0        $2.58       0.7       $1.45
8    MAY14     32       13.3        $2.49       1.5       $2.19
9    APR14     32       11.9        $1.76       4.4       $4.45
10    MAR14     29       11.0        $3.11       9.9       $9.71
11    FEB14     29       11.4        $2.67      10.3       $7.57
12    JAN14     29       12.6        $2.87      11.9       $7.81

topic Re: How to import an excel file into SAS in SAS Programming

How to import an excel file into SAS

Re: How to import an excel file into SAS

Re: How to import an excel file into SAS