Search found 44 matches

by BT454
Fri Apr 26, 2019 11:46 am
Forum: Programming
Topic: evaluating if an attribute exists using @isobject
Replies: 3
Views: 238

Re: evaluating if an attribute exists using @isobject

Thanks! I'm receiving an error message saying the named attribute (in this case UNIT) is not defined. Here is the exact code, and I've attached the workfile. I'm wondering if it's a case sensitive issue (i.e. I have the attribute defined as "Unit" in the code and the workfile, but it appea...
by BT454
Fri Apr 26, 2019 11:15 am
Forum: Programming
Topic: evaluating if an attribute exists using @isobject
Replies: 3
Views: 238

evaluating if an attribute exists using @isobject

Hi! I'm wondering if it's possible to check if a specific attribute exists for a group of data series using the @isobject function. Thinking something like the code below, but my job is crashing saying that "some_attribute" is not defined. I'm sure my syntax is off. Any help is appreciated...
by BT454
Thu Apr 18, 2019 12:12 pm
Forum: Programming
Topic: edit/override of identity
Replies: 2
Views: 368

Re: edit/override of identity

Hi!
Not yet. I haven't had a chance to get back to it, but when I do I'll post any solution I can come up with.
Thanks for checking in.
Bob
by BT454
Thu Apr 18, 2019 10:59 am
Forum: Programming
Topic: pagesave crash
Replies: 1
Views: 241

pagesave crash

This code keeps crashing on the first loop, telling me that the table referenced in the range option does not exist. I'm sure I'm missing something simple here. for %x res com pow veh ind plpf pagesave(t=excel) C:\warem32\demand_export.xlsx range=%x @keep state us pl nag @freq m @smpl 2001 %endhist ...
by BT454
Fri Apr 05, 2019 11:27 am
Forum: Programming
Topic: removing spaces from string created using @winterleave
Replies: 1
Views: 178

Re: removing spaces from string created using @winterleave

I managed to figure this out by creating the string custids before the loop, and adding the values of each component string to it during the loop, with a space after the second component.
Thanks!
by BT454
Fri Apr 05, 2019 11:06 am
Forum: Programming
Topic: removing spaces from string created using @winterleave
Replies: 1
Views: 178

removing spaces from string created using @winterleave

Hi! I have interwoven two strings using the winterleave command. However, there is a space between the components of each interwoven pairing. I have tried the ltrim and rtrim to remove these spaces, but it didn't work. Also, I have checked the original strings to look for extra spaces and I could no...
by BT454
Tue Apr 02, 2019 7:12 pm
Forum: Programming
Topic: writing from Eviews workfile to SQLite database
Replies: 0
Views: 384

writing from Eviews workfile to SQLite database

Hi!
Is it possible to write from an Eviews workfile to a SQLite database using pagesave (or some other command)?
Thanks!
Bob
by BT454
Fri Mar 29, 2019 11:20 am
Forum: Data Manipulation
Topic: EIA Databases
Replies: 2
Views: 221

Re: EIA Databases

Please disregard! I think I got it figured out.
Thanks!
Bob
by BT454
Fri Mar 29, 2019 11:14 am
Forum: Data Manipulation
Topic: EIA Databases
Replies: 2
Views: 221

EIA Databases

Hi,
I recently saw that there is an option to connect to EIA databases in the database registry.
Do you by chance have a resource that has more information about (i.e. what data is available? how to connect? series mnemonics?)?
Thanks!
Bob
by BT454
Tue Mar 26, 2019 1:27 pm
Forum: Programming
Topic: Week number code
Replies: 9
Views: 424

Re: Week number code

I was wrong about that. Never mind my previous post, and thanks again!
by BT454
Tue Mar 26, 2019 9:52 am
Forum: Programming
Topic: plotting trendline to scatter graph
Replies: 1
Views: 183

Re: plotting trendline to scatter graph

Hi again,
I found the auxillary_spec functions (linefit, etc) and this took care of it.
Sorry for the false alarm!
Thanks agian
by BT454
Tue Mar 26, 2019 9:02 am
Forum: Programming
Topic: plotting trendline to scatter graph
Replies: 1
Views: 183

plotting trendline to scatter graph

Good morning, I'm coding a scatter plot to show the relationship between storage inventories (x axis) and gas prices (y axis). I have made the graph, and now I'd like to plot a trend-line on the graph fitted to a third or fourth order polynomial, describing the relationship with price as the depende...
by BT454
Mon Mar 25, 2019 4:47 pm
Forum: Programming
Topic: bar graph negative values
Replies: 5
Views: 276

Re: bar graph negative values

Ok. Thank you. I think I'm pretty close to figuring out a work around: evaluate max and mins of both series !z=@min(x) !zz= @max(x) !x=@min(y) !xx=@max(y) use if/then/else to determine absolute max/min between both series combined: if !z<!x then !zy = !z else !zy = !x endif if !zz>!xx then !yz = !zz...
by BT454
Mon Mar 25, 2019 3:43 pm
Forum: Programming
Topic: bar graph negative values
Replies: 5
Views: 276

Re: bar graph negative values

FWIW, the issue seems to occur after declaring which element will be oriented to which axis (left or right). In other words, if I remove the lines of code: HDDvsIW_{%x}.setelem(1) axis(l) HDDvsIW_{%x}.setelem(2) axis(r) then the orientation of data would be correct. However, I lose the scale and val...
by BT454
Mon Mar 25, 2019 2:59 pm
Forum: Programming
Topic: bar graph negative values
Replies: 5
Views: 276

Re: bar graph negative values

Thanks, Does it matter if I'm plotting 2 series? Is there anything in this code that would prevent this graph from looking like yours? I've attached a workfile so you can see the graph, and the series behind it. Thanks again, Bob group g iwusl48 hddusl48 freeze(HDDvsIW) g.bar HDDvsIW.setelem(1) axis...

Go to advanced search