Search found 28 matches
- 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.
- 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...
- 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!
- 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.
- 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:
Here's another image:
- 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 ...
- 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...
- 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!
- 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...
- 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!
- 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...
- 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...
- 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!
Got it. Thank you so much!
- 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...
- 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 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?
Code: Select all
if {%seriesnam}.@type == "ALPHA" then ...