Search found 23 matches

by ral
Tue Feb 10, 2015 10:15 am
Forum: Data Manipulation
Topic: Exporting data to Excel
Replies: 13
Views: 5718

Re: Exporting data to Excel

Thank you. I was being thick about how to define the counter. One final issue: Now I get the following error after the program exports the group from the first country: File 'p:...\cli.xlsx' does not exist' in "wfsave(type=excel,mode=update) "p:...\cli.xlsx" range=KOR!A1 @smpl %start ...
by ral
Tue Feb 10, 2015 9:37 am
Forum: Data Manipulation
Topic: Exporting data to Excel
Replies: 13
Views: 5718

Re: Exporting data to Excel

It is possible that I misunderstood your suggestion. Based on your response, I changed the program in the following way: for %x {%countries} [...run regressions for each country that produce three series, cli_{%x}, delta_{%x}, and acc_{%x}...] ' Export data to Excel group clioutput_{%x} cli_{%x} del...
by ral
Tue Feb 10, 2015 8:43 am
Forum: Data Manipulation
Topic: Exporting data to Excel
Replies: 13
Views: 5718

Re: Exporting data to Excel

Thank you for the response. I have a further question. In the end, I would like to have separate worksheets for each country (e.g., Brazil, Korea, and so on) that contain the three series for the country computed by the program. Using "mode=update" does not seem to permit me to loop over t...
by ral
Mon Feb 09, 2015 5:04 pm
Forum: Data Manipulation
Topic: Exporting data to Excel
Replies: 13
Views: 5718

Exporting data to Excel

Hi, I have a question about how to export series to multiple Excel workbooks. My program loops over countries, runs some regressions, and produces three series for each country. I would like to export the three series for each country to a separate Excel workbook. (Separate spreadsheets would work a...
by ral
Wed Jan 14, 2015 4:43 pm
Forum: Data Manipulation
Topic: Importing data
Replies: 1
Views: 766

Importing data

I have two data sets that contain exactly the same variables. One is sampled at monthly frequency and the other at weekly frequency. I would like to import the data into the same Eviews workfile but into two different pages. I do not want to convert the weekly series into monthly series (or vice ver...
by ral
Thu Oct 23, 2014 9:26 am
Forum: Data Manipulation
Topic: Loading data
Replies: 1
Views: 762

Loading data

I have a simple problem that is driving me crazy. I am trying to load some data into an Eviews workfile. When I attempt to import the 49 data series, I obtain NAs rather than the data themselves. Here is the code: cd ...\mydirectory wfcreate(wf="persistwgtpi", page="monthly") m 1...
by ral
Tue Oct 21, 2014 5:39 pm
Forum: Programming
Topic: Dates
Replies: 3
Views: 1098

Dates

I have a program that I want to run on data sets with different start dates. At the beginning of the program, I have defined a several scalars used in the program that I modify depending on the data set. Can I do something similar for dates that define the sample period in the regressions I want to ...
by ral
Tue Oct 21, 2014 2:51 pm
Forum: Data Manipulation
Topic: Elementwise multiplication
Replies: 6
Views: 2316

Elementwise multiplication

I have a TxN matrix A that I want to multiply by a Tx1 vector b elementwise. That is, I want to multiply each of the N columns of length T by the vector b. This would work with the function @emult if the two matrices were of the same dimension (e.g., if A were Tx1 in my case). Is there a workaround ...

Go to advanced search