Creating and filtering a city table

This program starts by creating a SAS^© table named 'city' containing manually entered city/capital pairs. It then uses the PRINT procedure to list only cities whose capital is 'Delhi'.

Data Analysis

Type : CREATION_INTERNE

The data is provided directly in the source code via the CARDS statement.

1 Code Block

DATA STEP Data

Explanation :
Data step creating the 'city' table. Defines 'name' and 'capital' columns as character strings and reads inline data.

Copied!

1	DATA city;
2	INPUT name$ capital$;
3	CARDS;
4	Helsinki Finland
5	delhi Delhi
6	Mumbai Delhi
7	Nice Paris
8	;
9	RUN;

2 Code Block

PROC PRINT

Explanation :
Print procedure displaying the content of the 'city' table. The WHERE clause filters the results to show only rows where the capital is 'Delhi'.

Copied!

1	PROC PRINT DATA=city;
2	where capital='Delhi';
3	RUN;

This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.

Retour à la liste

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.