Selecting Variables (1)

Creating Enhanced List and Summary Reports

Selecting Variables

Now let's see how you can choose the data that you want to display.

To select and order the variables that appear in your list report, you can use the COLUMN statement.

General form, COLUMN statement:
COLUMN variable(s);

where variable(s) is one or more variable names, separated by blanks.

Example

The following COLUMN statement specifies that only the variables Flight, Orig, Dest, Mail, Freight, and Revenue be printed, in that order.

proc report data=flights.europe nowd; column flight orig dest mail freight revenue; run;

Flight	Orig	Dest	Mail	Freight	Revenue
821	LGA	LON	403	209	150634
271	LGA	PAR	492	308	156804
271	LGA	PAR	366	498	190098
821	LGA	LON	345	243	150634
821	LGA	LON	248	307	193930
271	LGA	PAR	353	205	166470
821	LGA	LON	391	395	167772
271	LGA	PAR	366	279	163248
821	LGA	LON	219	368	183106
271	LGA	PAR	357	282	170766
821	LGA	LON	389	479	169576
271	LGA	PAR	415	463	195468
622	LGA	FRA	296	414	187636
821	LGA	LON	448	282	143561
271	LGA	PAR	352	351	123456
219	LGA	LON	331	376	189065
387	LGA	CPH	395	217	196540
622	LGA	FRA	296	232	165456
821	LGA	LON	403	209	170766
271	LGA	PAR	492	308	125632
219	LGA	LON	485	267	197456
387	LGA	CPH	393	304	134561
622	LGA	FRA	340	311	125436
271	LGA	PAR	366	498	128972
219	LGA	LON	388	298	162343
821	LGA	LON	345	243	129560
219	LGA	LON	421	356	134520
387	LGA	CPH	546	204	135632
622	LGA	FRA	391	423	107865
821	LGA	LON	248	307	196736
271	LGA	PAR	353	205	153423
219	LGA	LON	447	299	106753
387	LGA	CPH	415	367	128564
622	LGA	FRA	346	.	178543
821	LGA	LON	391	395	125344
271	LGA	PAR	366	279	133345
219	LGA	LON	356	547	122766
387	LGA	CPH	363	297	134523
622	LGA	FRA	317	421	100987
821	LGA	LON	219	368	166543
271	LGA	PAR	357	282	126543
219	LGA	LON	272	370	198744
387	LGA	CPH	336	377	109885
622	LGA	FRA	272	363	134459
821	LGA	LON	389	479	129745
271	LGA	PAR	415	463	134976