Search found 48 matches

by BT454
Thu May 07, 2020 8:04 am
Forum: Programming
Topic: working with data from SQL database
Replies: 4
Views: 610

Re: working with data from SQL database

You are correct! My fault. thanks again!
by BT454
Thu May 07, 2020 6:49 am
Forum: Programming
Topic: working with data from SQL database
Replies: 4
Views: 610

Re: working with data from SQL database

Thank you for you reply!
Is there a way I can take the output from the pagestruct command and create a time series for each region ID, showing the value, by date?
by BT454
Fri May 01, 2020 12:59 pm
Forum: Programming
Topic: working with data from SQL database
Replies: 4
Views: 610

working with data from SQL database

Hi all, I'm working with some data from a sql server. I use the pageload command to query the sql database, and successfully import the data into eviews. It correctly imports the data by column. The database i'm pulling from is a relational database, and I would like to manipulate this data into tim...
by BT454
Thu Dec 19, 2019 8:23 am
Forum: Any Other Business
Topic: Attribute limit?
Replies: 1
Views: 5418

Attribute limit?

Hi!
Is there a character maximum/limit for attributes fields, or is there an option where a maximum number of characters for an attribute can be adjusted/increased?
Thanks!
Bob
by BT454
Fri Apr 26, 2019 11:46 am
Forum: Programming
Topic: evaluating if an attribute exists using @isobject
Replies: 3
Views: 869

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: 869

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: 976

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: 682

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: 847

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: 847

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: 944

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: 1195

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: 1195

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: 1576

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: 589

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

Go to advanced search