Object Reference : Object View and Procedure Reference : Group
  
 
sheet
Spreadsheet view of a group object.
Syntax
group_name.sheet(options)
Options
 
w
Wide. In a panel this will switch to the unstacked form of the panel (dates along the side, cross-sections along the top).
t
Transpose.
a
All observations (ignore sample)
nl
Do not display labels.
tform=arg (default= “level”
Display transformed data: raw data (“level”), one period difference (“dif” or “d”), annual difference (“dify” or “dy”), one period percentage change (“pch” or “pc”), annualized one period percentage change (“pcha” or “pca”), annual percentage change (“pchy” or “pcy”), natural logarithm (“log”), one period difference of logged values (“dlog”).
c
Compare view. Display the compare view of the group.
p
Print the spreadsheet view.
Examples
g1.sheet(p)
displays and prints the spreadsheet view of the group G1.
g1.sheet(t, tform=log)
shows log values of the series in G1 using the current sample in a wide spreadsheet.
g1.sheet(nl, tform=diff)
displays differenced values of the series in the group using the current sample with no labels.
g1.sheet(a, tform=pc)
displays the one period percent changes for all observations in the workfile.
Cross-references
See “Basic Data Handling” for a discussion of the spreadsheet view of series and groups.