The code samples are just fragments to show the syntax, not complete programs.   This works:   data null; h1=hour(datetime()); select; when  (h1<12) greetp1 = "Morning  " ; otherwise greetp1='foo'; end;   put greetp1; run; ... View more

It's Linux, so yes'-ish'. ... View more

tried that...got this error: 37 select * from connection to foo 38 (describe table CLAIM) 39 ; SYBASE_69: Prepared: on connection 3 describe table CLAIM ERROR: Error Code: -156 Incorrect syntax near the keyword 'table'. ... View more

No idea. I don't have any Windows software that connects to Sybase...just SAS on Linux. I actually do specify a schema of dbo in my connection string. Sybase dox say 'DESCRIBE INDEX FOR TABLE Customers' should work but I get errors with every variant of that I've tried. ... View more

Nope...that doesn't work either.  Tried explicit and implicit.  I can't find any examples that work!   select * from connection to sybase(select * from sp_tables);   SYBASE_49: Prepared: on connection 0 select * from sp_tables   ERROR: Error Code: -208  sp_tables not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help         may produce lots of output).     Implicit error:   NOTE: Libref FOO was successfully assigned as follows: Engine: SYBASE Physical Name: RPT_XEG_2 29 30 select * from foo.sp_tables; SYBASE_56: Prepared: on connection 1 SELECT * FROM dbo.sp_tables ERROR: File FOO.sp_tables.DATA does not exist.   ... View more

I suggested that because you need to go one step at a time. Get the hour, get 2 hours earlier, then find the visits. ... View more

are you able to retrieve the hour from Triage_Completed_DTS directly? ... View more