Hi there We have jobs scheduled that run on Flow Manager and alot of them exit because of the ERROR: A lock is not available for xxxxxx. Is there a way to solve for this using some SAS code so that the code can retry to run? ... View more

hi there Is there a way for me to code something in SAS that will go through the various jobs running on Flow Manager. If for example 4 programs are running then I want it to exit before starting a new instance. This is to reduce the strain on our service therefore I would like to keep a log and control the jobs with a sas program instructing the jobs.  ... View more

Hi there I have jobs that run sas scripts on IBM Flow manager. Is there a way for me to save a tabular log of the jobs? For example, save the logs in a sas table.     ... View more

hi there   i am saving a file in a library and I want to datestamp it with todays date for e.g. MyLib.Testfile_280921   how do I do that so that the date can be passed using todays date variable? ... View more

Hi there   I am writing SAS dataset into an Ms SQL table. I have 2 SAS columns that have type best17.15 in SAS and type numeric(15) in Ms SQL. When it inserts the data these 2 columns populate as NULL in Ms SQL.   Why this does happen and how can I resolve the issue? ... View more

hi there   i am looking for a Proc SQL code to transfer a table from SAS to Ms SQL.   Please assist, I can not find any code anywhere ... View more

Hi there   If I have a table, how can I get the top 50% of records into one table and thereafter the bottom 50% of records in another table?   I generally use PROC SQL;   Please assist.   Thank you ... View more

Hi there   I am trying to perform the below SQL code in a proc sql in SAS   SQL code: select reference into #Wi from #all where Reference in (select left(Reference ,len(Reference )-1)+ max(right(Reference ,1)) from stgw group by left(Reference ,len(Reference )-1)) group by Reference , UCN1 order by ucn1   I tried: proc sql; create table Wi as select reference from all where Reference in (select left(Reference ,len(Reference )-1)+ max(right(Reference ,1)) from stgw group by left(Reference ,substr(Reference, lenght(Reference)-1,0))) group by Reference , UCN1 order by ucn1   Error: ERROR: Function LEN could not be located. ERROR: Expression using subtraction (-) requires numeric types.   How can I perform the length function in SAS PROC SQL? ... View more