Search found 28 matches

by BigD
Tue Apr 04, 2017 9:19 am
Forum: Data Manipulation
Topic: Import CSV as numeric
Replies: 2
Views: 3003

Re: Import CSV as numeric

Thank you so much. :D :D :D
by BigD
Tue Apr 04, 2017 7:43 am
Forum: Data Manipulation
Topic: Import CSV as numeric
Replies: 2
Views: 3003

Import CSV as numeric

Hi, I have a CSV file I'd like to import. I've used the pageload command and the import command for this. But no matter what, the series are imported as alphas. Especially those that have "NA"s before numbers. When I imported it manually, the series came out as numeric. Is there a workarou...
by BigD
Thu Mar 02, 2017 12:53 pm
Forum: Data Manipulation
Topic: Changing the Convert Hilo Attribute
Replies: 8
Views: 5871

Re: Changing the Convert Hilo Attribute

Thanks for the clarification. I'll keep this in mind. Appreciate it!
by BigD
Thu Mar 02, 2017 10:13 am
Forum: Data Manipulation
Topic: Changing the Convert Hilo Attribute
Replies: 8
Views: 5871

Re: Changing the Convert Hilo Attribute

Series. I fetched them from the database.
by BigD
Thu Mar 02, 2017 10:01 am
Forum: Data Manipulation
Topic: Changing the Convert Hilo Attribute
Replies: 8
Views: 5871

Re: Changing the Convert Hilo Attribute

Yes, I've moved it into a workfile to change the attributes. But I can't change convert hilo (I believe it is an attribute already added by Eviews like freq). It just says I can't modify it.
Here's another image:
by BigD
Thu Mar 02, 2017 9:52 am
Forum: Data Manipulation
Topic: Changing the Convert Hilo Attribute
Replies: 8
Views: 5871

Re: Changing the Convert Hilo Attribute

I'm adding some attributes to a database. And I noticed that one of the default ones (that was already there) is called Convert Hilo. I wanted to change it to something like the Conversion Technique beside it. I've attached a picture to provide a visual aid. I've moved the series into a workfile in ...
by BigD
Thu Mar 02, 2017 9:42 am
Forum: Data Manipulation
Topic: Changing the Convert Hilo Attribute
Replies: 8
Views: 5871

Changing the Convert Hilo Attribute

Hi, I want to change the metadata in the Convert Hilo Attribute such as average => sum. But I am unable to as I get a message saying that it can't be modified. Is there another way to change it other than to replace it? It is because some methods of conversion isn't always by average. Or do we get a...
by BigD
Thu Feb 23, 2017 7:33 am
Forum: Data Manipulation
Topic: Keeping metadata in the database when updating
Replies: 2
Views: 3187

Re: Keeping metadata in the database when updating

Alright, thanks Jason!
by BigD
Tue Feb 21, 2017 1:23 pm
Forum: Data Manipulation
Topic: Keeping metadata in the database when updating
Replies: 2
Views: 3187

Keeping metadata in the database when updating

Hi, I want to know how to keep the metadata in the database when I store a series into it. The objects from a workfile have a different metadata which overwrites the ones in the database when I choose the overwrite all or merge&overwrite option. I don't want that to happen. Is there a way to not...
by BigD
Fri Feb 17, 2017 12:47 pm
Forum: Data Manipulation
Topic: Trying to add metadata into database
Replies: 4
Views: 3905

Re: Trying to add metadata into database

Thanks a lot, Gareth. That worked!
by BigD
Fri Feb 17, 2017 7:53 am
Forum: Data Manipulation
Topic: Trying to add metadata into database
Replies: 4
Views: 3905

Re: Trying to add metadata into database

Your thoughts are the way to go. Fetch into different pages based upon frequency, importattr, then store Thanks for the reassurance. But now I'm wondering how do I fetch from the data base based on frequency? Is there a frequency option/feature in the fetch command? Or do I have to do some prelimin...
by BigD
Thu Feb 16, 2017 7:13 pm
Forum: Data Manipulation
Topic: Trying to add metadata into database
Replies: 4
Views: 3905

Trying to add metadata into database

Hi, I'm trying to add some metadata into all the series in a database. I know there is this useful command known as importattr. However, that only works for objects in a workfile. Therefore my logic is that I fetch the objects from the database and then import the metadata from my excel file (column...
by BigD
Tue Jan 31, 2017 10:57 am
Forum: Programming
Topic: Validating series type
Replies: 5
Views: 4200

Re: Validating series type

Oh nvm. My brain is probably dead today. I used the wrong {%seriesnam} for the condition. This was for the old data (which are all numerical). {%seriesnam}_01 is for new data which are the ones I'm testing for.

Got it. Thank you so much!
by BigD
Tue Jan 31, 2017 10:54 am
Forum: Programming
Topic: Validating series type
Replies: 5
Views: 4200

Re: Validating series type

Oh right. Forgot there's an else statement option and mixed up == and =. Silly me. However, it still doesn't work. Perhaps it is because the alpha series are skipping over the condition? The error I get goes like "Numeric operator applied to string data in "SERIES B{%SERIESNAM} = @ABS((GDP...
by BigD
Tue Jan 31, 2017 10:28 am
Forum: Programming
Topic: Validating series type
Replies: 5
Views: 4200

Re: Validating series type

I see, I've changed it to

Code: Select all

if {%seriesnam}.@type == "ALPHA" then ...
but it didn't work. The percent difference calculation still went. I even tried @detailedtype. Is my increment to skip alpha series for the calculation incorrect?

Go to advanced search