* Continents1 Example
  Perform various database operations
  using SQL statements;

options ls=64 nodate pageno=1;

data popul1;
   infile "c:/datasets/popul.txt" firstobs=3;
   input continent $ 1-15 total_pop 17-26;

proc sql;

   title "Display dataset popul1";
   select continent, total_pop format COMMA14.
      from popul1;

   title "Copy dataset";
   create table popul2 as
      select * from popul1;

   title "Display dataset popul2";
   select continent, total_pop format COMMA14.
      from popul2;

   title "Drop column total_pop from table";
   alter table popul2 drop total_pop;
   title "Display dataset popul2";
   select * from popul2;

   title "Rename column continent to cont";
   alter table popul2 add cont char(15);
   update popul2 set cont=continent;
   alter table popul2 drop continent;
   select * from popul2;

   title "Drop popul2 dataset";
   drop table popul2;
   select * from popul2;

quit;