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: 
Sunnykapoor
‎12-17-2018
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Lag function

by Calcite | Level 5 in New SAS User
‎12-06-2018 09:48 AM
‎12-06-2018 09:48 AM
It is showing no result. ... View more

Re: Lag function

by Calcite | Level 5 in New SAS User
‎12-06-2018 09:30 AM
‎12-06-2018 09:30 AM
My apologies as MN is the field with unique value, it should be compared with rows having same MN. In data set it can be 2 or 3. I am in learning phase, so trying to grasp how different type of commands work in SAS. ... View more

Re: Lag function

by Calcite | Level 5 in New SAS User
‎12-06-2018 09:24 AM
‎12-06-2018 09:24 AM
My apologies MN is the unique value. expected outcome for example is : MN TN EII ND 238552 40006248 1 1 ... View more

Re: Lag function

by Calcite | Level 5 in New SAS User
‎12-06-2018 09:07 AM
‎12-06-2018 09:07 AM
I have sorted the data for better understanding. Does "follow" mean on the very next observation, or on any subsequent observation?                      subsequent Could the observation with ND=1 and EII=1 be the second (or later) observation for a TN?               Any place for observation How many observations might there be (maximum) for a TN?                                                              2 (ND/EII=0/0 or ND/EII=1/0) I am new in to SAS so it would be really helpful if you would provide the full data step.   Thanks you for prompt response. ... View more

Lag function

by Calcite | Level 5 in New SAS User
‎12-06-2018 08:42 AM
‎12-06-2018 08:42 AM
Hi,   I am working on data which have several values and I have to compare them. I am trying to use Lag function but unable to get through. Below are the context of data:   MN TN EII ND 238552 40006248 1 1 316969 40006248 0 0 631788 40006248 1 0 660798 50098722 1 0 660007 50098722 0 0 661359 50098722 1 1   TN is the unique value and scenarios are: 1) we have to select TN with EII and ND as 1 and 1 only if TN with same number is followed by either EII and ND as 0 and 0 or EII and ND as 1 and 0. 2) No Duplicate entries for TN. Please suggest ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-17-2018 10:04 AM
Quick links