X-Git-Url: https://pintos-os.org/cgi-bin/gitweb.cgi?a=blobdiff_plain;f=doc%2Ftransformation.texi;h=27bbb2da8d039204be8c27f9b996f867b9ba6511;hb=2acfe799af1fd4504ee1278e0b8864ace451688a;hp=e722b9c4c8620b19b1e473ce09389eda5ef2983b;hpb=1339492699ce7e12c9bf9fa17f9d60a66024cbd1;p=pspp-builds.git diff --git a/doc/transformation.texi b/doc/transformation.texi index e722b9c4..27bbb2da 100644 --- a/doc/transformation.texi +++ b/doc/transformation.texi @@ -1,4 +1,4 @@ -@node Data Manipulation, Data Selection, Variable Attributes, Top +@node Data Manipulation @chapter Data transformations @cindex transformations @@ -17,13 +17,13 @@ as a rule. * SORT CASES:: Sort the active file. @end menu -@node AGGREGATE, AUTORECODE, Data Manipulation, Data Manipulation +@node AGGREGATE @section AGGREGATE @vindex AGGREGATE @display AGGREGATE - OUTFILE=@{*,'filename'@} + OUTFILE=@{*,'file-name',file_handle@} /PRESORTED /DOCUMENT /MISSING=COLUMNWISE @@ -37,9 +37,11 @@ variables called @dfn{break variables}. Several functions are available for summarizing case contents. The OUTFILE subcommand is required and must appear first. Specify a -system file by file name string or file handle (@pxref{FILE HANDLE}). +system file, portable file, or scratch file by file name or file +handle (@pxref{File Handles}). The aggregated cases are written to this file. If @samp{*} is -specified, then the aggregated cases replace the active file. +specified, then the aggregated cases replace the active file. Use of +OUTFILE to write a portable file or scratch file is a PSPP extension. By default, the active file will be sorted based on the break variables before aggregation takes place. If the active file is already sorted @@ -192,7 +194,7 @@ will cause the period to be interpreted as the end of the command.) @cmd{AGGREGATE} both ignores and cancels the current @cmd{SPLIT FILE} settings (@pxref{SPLIT FILE}). -@node AUTORECODE, COMPUTE, AGGREGATE, Data Manipulation +@node AUTORECODE @section AUTORECODE @vindex AUTORECODE @@ -222,7 +224,7 @@ PRINT is currently ignored. @cmd{AUTORECODE} is a procedure. It causes the data to be read. -@node COMPUTE, COUNT, AUTORECODE, Data Manipulation +@node COMPUTE @section COMPUTE @vindex COMPUTE @@ -262,7 +264,7 @@ When @cmd{COMPUTE} is specified following @cmd{TEMPORARY} (@pxref{TEMPORARY}), the @cmd{LAG} function may not be used (@pxref{LAG}). -@node COUNT, FLIP, COMPUTE, Data Manipulation +@node COUNT @section COUNT @vindex COUNT @@ -285,7 +287,7 @@ one or more @dfn{test} variables for each case. The target variable values are always nonnegative integers. They are never missing. The target variable is assigned an F8.2 output format. -@xref{Input/Output Formats}. Any variables, including long and short +@xref{Input and Output Formats}. Any variables, including long and short string variables, may be test variables. User-missing values of test variables are treated just like any other @@ -366,7 +368,7 @@ DESCRIPTIVES QVALID /STATISTICS=MEAN. @end example @end enumerate -@node FLIP, IF, COUNT, Data Manipulation +@node FLIP @section FLIP @vindex FLIP @@ -412,7 +414,7 @@ FLIP honors @cmd{N OF CASES} (@pxref{N OF CASES}). It ignores @cmd{TEMPORARY} (@pxref{TEMPORARY}), so that ``temporary'' transformations become permanent. -@node IF, RECODE, FLIP, Data Manipulation +@node IF @section IF @vindex IF @@ -450,7 +452,7 @@ When @cmd{IF} is specified following @cmd{TEMPORARY} (@pxref{TEMPORARY}), the @cmd{LAG} function may not be used (@pxref{LAG}). -@node RECODE, SORT CASES, IF, Data Manipulation +@node RECODE @section RECODE @vindex RECODE @@ -503,8 +505,8 @@ src_value matches any user- or system-missing value. SYSMIS matches the system missing value only. ELSE is a catch-all that matches anything. It should be the last src_value specified. -Numeric and string dest_value's should also be self-explanatory. COPY -causes the input values to be copied to the output. This is only value +Numeric and string dest_value's should be self-explanatory. COPY +causes the input values to be copied to the output. This is only valid if the source and target variables are of the same type. SYSMIS indicates the system-missing value. @@ -518,12 +520,12 @@ Multiple recodings can be specified on a single @cmd{RECODE} invocation. Introduce additional recodings with a slash (@samp{/}) to separate them from the previous recodings. -@node SORT CASES, , RECODE, Data Manipulation +@node SORT CASES @section SORT CASES @vindex SORT CASES @display -SORT CASES BY var_list. +SORT CASES BY var_list[(@{D|A@}] [ var_list[(@{D|A@}] ] ... @end display @cmd{SORT CASES} sorts the active file by the values of one or more @@ -532,8 +534,8 @@ variables. Specify BY and a list of variables to sort by. By default, variables are sorted in ascending order. To override sort order, specify (D) or (DOWN) after a list of variables to get descending order, or (A) or (UP) -for ascending order. These apply to the entire list of variables -preceding them. +for ascending order. These apply to all the listed variables +up until the preceding (A), (D), (UP) or (DOWN). The sort algorithms used by @cmd{SORT CASES} are stable. That is, records that have equal values of the sort variables will have the