Example 9.3 Determining Whether a Variable Is Character or Numeric
Determine whether a variable is character or numeric to ensure that you have the right type of data for your application.
|Featured Step||DATA step|
|Featured Step Options and Statements||ATTRN, CLOSE, INDEX, OPEN, UPCASE, VARNAME, and VARTYPE functions CALL SYMPUTX routine Open code macro variables|
|Related Technique||PROC SQL, DICTIONARY.COLUMNS table, INTO clause to create a macro variable, INDEX and UPCASE functions|
|A Closer Look||Using the SAS File I/O Functions Specifying Variable Lists|
Input Data Set
Data set ENTRANCE_EXAM stores exam results for 15 applicants to an academic program. The results are saved in a mix of character and numeric variables.