SURVO MM Help System (web edition)

FILE LOAD <Survo_data_file>,L
loads the active fields of the data file in the edit field from the line
L onwards. If L is omitted, the next edit line is used. IND and CASES
specifications are also available. To indicate the fields to be loaded,
a MASK specification may be used. If the name of the data file is
preceded by a '-', the header lines are not printed in front of the data
values.

Missing values are shown as '-'s. Any <string> may be used as a missing
value indicator in the output by giving specification MISSING=<string>.
This option applies to numeric fields only.
Example: MISSING=***

Unwanted characters are skipped by
SKIP=<list_of_characters>. Example: SKIP=,"

FILE LOAD <Survo_data_file> TO <text_file> 
moves the active fields of the data file to a text file.
Also the header lines telling the name of the data file and the names
of the fields will be moved.
If <Survo_data_file> is preceded by a '-', the header lines are
not moved. This is useful in situations where several parts of a data
file has to be copied in a single text file.
Each record will appear as a line terminated by a line feed character.

In both forms above, fields in the output will be separated by a
space character. To use another character instead of a space, give
DELIMITER=<character>. Then all fields, except the the last one, will
be terminated by <character>. To terminate the last field as well
with <character>, give DELIMITER=<character>,1 .
DELIMITER=TAB is the same as DELIMITER=char(9).
If DELIMITER is used, both leading and trailing space characters
in each field are replaced by a character given by
SPACE=<space_character>. Those characters can be erased thereafter by TXTCONV.

The spaces and commas in string variables may be replaced by other
characters by using specifications STR_SPACE and STR_COMMA, respectively.
For example, STR_SPACE=_ STR_COMMA=; makes the output suitable for
plotting it as texts and labels (in GPLOT and PLOT).

By default names of fields are truncated according to the current format.
By NAMES8=1 field names are copied to the normal length of 8 characters.
NAMES8=2 works like NAMES8=1 but replaces the name of the first variable
by blanks. This a useful option in making data tables for R, for example.     C

The default format of the output is a data matrix (table). Other formats
may be selected by a FORMAT specification. It has 3 different forms:
1.  FORMAT=ORDER:<field_1>,<field_2>,...
    reorders the fields for output.
2.  FORMAT=LIST
    gives the output in the form of a data list.

3.  FORMAT=<name_of_format> 
    specifies that a special (multiline) format given in the current
    edit field is to be used. This format has to be given in the form:

    FORMAT <name_of_format> 
         one or several lines containing free text and field
         descriptions of form    name_of_field: ###.##
         or [name_of_field]
    END

    If ###.## is missing, the default format for the field is used.
    In the latter case (name in brackets []) the default format is
    always used and the value overwrites the name of the field.

Example: (Results of FILE LOAD on line 41 appear from line 48 onwards.)

 41 *FILE LOAD FINLAND,48 / FORMAT=PLAN1
 42 *FORMAT PLAN1
 43 *[Commune]                    [Province]
 44 +[Popul]          [Births]
 45 *--------------------------------------
 46 *END
 47 *
 48 *Helsinki                     UUS
 49 +483057           5851
 50 *--------------------------------------
 51 *Tampere                      HÄM
 52 +165453           2084
 53 *--------------------------------------
 54 *Turku                        TUR
 55 +164081           2330
 56 *--------------------------------------
     etc.


Fields in format lines (lines 43-45 in the preceding example) can have
various display attributes (shadow characters) and these attributes
will be copied to each result line correspondingly. In this case,
make sure that there is room enough for new shadow lines by using
the REDIM command. Also control characters of format lines are copied.
These features are valid only when data is loaded into the edit field.

In the output of FILE LOAD, a code conversion is carried out by
a specification FILTER=<conversion_file> where the 256 first bytes
of the conversion file defines a characterwise mapping. This file
is generated by using a CODES SAVE command (See CODES?).

In this conversion, certain characters (usually blanks) are skipped
(left out) by mapping them to decimal value 0.

  D = More information on data management 


More information on Survo from www.survo.fi
Copyright © Survo Systems 2001-2012.
webmaster'at'survo.fi