Converts text structures to variates.
|Controls printed output (
||How to treat non-numeric values (
||Text structures to convert|
||Variate for each text, containing the numbers in each of its lines|
||Format to use for dates and times (stored in numerical structures)|
||Strings used to represent missing values in each text; default ‘*’|
||Code to indicate whether the number in each unit was read successfully (1), or with conversions (2), or unsuccessfully (0)|
TX2VARIATE directive converts texts to variates. The texts are specified by the
TEXT parameter, and are assumed to contain a single number in each of their strings. The variates are specified by the
VARIATE parameter. The
MISSING parameter specifies a text for each text and variate, containing the string or strings that should be treated as missing values in the conversion; by default this is the string containing a single asterisk. Blank and null lines are always treated as missing.
By default, any non-numeric strings generate a missing value in the variate. However, you can set option
NONNUMERIC=bestmatch to ignore commas, and to allow for the common typing errors that the letters i or l may have been typed instead of i, or that the letters o or O may have been typed instead of 0. You can set option
PRINT=conversions to print a list of the values that have been converted. Also, the
STATUS parameter can save a variate with a code for each number to show whether it was read successfully with no conversions (1), or only with conversions (2), or whether it could not be read successfully (0).
TX2VARIATE takes account of restrictions on each
VARIATE. The values of the
VARIATE in the units excluded by the restriction are left unchanged.
" Example 1:4.5.3 " TEXT [VALUES=' 0.01',' -1','2.2','3.3E1',il,'-IO',O,'1,001',\ ' ','*','notnumber!','3.3D2','1.23E-4','-1.23E'] Textvals TX2VARIATE [PRINT=conversions; NONNUMERIC=bestmatch] Textvals;\ VARIATE=Realvals; Status=Status PRINT Textvals,Realvals,Status; DECIMALS=*,6,0 TEXT [VALUES='1/12/01','27/1/02','1/1/03','28/7/04','16/11/08',\ '4/7/14','11/5/15','21/10/16','12/3/17','3/4/17'] Tdate TX2VARIATE Tdate; VARIATE=Vdate; DREPRESENTATION=3 PRINT Tdate,Vdate,Vdate; DREPRESENTATION=0,0,3