/* Example of WHERE= option in SAS */

DATA mtns;
INFILE CARDS;
INPUT Peak :$16. Height_m Continent :$13. Country :$14. First_ascent;
cards;
Mount_Everest 8848 Asia Nepal/China 1953
Aconcagua 6961 South_America Argentina 1897
Denali 6194 North_America United_States 1913
Kilimanjaro 5895 Africa Tanzania 1889
Mount_Elbrus 5642 Europe Russia 1874
Mount_Vinson 4892 Antarctica Antarctica 1966
Puncak_Jaya 4884 Australasia Indonesia 1962
Mount_Kosciuszko 2228 Australia Australia 1840
K2 8611 Asia Pakistan/China 1954 
Kangchenjunga 8586 Asia Nepal/India 1955
Lhotse 8516 Asia Nepal/China 1956
Makalu 8485 Asia Nepal/China 1955
Cho_Oyu 8201 Asia Nepal/China 1954
Dhaulagiri_I 8167 Asia Nepal 1960
Manaslu 8163 Asia Nepal 1956
Nanga_Parbat 8126 Asia Pakistan 1953
Annapurna_I 8091 Asia Nepal 1950
Gasherbrum_I 8080 Asia Pakistan/China 1958
Broad_Peak 8051 Asia Pakistan/China 1957
Gasherbrum_II 8035 Asia Pakistan/China 1956
Shishapangma 8027 Asia China 1964
;
run;

DATA the8000ers (WHERE = (Height_m GE 8000))
nepalpeaks (WHERE = (Country CONTAINS ('Nepal')));
SET mtns;
run;

PROC PRINT data=the8000ers;
title 'The 8000-meter Peaks';
run;

PROC PRINT data=nepalpeaks;
title 'The Peaks of Nepal';
run;

DATA american;
SET mtns (WHERE = (Continent CONTAINS ('America')));
run;

PROC PRINT data=american;
title 'The Peaks in the Americas';
run;

PROC PRINT data=mtns;
title;
run;

PROC PRINT data = mtns (WHERE = (First_ascent < 1900));
title 'First climbed before 1900';
run;