Loop starts at 7:00:00 and Should stop at 21:59:59 Inside the loop an Insert query is executed. This insert operation may take any number of minutes starting from 1 to 300 minutes or even more. Once the Insert query is done, then find the next nearest 30th minute time and run the Insert query again. Ex: 1. The first iteration started at 07:00:00 (1st iteration) 2. This took 12 mins to finish. 3. Wait for 18 mins. 4. Trigger SQL insert at 07:30:01 (2nd iteration) 5. 2nd Iteration query takes about 1 hr 11 mins - Which means the insert operation finished at 8:41:00 6. Wait for 19 mins. 7. Trigger SQL insert at 09:00:01 (3nd iteration) 8. 3rd Iteration query takes about 5 hr 37 mins - Which means the insert operation finished at 14:37:00 9. Wait for 23 mins. 10. Trigger SQL insert at 15:00:01 (4th iteration) 11. And so until 10pm. The moment 10pm occurs program should end.   Im not really good in this kind of time based loop hence need your advice / sample code to achieve this requirement.    Request if any can help in this...   Thanks,   Anil   ... View more

Hi All,   I want to run something like below.  Any simple way to run %if &var_Status. not in ('XP','XC','TP') %then %do;   Below is the error what I get- ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: "&var_LastCampaignSetStatusCode." not in :('XP','XC','TP') ERROR: The macro CHECKCONTROL will stop executing.     %macro CheckControl; /*Get the status of previous campaign load*/ proc sql; select ID, Status into :var_ID, :var_Status from SomeTable having ID = max(ID); quit; %if &var_Status. not in ('XP','XC','TP') %then %do; /*Do something*/ %end; %else %do; /*Do something else*/ %end %mend CheckControl; %CheckControl; ... View more

Hi All, Im trying to insert records into SQL Server table through SQL Passthrough from SAS Dataset. Below is the code which Im using and error I get. Looks like i cannot use the SAS Dataset reference in a SQL Passthrough. Please advice how can i fix this. Note: On SQL Server, i dont have option to create a temporary table. I can use a normal sql insert, but wondering how can i use it this way.     connect to sqlsvr (&sqlconn.); execute ( insert into sqlschema.sqltable ( col1, col2, col3 ) select col1, col2, col3 from mylib.sas_dataset; ) by sqlsvr; disconnect from sqlsvr;   ERROR: CLI execute error: [SAS/ACCESS to SQL Server][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid object name 'mylib.sas_dataset'. ... View more

Hey all, Im facing a probelm in our SAS Env Manager.   Grid1 SAS Deployment Agent 1.0 shows Host Platform as Grid2 instead of Grid1. I'm wondering where this information is picked up and displayed. Any views please?   Rgds, AK ... View more

Hi All,   One of our SAS user is facing a strange problem. He opens DI Studio and tries to run a job and this fails giving error "Not positioned on a valid row"   I also tried executing simply proc setinit; run; and this also resulted the same error.   Not sure where what went wrong.   Request if someone can advice on this. ... View more