libname thor 's:\courses\stat-renaes\stat426\data1';

* look in library without seeing all dataset detailed information;
proc contents data=thor._all_ nods;
run;

* look in library at one dataset with detailed information;
proc contents data=thor.sales;
run;

* make a new dataset with sales. Call new one sales2;
data thor.sales2;
  set thor.sales;
  KEEP salary country;
  format salary dollar12.;
run;
* KEEP can allow you to keep only specified variables in new dataset;
* the FORMAT statement is using dollar<w>.<d> but here d=0 since the salaries have no decimal fraction;

* look at the data;
proc print data=thor.sales2;
run;

* means;
proc means data=thor.sales2;
   var Salary;
run;

* frequency table with one variable that has 2 levels (US, AU);
proc freq data=thor.sales2;
   tables Country;
run;