4.28 sddscollect

• description: sddscollect reorganizes tabular data from the input file to bring data from several groups of similarly named columns together into a single column per group. In doing so it creates one page of output for every row on the input file and creates parameters to hold data from columns that are not included in any group.
• examples: Take a data set with several columns of PAR BPM x and y readings (one set per row) and create a new file with one column for x readings and one column for y readings, with each page containing one set of readings.
  sddscollect par.bpm par.orbits -collect=suffix=x -collect=suffix=y  
      

  The output file has three columns, x, y, and Rootname, the last containing the original column names without the suffix. Do statistics on PAR BPM x and y readbacks, then collect the statistics into columns, one column for each type of statistic:

  sddsprocess par.bpm -pipe=out -process=P?P?[xy],spread,%sSpread \  
    -process=P?P?[xy],ave,%sMean -process=P?P?[xy],stand,%sStDev | sddscollapse | \  
  sddscollect -pipe=in parbpm.stat \  
    -collect=suffix=xSpread -collect=suffix=xMean -collect=suffix=xStDev \  
    -collect=suffix=ySpread -collect=suffix=yMean -collect=suffix=yStDev  
      

  The output file has columns xSpread, ySpread, xMean, yMean, xStDev, and yStDev, plus Rootname containing the remainder of each original column name after the suffix is removed. All collections must produce matching sets of name remainders.

• synopsis:
  sddscollect [input] [output] [-pipe[=input][,output]] \  
    -collect={suffix|prefix|match}=match[,column=newName][,editCommand=<string>]  
      

• switches:
  • -pipe[=input][,output] — The standard SDDS Toolkit pipe option.
  • -collect={suffix|prefix|match}=match[,column=newName][,editCommand=<string>] — Specifies a string, match, to look for at the end (suffix mode), beginning (prefix mode), or anywhere (match mode) in column names. Data from all matching columns is transferred into a single column in the output file. For prefix and suffix modes, the default name of this column is the suffix or prefix string, while for match mode it is created by applying the edit command to the matching column names. This may be changed with the column qualifier. All collections must produce the same number of matches and the set of name remainders (i.e., the original column name less the prefix or suffix, or following editing) must be the same for each collection.
• files: Input and output are SDDS files. Each output page corresponds to one input row.
• see also:
  • sddsregroup()
  • sddstranspose()
  • ??
• author: M. Borland, ANL/APS.