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: 
mac2
‎05-09-2017
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: retain or lag?

by Calcite | Level 5 in SAS Programming
‎05-09-2017 08:12 AM
‎05-09-2017 08:12 AM
sorry, i wasn/t explicit enough. i want for each US and type to have the 'first' date when the type changed. for example, for US='X' type='C' i want to keep only the records underlined:   X A 30JAN09 X C 31MAR09 X C 31MAY09 X A 30JUN09 X C 30AUG09 X P 31OCT09 X A 01NOV09 X A 21NOV09 X C 20DEC09 X C 31DEC09 ... View more

retain or lag?

by Calcite | Level 5 in SAS Programming
‎05-09-2017 07:48 AM
‎05-09-2017 07:48 AM
Hello, i have the data below and i want for each change for the variable Type (by US)  to get the first date and keep only one record for each type:   data test; informat date YYMMDD10.  ;format date ddmmyy10.; input @1 US $ @3 Type $  @5 date date7.; datalines; X A 30JAN09 X C 31MAR09 X C 31MAY09 X A 30JUN09 X C 30AUG09 X P 31OCT09 X A 01NOV09 X A 21NOV09 X C 20DEC09 X C 31DEC09 Y A 30JUN09 Y C 30AUG09 Y C 28FEB10 Y A 31MAY10 ; the result should be: US Type date X C 20-Dec-09 X A 1-Nov-09 X P 31-Oct-09 Y C 30-Aug-09 Y A 31-May-10   Thank you ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-09-2017 09:29 AM
Quick links