EViews.com

thanks. So it looks like there is no similar shortcut as in "x(-1 to -5)". Ok

how do I run an OLS with lagged logs? While i can do the following: "x c x(-1 to 05)" i was not able to do "x c dlog(x(-1 to 05))"

how do I fill missing data? i would like to fill missing data with its recent value. For example, 1 2 3 NA 4 5 becomes 1 2 3 3 4 5.
Are there other options for filling missing data?

thx

it is a series in file that includes intraday seconds: 09:30:00 09:30:01...

hi,

Why does the following create an error: "series sday1=(second=09:30:00)" -> "09:30:00 is not defined"
and the following also creates an error: "series sday1=(second="09:30:00")" -> "Numeric operator applied to string data"

thx for the help

Thx. It is the latter- looking to get distinct pairs. N-way tabulation (with count, list layout) would do, but I have to go over the outcome and clean the cases with zero count to get the actual list. I was hoping for an easier way.

How do I get the list of distinct combination of two (or more) variables? In sql, the list would be simply "select distinct x,y from table". In EViews, to get distinct list of one variable, I use the command "freeze(mode=overwrite, distinct_list) x.freq(nov,noa)". But what comman...

beautiful. Thanks a lot.

Thanks. That's what I did, indeed (i.e., "freeze(mode=overwrite, syms) sym.freq(nov,noa)". A quick follow-up to question 5. Is this what you meant: "group1.cor(mode=overwrite, Out=Group1_)"? This solution does work. When running on verbose mode, this command pops up the correlati...

many thanks.

This definitely works for panel data, but not for non-panel stacked data.
thx

I will appreciate your help in the following questions: (1) Is there a function that provide the number of cross-section IDs? My solution is: series cxid=@crossid scalar cxidnum=@max(cxid) Is there more elegant way? (2) Is there a function that gives the list of distinct cross-section IDs? (3) How d...

The suggestion does not do the trick. It only offsets the beginning of the entire data by 1. Assume IBM are observations 1 to 10, MSFT 11 to 20. Your suggestion will first restrict the data to observations 2 to 20, and then apply the "if" restriction. That means, "smpl @first+1 @last ...

you can do the following
smpl @first+1 @last

so, my question is whether I can do something similar, where I define my sample to be restricted to "smpl if ticker=%ticker_now" and then move the start of sample by one observation forward?