SAS Certification Prep Guide, 4th Edition

Manipulating Data

Selected Useful Statements

Here are examples of statements that accomplish specific data-manipulation tasks.

Table 12.1 Manipulating Data Using the DATA Step

Task	Example Code
Subset data	if resthr<70 then delete; if tolerance='D';
Drop unwanted variables	drop timemin timesec;
Create or modify a variable	TotalTime=(timemin*60)+timesec;
Initialize and retain a variable Accumulate values	retain SumSec 5400; sumsec+totaltime;
Specify a variable's length	length TestLength $ 6;
Execute statements conditionally	if totaltime>800 then TestLength='Long'; else if 750<=totaltime<=800 then TestLength='Normal'; else if totaltime<750 then TestLength='Short';
Label a variableFormat ...