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

where u.name in (select state from sql.newpop);

select Name format=$17., Capital format=$15.,

Population, Area, Continent format=$13., Statehood format=date9.

from sql.unitedstates;

/* use this code to generate output so you don't

overwrite the sql.unitedstates table */

options ls=84;

proc sql outobs=10;

title 'UnitedStates';

create table work.unitedstates as

select * from sql.unitedstates;

update work.unitedstates as u

set population=(select population from sql.newpop as n

where u.name=n.state)

where u.name in (select state from sql.newpop);

select Name format=$17., Capital format=$15.,

Population, Area, Continent format=$13., Statehood format=date9.

from work.unitedstates

;

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