SiteMap
Page Bottom  Documentation

Changing the Shape of Data

The following are what one might want to do in changing the shape or nature of an input array.

Create Create which is a two dimensional matrix
Append Append row(s) to bottom of
Delete Delete row(s) from
Insert Insert a row in
Extend Extend to make it wider
DeleteColDelete a column from
InsertColInsert a column in
ElimredACCompress to unique values of first column(s) (account)
Pullout Reduce to rows selected by values in first column(s)
Sort Sort by rows
Destroy Make have zero rows & one column
Change Change values in addressed by rows & columns

I have a variable called FM for each input array telling what it's shape should be if it is constant. The first 8 elements are shown in the table below and they have the meaning shown here. Input arrays are always either a vector or a two dimensional matrix.

  1. ŒNC (2=variable)
  2. QUADDR (4=8 bit char;2=16 bit integer;3=16 bit floating point)
  3. rank (½½)
  4. 1st dimension (sufficient for vector)
  5. 2cd dimension (needed for matrix)
  6. 3rd dimension (if needed for 3D matrix)(probably never used)
  7. 4th dimension (if needed for 4D matrix) (probably never used)
  8. special instruction (cINP) (need to research this)

The following are all the inputs for ProCash and the value of FM for each.

AVI 2 3 1 200 0 0 0 0
ALTI 2 2 2 0 0 0 0 0
TTL 2 4 1 0 0 0 0 0
FL 2 2 2 3 0 0 0 0
CM 2 3 2 0 5 0 0 0
OM 2 3 2 28 5 0 0 0
QTR 2 2 2 0 0 0 0 0
DEP 2 2 2 0 0 0 0 0
ENT 2 2 2 0 0 0 0 0
CSF 2 2 2 0 0 0 0 0
A87SCH 2 2 2 0 0 0 0 0
HLDBK 2 2 2 0 0 0 0 0
MV 2 2 1 0 0 0 0 ¯2
RU 2 3 2 2 0 0 0 0
CAPREP 2 2 2 2 0 0 0 0
MTGES 2 2 2 0 0 0 0 0
TAXCR 2 2 2 0 0 0 0 0
AVAR 2 2 2 0 0 0 0 0
KICKERS 2 2 2 0 0 0 0 0
TODATE 2 2 1 6 0 0 0 0
UNITMIX 2 2 2 0 4 0 0 0
NOTEFIN 2 2 2 0 0 0 0 0
FINFEES 2 2 2 0 0 0 0 0
TTLS 2 4 2 0 0 0 0 0
CSFLIMIT 2 2 2 0 0 0 0 0
PFDRET 2 2 2 0 0 0 0 0
RESVLUS 2 2 1 0 0 0 0 0
pRINST 2 2 1 14 0 0 0 0
INFRATES 2 2 2 1 1 0 0 0

horizontal line
to home page e-mail Page Top