The Power of PROC SQL (Tutotorials in SAS Programming) by Renu Gehring

Author:Renu Gehring [Gehring, Renu]
Language: eng
Format: epub
Published: 2014-03-31T00:00:00+00:00

Figure 9.1: Results of Example 9.1

The PUT function takes two arguments. One is the column to be converted. The other is the format of the results or the way the results should be displayed. CharDateofAdmit’s format allows discharges to be sorted for each patient.

The INPUT function is the flip side of the PUT function. It takes a character column and converts it to a numeric. It is most often used to convert character dates to numeric values so that arithmetic computations may be carried out. Example 9.2 converts CharDateofAdmit to a numeric date.

Example 9.2: Converting Character Data into Numeric

proc sql;

create table DataConversion2 as

select CharID, CharDateofAdmit,

input(CharID,7.) as ID,

input(CharDateofAdmit, yymmdd10.) as DateofAdmit format=date9.

from DataConversion1;

quit;

Figure 9.2: Results of Example 9.2

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.