PROC IMPORT OUT= ZADANIE2.KURSYdoEURO
            DATAFILE= "H:\SAS\Pliki\Kursy_walut_2016.xls"
            DBMS=EXCEL REPLACE;
     RANGE="Kursy średnie$A1:I254";
     GETNAMES=YES;
     MIXED=NO;
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;


proc import datafile="H:\SAS\pliki\dl.txt"
out=zadanie2.lotek
dbms=dlm replace;
delimiter=' ';
getnames=yes;
DATAROW=2;
run;

proc export data=zadanie2.BMI
outtable="BMI"
dbms = access replace;
database="H:\SAS\pliki\BMI.mdb";
run;

proc export data=zadanie2.BMI
file="H:\SAS\pliki\PRACOWNICY.xls"
dbms=xls replace;
sheet="BMI";
run;

data zadanie2.ziemniaki;
set zadanie2.ziemniaki;
rename var1=Data var2=Cena;
run;

proc import datafile="H:\SAS\pliki\ziemniakiMiesiac.csv"
out =zadanie2.ziem3
dbms=csv
replace;
delimiter=';';
getnames=no;
run;