libname S 'C:\Users\student\Desktop\test';

*data step;
data S.zbior1;
    tekst = "dzien dobry";
    rok = 2019;
run;

*wiecej obserwacji;
data S.zbior2;
    tekst = "dzien bardzo z³y";
    rok = 2019;
    output;
    tekst = "trzeci rok";
    rok = 2020;
    output;
run;

data zbior3;
    tekst = "dzien dobry";
    rok = 2019;
run;

*proc step;
proc contents data = S.zbior2;
run;

proc print data = S.zbior2;
run;

*przetwarzanie danych;
data S.zbior4;
    set sashelp.class;
    bmi = weight / (height * height) * 703;
    rok = '01JAN2019'd;
run;

data S.zbior5;
    set sashelp.class;
    name2 = sex || name;
    label  name2 = "d³uga nazwa";
run;

data S.zbior6;
    set sashelp.cars;
    where make = "Audi";
run;

data S.zbior6;
    set sashelp.cars;
    where make = 'Audi' and type = 'Sedan';
run;

data S.zbior7;
    set sashelp.airline;
    where date <= '01JAN1959'd;
run;

data S.zbior8;
    set sashelp.cars;
    *keep name sex;
    keep m: ;
run;

data S.zbior9;
    set sashelp.cars;
    drop m: ;
run;

data S.chlopcy(keep = name age) S.dzwieczyny(drop = sex);
    set sashelp.class(keep = name age sex);
run;

data S.klasa;
    set sashelp.class(where = (sex = 'F'))
        sashelp.class(where = (sex = 'M'));
run;

data toyota(where = (upcase(make) = 'TOYOTA'))
    audi(where = (lowcase(make) = 'audi'));
    set sashelp.cars;
run;