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?
Search found 12 matches
- Fri Mar 18, 2011 7:59 pm
- Forum: Programming
- Topic: Converting Table Values to String
- Replies: 0
- Views: 2144
- 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!
- 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,...
- 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.
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.
- 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.
- 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
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
- 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)
What's the programming function for ADF critical value? (See red box)
- 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=...
- 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...
- 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." ...
- 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...
- 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...
