Search found 22 matches

by bcchen
Fri Sep 15, 2017 8:01 am
Forum: Data Manipulation
Topic: create a series using @dateceil() not working
Replies: 3
Views: 172

create a series using @dateceil() not working

Hi, I have a series called "quarter" that contains dates, which is the first day of the quarter. I want to create a quarter_ceil=@dateceil(quarter,"Q"), but it generates error message saying @DATECEIL is not a Genr or series expression function. Did I do something wrong? How do I...
by bcchen
Thu Sep 14, 2017 5:46 pm
Forum: Data Manipulation
Topic: SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?
Replies: 2
Views: 221

Re: SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?

Thank you Matt.
Hope there will be an @firstby() for alpha series soon.

Best,
BC
by bcchen
Tue Sep 05, 2017 4:39 pm
Forum: Data Manipulation
Topic: SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?
Replies: 2
Views: 221

SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?

Hi Guys, I want to get the first observation of a alpha series(alpha1) each time another two series's value changes (alpha2 and series3). I know we have @fistsby for numeric series, is there any formula (or formula communication) that I could do something like: alpha alpha1_new=@firstsby(alpha1, alp...
by bcchen
Mon Aug 28, 2017 1:13 pm
Forum: Data Manipulation
Topic: unable to change tabulation-freezed table value column format
Replies: 2
Views: 274

Re: unable to change tabulation-freezed table value column format

Thank you Gareth.
Your way does solve my problems.

Best,
BC
by bcchen
Mon Aug 28, 2017 12:11 pm
Forum: Data Manipulation
Topic: unable to change tabulation-freezed table value column format
Replies: 2
Views: 274

unable to change tabulation-freezed table value column format

Hi, I have a question regarding changing the format of a table. I freeze a frequency tabulation of a date series called "quarter" to a table, (for each "*_ipu" series missing ones) and append them into a spool: missing_qtr_distr Below are my codes: spool missing_qtr_distr %fieldl...
by bcchen
Mon Jul 31, 2017 2:47 pm
Forum: Data Manipulation
Topic: imputing missing data in panel/pooled dataset
Replies: 7
Views: 510

Re: imputing missing data in panel/pooled dataset

Stealing from Glenn: 4. genr(r) y_new2 = @recode(y=na and @obsid>1, @recode(y(1)=na, y_new2(1), y(1)), y) Hi guys, When I ran a similar codes like above on an alpha series, it only imputes the obs right before the not-empty ones. When I run the command again, it fills up the second one before the n...
by bcchen
Mon Jul 31, 2017 2:39 pm
Forum: Data Manipulation
Topic: VALUE MAP IMPORT AND LIMIT
Replies: 2
Views: 212

Re: VALUE MAP IMPORT AND LIMIT

HAHA, that's so weird.

When I do it today, it works.Maybe I was having other big work files opened last time.

Thank you so much!
by bcchen
Wed Jul 26, 2017 9:42 am
Forum: Data Manipulation
Topic: VALUE MAP IMPORT AND LIMIT
Replies: 2
Views: 212

VALUE MAP IMPORT AND LIMIT

HELLO, I have questions regarding building a value map. I have a series that includes SIC/NAICS code for each observation and I want to build a value map for SIC/NAICS code to the corresponding abbreviation of the industry name. So that series would show simple industry name instead of the code. I h...
by bcchen
Thu Jul 13, 2017 4:19 pm
Forum: Data Manipulation
Topic: imputing missing data in panel/pooled dataset
Replies: 7
Views: 510

Re: imputing missing data in panel/pooled dataset

Guys, for the reverse generation,

Code: Select all

genr(r) y_new2 = @recode(y=na and @obsid>1, @recode(y(1)=na, y_new2(1), y(1)), y)


why does @obsid have to be bigger than 1? what will happen if I don't put that?
by bcchen
Thu Jul 06, 2017 11:38 am
Forum: Data Manipulation
Topic: imputing missing data in panel/pooled dataset
Replies: 7
Views: 510

Re: imputing missing data in panel/pooled dataset

Hi Glenn and Gareth, Thanks you so much for your answers! They are exactly what I want! I have a follow-up on it: For (2), I agree with your point and I will think more about the implementation I want if modes are not unique. But assume that mode are unique, is there a function to pull the mode? som...
by bcchen
Wed Jul 05, 2017 10:28 am
Forum: Data Manipulation
Topic: imputing missing data in panel/pooled dataset
Replies: 7
Views: 510

imputing missing data in panel/pooled dataset

Hello, I have a question regarding simple imputing of missing data in a panel/pooled data set. Suppose I have dated panel data for 10 quarters (Q1-Q10) for 10 people(ID1-ID10). For certain field Y, 2 people are missing 2 quarter data. For each person, I want to use: 1) the average of the other 8 qua...
by bcchen
Mon Jun 19, 2017 10:54 am
Forum: Programming
Topic: Replacement Variables inside quotes
Replies: 8
Views: 1075

Re: Replacement Variables inside quotes

oh yes! Got it worked now!
Thank you Gareth!
by bcchen
Mon Jun 19, 2017 10:03 am
Forum: Programming
Topic: Replacement Variables inside quotes
Replies: 8
Views: 1075

Re: Replacement Variables inside quotes

Hello, I am trying to loop inside a location path as shown in the codes below. for %quarter 07q4 08q1 08q2 %file1="c:\users\bc03760\desktop\i-common field building\datarows\quarter workfiles\common field round\common filed round 2 apploan-acct attribute\commonfiled_"+{%quarter}+"applo...
by bcchen
Thu Jun 15, 2017 6:28 pm
Forum: Programming
Topic: structure workfile--create cellID with command when there are duplicates
Replies: 2
Views: 200

Re: structure workfile--create cellID with command when there are duplicates

maybe I am not clear what I want to do: when the ID series have duplicates, when we try to structure the page with that ID series, EVIEWS will pop up:" no uniquely identify observations. create CELLID series to identify observations?" Instead of passively waiting for the pop up, I want to ...

Go to advanced search