cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
acil
‎07-14-2016
  • 8 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Filling data based on provided data in the same coloumn

by Super User in SAS Procedures
‎07-14-2016 03:18 AM
‎07-14-2016 03:18 AM
data have; infile cards expandtabs truncover; input CUSIP : $20. Ceodate Dirdate; cards; 00846U101 . 2003 00846U101 . 2000 00846U101 2003 013817101 . 2002 013817101 . 2002 013817101 2002 013817101 2005 013817101 . 1988 013817101 . 1977 013817101 . 1991 013817101 . 1994 013817101 1998 00949P108 . 2006 00949P108 . 2004 00949P108 . 2001 00949P108 2005 00949P108 . 1993 00949P108 . 1994 00949P108 . 2001 00949P108 1999 00949P108 . 00949P1081 . 00949P1081 . ; run; data temp; set have; by CUSIP notsorted; n+1; retain new_Ceodate; if first.CUSIP then call missing(new_Ceodate); if not missing(Ceodate) then new_Ceodate=Ceodate; drop Ceodate; run; proc sort data=temp; by descending n; run; data want; set temp; by CUSIP notsorted; retain Ceodate; if first.CUSIP then call missing(Ceodate); if not missing(new_Ceodate) then Ceodate=new_Ceodate; drop new_Ceodate; run; proc sort data=want; by n; run; ... View more

Re: How to merge two data sets with specific range of time following a...

by Super User in SAS Enterprise Guide
‎11-25-2014 07:19 AM
‎11-25-2014 07:19 AM
post the output you want . ... View more

Re: Filter data based on how long it last

by Amethyst | Level 16 in SAS Enterprise Guide
‎11-09-2014 09:34 AM
1 Like
‎11-09-2014 09:34 AM
1 Like
if i understood , could you please try data have; input Director_Name $  CEO Outside_Director Year_Service_Began     Firm_Name$ ; datalines; AA    1     0      1999              ABC       AB    0     1      2000              ABC       AC    0     1      1996              ABC   AD    0     1      2000              AAC      AE    1     0      2002              AAC     ; run; proc sort data=have; by Firm_Name descending CEO Outside_Director ; run; data want; set have; retain     CEO_date; by Firm_Name descending CEO Outside_Director ; if first.Firm_Name then CEO_date= Year_Service_Began; if ceo=1 then   CEO_date_=.; else  CEO_date_=CEO_date; drop  CEO_date; run; Thanks, Jag ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-14-2016 03:03 AM
Likes given to
View All
Quick links