Attributes question
Posted: Thu Jan 24, 2019 10:09 am
Good afternoon,
I'm exporting several a variety of data series from eviews to excel in several subsets to excel using the pagesave function. For each series the atributes structure and import procedure is identical, as is the syntax and structure in each subsets pagesave command, however some subsets are including the "display name" in attributes, and others are not (I would like to exclude "display name" in all exported attributes).
Do you have any insight into why certain subsets are exporting the 'display name' and others are not?
below are examples of the importattr command, and the pagesave commands I'm using.
I can post over full prg file and related excels files if that is helpful as well.
Thanks,
Bob
pricing subset (eventually exports 'display name' with attributes)
pageload(page=attr) c:\warem32\MMRData_NewNGB_ATTR.xlsx range="basis!B1:AI2" byrow colhead=0 names=(name, description)pageload(page=attr) c:\warem32\MMRData_NewNGB_ATTR.xlsx range="basis!B1:AI2" byrow colhead=0 names=(name, description)
pagesave(t=excel, mode=update, attr) c:\warem32\MMR.xlsx range="Table2_NAGasBasisMonthly!a6" @freq m 2005 2050 @keep pnhh prhh pnaeco pnaecocgj praeco praecocgj g_all deflatoryrus deflatoryrcan rxcan
gas volumes subset (does not export 'display name' with attributes)
pageload(page=attr) c:\warem32\MMRData_NewNGB_ATTR.xlsx range=ngb!B1:AP2 byrow colhead=0 names=(name, description)
pageselect ngbdata
importattr attr @keep description
pagesave(t=excel, mode=update, attr) c:\warem32\MMR.xlsx range="Table3_USBalancesMonthly!a6" @freq m 2005 2050 @keep dresus dcomus dindus dpowus dvehus dplpfus dinjus ddtius ddtus dnmxexus dlngexus dtius dtus sprodus slngsous scanimpus swdus stwus stus uaus invus
I'm exporting several a variety of data series from eviews to excel in several subsets to excel using the pagesave function. For each series the atributes structure and import procedure is identical, as is the syntax and structure in each subsets pagesave command, however some subsets are including the "display name" in attributes, and others are not (I would like to exclude "display name" in all exported attributes).
Do you have any insight into why certain subsets are exporting the 'display name' and others are not?
below are examples of the importattr command, and the pagesave commands I'm using.
I can post over full prg file and related excels files if that is helpful as well.
Thanks,
Bob
pricing subset (eventually exports 'display name' with attributes)
pageload(page=attr) c:\warem32\MMRData_NewNGB_ATTR.xlsx range="basis!B1:AI2" byrow colhead=0 names=(name, description)pageload(page=attr) c:\warem32\MMRData_NewNGB_ATTR.xlsx range="basis!B1:AI2" byrow colhead=0 names=(name, description)
pagesave(t=excel, mode=update, attr) c:\warem32\MMR.xlsx range="Table2_NAGasBasisMonthly!a6" @freq m 2005 2050 @keep pnhh prhh pnaeco pnaecocgj praeco praecocgj g_all deflatoryrus deflatoryrcan rxcan
gas volumes subset (does not export 'display name' with attributes)
pageload(page=attr) c:\warem32\MMRData_NewNGB_ATTR.xlsx range=ngb!B1:AP2 byrow colhead=0 names=(name, description)
pageselect ngbdata
importattr attr @keep description
pagesave(t=excel, mode=update, attr) c:\warem32\MMR.xlsx range="Table3_USBalancesMonthly!a6" @freq m 2005 2050 @keep dresus dcomus dindus dpowus dvehus dplpfus dinjus ddtius ddtus dnmxexus dlngexus dtius dtus sprodus slngsous scanimpus swdus stwus stus uaus invus