Search found 12 matches

by Jun
Fri Mar 18, 2011 7:59 pm
Forum: Programming
Topic: Converting Table Values to String
Replies: 0
Views: 2144

Converting Table Values to String

Hi,

Suppose if I've got a 3x3 table

ABC 123 456
DEF 789 012
GHI 345 678

And I want to create a string "ABC DEF GHI" out of it.
What's the best way for me to do it?
by Jun
Fri Mar 18, 2011 7:13 pm
Forum: Programming
Topic: Delete Empty Rows from a Table
Replies: 4
Views: 13120

Re: Delete Empty Rows from a Table

Oh Jason, I found anyway to do it. Thanks!
by Jun
Fri Mar 18, 2011 7:02 pm
Forum: Programming
Topic: Delete Empty Rows from a Table
Replies: 4
Views: 13120

Re: Delete Empty Rows from a Table

Thanks Jason. When I said it didn't work, I meant that the code runs properly but the rows don't get deleted. E.g. [blank] [blank] ABC [blank] DEF GHI could end up with [blank] ABC [blank] DEF GHI Sometimes the blanks are gone but other times they remain. I suspect it's because when I use deleterow,...
by Jun
Fri Mar 18, 2011 3:23 am
Forum: Programming
Topic: Delete Empty Rows from a Table
Replies: 4
Views: 13120

Delete Empty Rows from a Table

Hi,

How do you remove empty rows from a table?
And how to you convert a table into a matrix?

I've tried using
if @isempty(sigbeta(!i,1)) = 1 then
sigbeta.deleterow(!i)

for the first part but it doesn't work.
by Jun
Thu Mar 17, 2011 11:40 pm
Forum: Programming
Topic: Exogenous List for OLS
Replies: 2
Views: 3428

Re: Exogenous List for OLS

Thanks! It works.
by Jun
Thu Mar 17, 2011 2:06 am
Forum: Programming
Topic: Exogenous List for OLS
Replies: 2
Views: 3428

Exogenous List for OLS

Hi,

What's the exogenous command for the NAMES of the independent variables in a regression?
E.g. @coefs for coefficients, @tstats for t-stats, @rbar2 for adjusted r-squared
by Jun
Thu Mar 17, 2011 1:29 am
Forum: Programming
Topic: ADF Critical Value
Replies: 0
Views: 2301

ADF Critical Value

Hi,

What's the programming function for ADF critical value? (See red box)
by Jun
Wed Mar 16, 2011 5:16 pm
Forum: Estimation
Topic: OLS with Variable Independent Variables
Replies: 4
Views: 5010

Re: OLS with Variable Independent Variables

I think I got it...thanks for !i=1 to @wcount(%independent) %currentindependent=@word(%independent,!i) %currentseries=@wlookup(%currentindependent,"series") series y = {%dependent} series x = {%currentseries} %dependent = "y" %currentseries = "x" equation eq{!i}.ls(cov=...
by Jun
Wed Mar 16, 2011 4:57 pm
Forum: Estimation
Topic: OLS with Variable Independent Variables
Replies: 4
Views: 5010

Re: OLS with Variable Independent Variables

Hi Gareth, Can you explain why the following works? I don't get it. %dependent = "y" %currentseries = "x" So now this works...BUT what should I do if I want to see the names of my independent variables in each "eq" output? Now they're all X's. for !i=1 to @wcount(%indep...
by Jun
Wed Mar 16, 2011 3:50 am
Forum: Estimation
Topic: OLS with Variable Independent Variables
Replies: 4
Views: 5010

OLS with Variable Independent Variables

When I tried to run the following OLS procedure, I got the error message "%CURRENTSERIES(0 TO -12) is not a valid string or scalar name." And when I place the "(0 TO -12)" outside the braces i.e. {%currentseries}(0 to -12), I get the error message "0TO is not defined." ...
by Jun
Tue Mar 15, 2011 8:14 pm
Forum: General Information and Tips and Tricks
Topic: Updating multiple equations?
Replies: 12
Views: 37283

Re: Updating multiple equations?

Thanks Gareth. I've used your code but I'm having an issue with @abs(ADF(2,!i)) which returns a string. FYI, ADF is a 4xn matrix and row 1 is the name and rows 2-4 are numbers. How can I get around this error? !crival = 4 %serieslist=@wlookup("*","series") for !i=1 to @wcount(%se...
by Jun
Tue Mar 15, 2011 7:29 pm
Forum: General Information and Tips and Tricks
Topic: Updating multiple equations?
Replies: 12
Views: 37283

Re: Updating multiple equations?

Hi, What if I want to loop the following? genr d1_CONFI = d(CONFI) genr d1_CPI = d(CPI) genr d1_FPER = d(FPER) genr d1_GBY = d(GBY) genr d2_GDP = d(d(GDP)) genr d1_M1 = d(M1) genr d2_NFP = d(d(NFP)) genr d1_PMI = d(PMI) genr d1_TED = d(TED) genr d1_USD = d(USD) I tried using: %serieslist=@wlookup(&q...

Go to advanced search