INPUTN Function
Enables you to specify a numeric informat at run time.
| Categories: | Special |
| CAS | |
| Note: | This function supports the VARCHAR type. |
Syntax
Required Arguments
source
specifies a character constant, variable, or expression to which you want to apply the informat.
informat
is a character constant, variable, or expression that contains the numeric informat that you want to apply to source.
Optional Arguments
w
is a numeric constant, variable, or expression that specifies a width to apply to the informat.
| Interaction | If you specify a width here, it overrides any width specification in the informat. |
d
is a numeric constant, variable, or expression that specifies the number of decimal places to use.
| Interaction | If you specify a number here, it overrides any decimal-place specification in the informat. |
Details
Example: Specifying Numeric Informats
proc format;
value readdate 1='date7.'
2='mmddyy8.';
run;
options yearcutoff=1926;
data fixdates(drop=start dateinformat);
length jobdesc $12;
input source id lname $ jobdesc $ start $;
dateinformat=put(source, readdate.);
newdate=inputn(start, dateinformat);
datalines;
1 1604 Ziminski writer 09aug99
1 2010 Clavell editor 26jan95
2 1833 Rivera writer 10/25/98
2 2222 Barnes proofreader 3/26/12
;