I have imported data from the Conference Board, the Total Economy Database, see
https://www.conference-board.org/data/economydatabase/index.cfm?id=27762
The data and my code to import the data can be found below. When importing, there is information about each series in the object called "Measure" which is available in the page "Untitled", see picture below. I would like to attach this information as description of each series in the page "tedl" using the command
Code: Select all
series.setattr(description) ..measure...
How can this be done?
Thomas
Code: Select all
wfopen(wf=tedimport) "..\TED\TED_2_NOV20171.XLSX" colhead=1 range="tcb_original"
'organisere workpagen
pagestack num? @ *? *
'lager en indicator variabel som EViews forstår
alpha indicator_=@replace(indicator," - ","_") 'retter opp "Labor Input - Quality"
alpha indicator_=@replace(indicator,"-","_") 'retter opp "Non-ICT Capital contribution"
alpha indicator_=@replace(indicator_," ","_") 'tar bort mellomrom
rename var01 year
pagestruct(bal=se) indicator_ iso @date(year)
alpha superid = "_" +indicator_+ "_" + iso
pageunstack(page=tedl) superid @date @ num
rename num_* * 'tar bort num_ fra navnet til alle seriene
rename *___* *_* 'tar bort dobbelt understrek
rename total_factor_productivity* tfp*