EViews.com

That worked perfectly! Thanks for your help!

I think that could be a good start. I'm trying to group them into buckets, though. I should have specified that, my bad. I need to sum them based on the number, creating 4 buckets: 0-2, 3-5, 6-10, 10+. Again, some of the categories won't have all of the numbers so whatever numbers they do have need ...

I’m trying to loop through variables in Eviews to create a sum variable depending on the name of other variables. My variable names follow this pattern: amuse0_area, amuse1_area, amuse2_area, auto0_area, auto1_area and so on. So there will be multiple categories and number combinations. Some categor...

Switching to CSV worked! Thanks!

I'm trying to import an excel file that I created using Python, but am having trouble getting Eviews to recognize it. I use an API in Python to connect to a website and automatically pull all the data I need and then export that data to the correct directory, but Eviews doesn't seem to be finding it...

October 18 2023

The error associated with the original post, sorry. This one:

Unable to allocate memory for working array in "wfsave(type=excelxml) {%output}\CHRVALUE.xlsx range="CHRVALUE!a1" @smpl {%begin_export} {%end_hist} @keep g_CHRVALUE"

I'm getting this error when I try to save my data into an excel file using Eviews 12. Here is the code that I'm using: %begin_export="2013:11" %end_hist="2023:11" wfsave(type=excelxml) {%outputdirectory}\CHRVALUE.xlsx range="CHRVALUE!a1" @smpl {%begin_export} {%end_hist...

Okay. So in your opinion, would using a for loop to just copy those variables over to the desired page be the best way to do it?

I am pulling data from Oracle tables using the Eviews/SQL code below, but would like a way to make the process a bit more user friendly. I run the program once a month, and need the end date to change each month to reflect a new month of data. Normally my team creates %date = "2023:11" at ...

I'm in the process of updating old programs to include a direct connection to Oracle and have come across a small problem. I'm using the following command structure to pull in the data I need, then unstack it into a format that makes sense: pageload(type=odbc, timeout = 900) FilePath\OracleConnectio...

Hi Steve, Thanks for this post! It has been super helpful in getting rid of the password request, however, I now have to "select data source" each time I make the connection to the database which is still not ideal. I am currently making the connection with the below code: pageload(type=od...

Is that something that is unique to the mixed chart graphic? I was able to shade one observation when I was only using the bar chart.

Attached are simplified versions of my programs/workfiles. I do notice that when I increase the range of my shading (from 1 year shaded to 2 years) it will include the shading, but it is offset from the beginning of the bar in the year that I would like the shading to begin. I would like the shading...

Interesting. That code does work for me but I don't understand how it differs from my own. Does it have something to do with the fact that you define the two variables as series? And if so, how would I do that if I am also running a loop like so: subroutine graphtest smpl {%begindate} {%enddate} for...