KMW156

‎09-01-2015

Calcite | Level 5

Member since

2 Posts
0 Likes Given
0 Solutions
0 Likes Received

Follow KMW156

Recent Posts
Activity
Posts Liked
Posts Liked by Others
Article Contributions

Re: if Last.date then output - Returning blank results

1676

‎05-05-2015 08:20 AM

if Last.date then output - Returning blank results

1724

‎05-05-2015 07:24 AM

Activity Feed for KMW156

Posted Re: if Last.date then output - Returning blank results on SAS Programming. ‎05-05-2015 08:20 AM
Posted if Last.date then output - Returning blank results on SAS Programming. ‎05-05-2015 07:24 AM

I guess you wanted this: proc sort data=Dates; by FileNo createdate; run; data Dates_1; set Dates; by FileNo; if last.FileNo; run; which will give you the latest createdate for any FileNo. If you take a look at the log of your first try, you will get a clue where your problem is: NOTE: Variable 'last.createdate'n is uninitialized. A first. and last. pseudovariable is created only for those columns named in a by statement.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM