chchanghenry's articles:

Items(23) /3 Next >> Last >|

create new group ID 1 33 (1/18/2013 10:01:08 AM) comp.soft-sys.sas Hello there, I have a data set looks like: Firm varx A 0.774859 A 0.329258 A 0.610605 A 0.872355 B 0.190724 B 0.159308 C 0.664658 C 0.620615 C 0.613843 I would like to create a new group I... CC

slect a list of variables in proc sql 2 23 (1/14/2013 4:14:18 PM) comp.soft-sys.sas Dear all, I was wondering that in proc sql, how can we select a list of similar variables? For example, if we want the x1 to x9, in proc sql, can we write something like: proc sql; create table wan... CC

delete macro variables only in the iteration. 4 19 (1/13/2013 9:01:56 AM) comp.soft-sys.sas Hi there, My macro looks like the following: %macro doit; %do i =3D 1 %to 5; data new; set old; = =20 if fyear =3D &i; ... CC

delete macro variables in the iteration 0 16 (1/13/2013 8:46:45 AM) comp.soft-sys.sas Dear all, My macro looks like the following: %macro doit; %do i =3D 1 %to 5; data new; set old; =20 if fyear =3D &i; call symput('ID'||left(_n_), firm); run;... CC

calculate every pair of two segments 2 11 (1/10/2013 1:05:33 PM) comp.soft-sys.sas Hello there, I have a data likes the following: Firm year Segment CF A 1980 1 0.657969 A 1980 2 0.518277 A 1981 1 0.535381 A 1981 2 0.988772 A 1982 1 0.967236 A 1982 2 0.014072 A 1983 1 0.46643 A 1... CC

Compute correlation between segments 2 11 (1/8/2013 9:21:25 AM) comp.soft-sys.sas Hello there, I have a data likes the following: Firm year Segment CF A 1980 1 0.657969 A 1980 2 0.518277 A 1981 1 0.535381 A 1981 2 0.988772 A 1982 1 0.967236 A 1982 2 0.014072 A 1983 1 0.46643 A 1... CC

Select observations within three years of a event date 3 20 (11/5/2012 2:16:07 PM) comp.soft-sys.sas Hello there, I have two datasets, A and B, where A looks like: eventdate 1990/12/15 1980/02/06 2001/07/03 2004/09/01 B dataset looksl ike: Firm begdate enddate A 1979/01/31 ... CC

Help about creating a dummy if it is satisfied with a certain condition. Thanks. 1 23 (7/23/2011 4:41:17 AM) comp.soft-sys.sas Hello there, I have a question on creating a dummy if it is satisfied with a certain condition. Here is the data I have: firm year x1 A 1985 0 A 1986 0 A 1987 0 A 1988 0 A 1989 1 A 1990 1 A 1991 1 A... CC

A Match question. Thanks. 7 162 (12/1/2010 9:49:35 PM) comp.soft-sys.sas Hello all, I have a question regarding the matching procedure. The are two companies for instance: ABBOTT ABBOTT ABBOTT ABBOTT ABB ABB ABB For example, if I want to keep ABB and use the "contain... CC

A merge question 3 110 (11/25/2010 7:01:09 PM) comp.soft-sys.sas Hi dear all, Happy Thanksgiving! I have a question to ask. I have to data sets with unique company name. I tried to use the proc sql to merge this two data sets. So, my case is if the company shows i... CC

chchanghenry's replies:

Items(7) /1

Need to find a value that can make the equation's value = 0 like Solver in Excel 7 18 (7/10/2010 6:38:32 PM) comp.soft-sys.sas Hi dear all, I am looking for any function I can use to solve the following equation: Mi,t =96 Bi,t =96 (ROEi,t+1 =96 Ri)*Bi,t/(1+Ri) - (ROEi,t+2 =96 Ri)*Bi,t+1/ (1+Ri)^2 - (ROEi,t+3 =96 Ri)*Bi,t+2/(1+Ri)^3 ... chchanghenry (32)

output correlation matrix from PROC REG to a dataset 3 224 (7/28/2010 12:04:35 AM) comp.soft-sys.sas Hi dear all, just wondering that can I output the correlation matrix to a dataset from the PROC REG procedure. The code I am using is: proc reg data = afreg outest=relation corr; model hret12 = ICC / ... CC

Using IF statement to assign sub-groups. Need more efficient way to do it. 5 176 (8/15/2010 5:12:47 AM) comp.soft-sys.sas Hello all, I would like to assign the observations into few sub-groups using the IF statement. So, for instance, I wrote a code like this: if var = 'W1' or var = 'W2' or var = 'W3' then group = 1 else i... chchanghenry (32)

Select observations within three years of a event date 3 20 (11/5/2012 2:16:07 PM) comp.soft-sys.sas Hello there, I have two datasets, A and B, where A looks like: eventdate 1990/12/15 1980/02/06 2001/07/03 2004/09/01 B dataset looksl ike: Firm begdate enddate A 1979/01/31 ... chchanghenry (32)

calculate every pair of two segments 2 11 (1/10/2013 1:05:33 PM) comp.soft-sys.sas Hello there, I have a data likes the following: Firm year Segment CF A 1980 1 0.657969 A 1980 2 0.518277 A 1981 1 0.535381 A 1981 2 0.988772 A 1982 1 0.967236 A 1982 2 0.014072 A 1983 1 0.46643 A 1... chchanghenry (32)

delete macro variables only in the iteration. 4 19 (1/13/2013 9:01:56 AM) comp.soft-sys.sas Hi there, My macro looks like the following: %macro doit; %do i =3D 1 %to 5; data new; set old; = =20 if fyear =3D &i; ... chchanghenry (32)

slect a list of variables in proc sql 2 23 (1/14/2013 4:14:18 PM) comp.soft-sys.sas Dear all, I was wondering that in proc sql, how can we select a list of similar variables? For example, if we want the x1 to x9, in proc sql, can we write something like: proc sql; create table wan... chchanghenry (32)