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!
Search results for query: *
- Users: SicAIvanov
- Order by date
-
import strange datetime format
Simple one I suppose, but I cannot solve it on my own. I have table which contains a string. The string is something like: "9/13/2010 11:52:54 AM" As you probably have guessed, I would like to "translate" this string in a SAS datetime object. Can you help me out?- SicAIvanov
- Thread
- Replies: 1
- Forum: SAS Institute, Inc. solutions
-
proc sql "top x" in subquery
Hello tek-tips users! I want to use SAS to execute a SQL query. What I had in mind (coming from T-SQL) is: proc sql; select id, (select top 1 address from tab_b b where b.id = a.id order by entry_date desc ) ad last_address from tab_a a; Or, to...- SicAIvanov
- Thread
- Replies: 1
- Forum: SAS Institute, Inc. solutions
