Ah cheers man, that does work!
It's really annoying how Statistical Programs can make your day fly by because of errors ( no offense to Eviews though haha )
Search found 4 matches
- Mon Apr 05, 2010 7:46 am
- Forum: Data Manipulation
- Topic: Importing Panel data from Excel
- Replies: 25
- Views: 25425
- Mon Apr 05, 2010 2:33 am
- Forum: Data Manipulation
- Topic: Importing Panel data from Excel
- Replies: 25
- Views: 25425
Re: Importing Panel data from Excel
Don't mind that previous data, it seems there went something wrong with the ID function in SAS itself, you'll notice that there were ID's of 1760 which is impossible as I only had 1688 different ID's, I retried everything and now ended up with ID's that look to be normal but still have 12 duplicated...
- Mon Apr 05, 2010 1:08 am
- Forum: Data Manipulation
- Topic: Importing Panel data from Excel
- Replies: 25
- Views: 25425
Re: Importing Panel data from Excel
Ok, euhm my data is the following Excel file (manipulated and stuff in SAS, for instance the ID I did with ) proc sort data=code out=temp(keep = amaskcd ticker) NODUPKEY ; by amaskcd ticker; run; data temp; set temp; ID=_N_; run; It's this file Try, try.xls , now you said that I have duplicated obse...
- Sun Apr 04, 2010 4:19 pm
- Forum: Data Manipulation
- Topic: Importing Panel data from Excel
- Replies: 25
- Views: 25425
Importing Panel data from Excel
Hey guys, a quick question,I'm busy loading panel data into Eviews. I followed the guide over here: http://forums.eviews.com/viewtopic.php?f=7&t=74 (the one with usa unemployment etc) but still managed to stumble on some problems. I work with Eviews 5.1 (university licenses only allow us to have...