SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

/* Create and populate NewCountries */

proc sql;

create table sql.newcountries like sql.countries;

insert into sql.newcountries

select * from sql.countries

where population ge 130000000;

quit;

proc sql;

title "World's Largest Countries";

alter table sql.newcountries

modify population format=comma15.;

select name, population from sql.newcountries;

/*-------------------------------------------------------------------

Output 4.11 Changing a Column's Width

-------------------------------------------------------------------*/

proc sql;

title "World's Largest Countries";

alter table sql.newcountries

modify name char(60) format=$60.;

update sql.newcountries

set name='The United Nations member country is '||name;

select name from sql.newcountries;

/*------------------------------------------------------------------- ...