Object Reference : Object View and Procedure Reference : Series
  
 
sheet
Spreadsheet view of a series object.
Syntax
series_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= “default”
Display transformed data: value mapped or date formated (when applicable) or raw data, otherwise (“default”), 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”).
p
Print the spreadsheet view.
Examples
ser1.sheet(p)
displays and prints the default spreadsheet view of series SER1.
ser1.sheet(t, tform=log)
displays log values of SER1 in the current sample in a wide spreadsheet.
ser1.sheet(nl, tform=diff)
shows differenced values of the series without labels.
ser1.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.