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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert date in char to SAS date
friends, the below is working fine. create table tab1.maxdate as select input(max(entry_dte), ddmmyyyy10.) as max_ent_date from regentry; quit...- sunny567
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Convert date in char to SAS date
also what I can do in the below query to ensure that the input date (which is in format 20.07.2006) is stored as SAS date in SAS dataset? proc sql; create table tab1.maxdate as select...- sunny567
- Post #2
- Forum: SAS Institute, Inc. solutions
-
Convert date in char to SAS date
Friends, I have a db2 date unloaded in character format eg. 31.12.2005 (DB2 length=10). I need to convert it into a SAS date format before writing to a SAS dataset. How can I do this? Please help. Also how to handle the timestamp (DB2 length=26). also what is the SAS datatype for DECIMAL(11,2)...- sunny567
- Thread
- Replies: 2
- Forum: SAS Institute, Inc. solutions
-
Date criteria in SQL query (+FETCH)
Chris, the second sample is similar to what I was trying to achieve. Thanks for that. Do you normally use pass-through SQL? I have read in SUGI papers that pass-through SQL is more efficient than access with LIBNAME.- sunny567
- Post #5
- Forum: SAS Institute, Inc. solutions
-
Date criteria in SQL query (+FETCH)
Chris, thanks for the reply. I preferred to change the design and not to use SAS for this. Some tables have 250million records and its worth doing DB2 unloads and processing the data using DFSORT (mainframe world!!!) For the date logic you mentioned, can you please share sample code or any...- sunny567
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Date criteria in SQL query (+FETCH)
Hi, I am using SAS to access DB2 tables. I have a very complex join of large number of tables which is taking ages to complete running (batch). I would like to add a date criteria to the query. Will this work - in SQL query -> where date_field > date()-60. Don't I need to convert the value...- sunny567
- Thread
- Replies: 5
- Forum: SAS Institute, Inc. solutions
