thanks ... View more

I have starred the codes that are not clear to me     data sue1/view=sue1;  *** set comp2; by gvkey fqtr fyearq; *** if dif(fyearq)=1 then do; ***  lagadj=lag(ajexq); lageps_p=lag(epspxq);lageps_d=lag(epsfxq); lagshr_p=lag(cshprq);lagshr_d=lag(cshfdq);lagspiq=lag(spiq); end; if first.gvkey then do; *** lageps_d=.;lagadj=.; lageps_p=.; lagshr_p=.;lagshr_d=.;lagspiq=.;end; if basis='P' then do; actual1=epspxq/ajexq; expected1=lageps_p/lagadj; end; else if basis='D' then do; actual1=epsfxq/ajexq; expected1=lageps_d/lagadj; end; else do; actual1=epspxq/ajexq; expected1=lageps_p/lagadj; end; sue1=(actual1-expected1)/(prccq/ajexq); format sue1 percent7.4 rdq date9.; *** label datadate='Calendar date of fiscal period end'; keep ticker permno gvkey conm fyearq fqtr fyr datadate rdq sue1 basis act prccq mcap; run; ... View more

Hi i ran the mentioned code and results are Alphabetic List of Variables and Attributes # Variable Type Len Format Informat 1 GVKEY Num 8 BEST12. BEST32. 3 LIID Num 8 BEST12. BEST32. 6 LINKDT Num 8 DATE9. DATE9. 7 LINKENDDT Char 9 $9. $9. 2 LINKPRIM Char 1 $1. $1. 4 LINKTYPE Char 2 $2. $2. 5 LPERMNO Num 8 BEST12. BEST32. 18 ajexq Num 8 BEST12. BEST32. 23 atq Num 8 BEST12. BEST32. 45 co_cik Num 8 BEST12. BEST32. 42 co_conm Char 27 $27. $27. 44 co_cusip Char 9 $9. $9. 47 co_naics Num 8 BEST12. BEST32. 46 co_sic Num 8 BEST12. BEST32. 43 co_tic Char 3 $3. $3. 17 conm Char 21 $21. $21. 33 conml Char 21 $21. $21. 13 consol Char 1 $1. $1. 31 costat Char 1 $1. $1. 24 cshfdq Char 1 $1. $1. 25 cshoq Num 8 BEST12. BEST32. 26 cshprq Num 8 BEST12. BEST32. 19 curcdq Char 3 $3. $3. 20 datacqtr Num 8 DATETIME. ANYDTDTM40. 8 datadate Num 8 DATE9. DATE9. 15 datafmt Char 3 $3. $3. 21 datafqtr Num 8 DATETIME. ANYDTDTM40. 27 epsfxq Num 8 BEST12. BEST32. 28 epspxq Num 8 BEST12. BEST32. 10 fqtr Num 8 BEST12. BEST32. 36 from Num 8 DATE9. DATE9. 9 fyearq Num 8 BEST12. BEST32. 11 fyr Num 8 BEST12. BEST32. 35 gvkeyx Num 8 BEST12. BEST32. 34 iid Num 8 BEST12. BEST32. 41 indexcat Char 3 $3. $3. 38 indextype Char 5 $5. $5. 12 indfmt Char 4 $4. $4. 14 popsrc Char 1 $1. $1. 32 prccq Num 8 BEST12. BEST32. 22 rdq Num 8 DATE9. DATE9. 29 saleq Num 8 BEST12. BEST32. 39 spii Char 1 $1. $1. 30 spiq Num 8 BEST12. BEST32. 40 spmi Num 8 BEST12. BEST32. 37 thru Char 1 $1. $1. 16 tic Char 4 $4. $4. ... View more

the variable to which i want to use 31dec9999 has dates in some observations and 'E' in some observations. How do i get rid of the E's? ... View more

the variable linkenddt has dates of format 30-Jun-78 and in some observations it is 'E". ... View more

hi i corrected that but still getting this error ERROR: Function COASLESCE could not be located. ERROR: Character expression requires a character format. ... View more