Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help: using SAS Macro to create complex data set
I tried to revised the above example to make it clear. Account date Time ID hit 387000 6/10/2010 12:00:00 13.15 1 387000 6/9/2010 12:00:00 13.15 1 387000 6/8/2010 12:00:00 13.14 1 387000 6/6/2010 11:00:00 13.15 1 387000 6/5/2010 10:00:00 13.14 1 387000 6/4/2010 9:00:00 13.13 0 387000 6/4/2010...- NiuYa
- Post #2
- Forum: SAS Institute, Inc. solutions
-
Help: using SAS Macro to create complex data set
I have a data set similar to the following simple data set. With the four column of Account, Date, Time and ID, I like to using SAS macro to create a column like "HIT" with 0 and 1 value. The logic is " there is more than 1 of ID used within 2 days from the same account." If the logic is...- NiuYa
- Thread
- Replies: 2
- Forum: SAS Institute, Inc. solutions
