About pras3

pras3 · ‎03-21-2014

Hi, I can't seem to merge the attached dataset using the following code. There appears no errors on the log file but there is no data in the merge file. proc sort data=G4;by TIC Fyear; run; proc sort data=G5; by TIC Fyear;run; data G6A;merge G4(in=x) G5(in=y); by TIC Fyear;if x=y;run; Thank You Puspa

pras3 · ‎12-06-2013

Hi , I am trying to calculate the average market to book rate for t year, t-1 year and t-2 for a particular firm.

pras3 · ‎03-28-2013

Dear anca tilea, I have attached the sample dataset. The dataset is a sub-sample data that only include low growth firms. However there are firms which are not consistenly falling within the low growth category from 2001 to 2011 and have missing data in the dataset for few years.As firms can also be facing high growth between 2001 and 2010. I need to select firms which are consistently low growth between from 2001 and 2011 from this sample data. Thank You. regds p

pras3 · ‎03-28-2013

HI THERE, I AM TRYING TO EXTRACT A SAMPLE OF FIRMS (WITH THE SAME PERMNO) THAT EXIST FROM FYEAR FROM 2001 TO 2011 AND DELETE THE FIRMS THAT HAS MISSING FYEAR AT THE BEGINNING (2001) OR AT THE END (2011) OR IN BETWEEN. THNAK yOU FOR THE SUPPORT. P

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

merging two dataset

Find the average market to book score 3 years.

Re: Sub-sample of the dataset

Sub-sample of the dataset

Re: Sub-sample of the dataset

merging two dataset

Find the average market to book score 3 years.

Re: Sub-sample of the dataset

Sub-sample of the dataset