I've been building an automation program in vbs that uses the SAS EG scheduling vbs as a framework and then I've heavily customised it.   Part of that customisation is to run a list of EGP files listed in a set of calls. This all works fine, but my final task is to build a timeout functionality, which I know windows task scheduler has built in, but this is for the entire script. What I am trying to do is build it specific to each time an EGP is called, so that it can kill one if it takes too long and then move on to the rest.   What I ended up trying is using the prjobject.isrunning but it doesn't function the way I expected, I can't find any documentation about it and I was hoping someone had used it succesfully in the past.   Failing that, has anyone achieved something similar via a different method? ... View more

Hi,   I'm in the process of creating an automation script for the daily SAS reports and I have some key issues that I'd really appreciate assistance with.   Error checking / reporting So I have an array of projects: prjPaths = Array("Report1.egp","Report2.egp".... ) and so on. Currently there are 17 as a proof of concept but this will double when I have ironed out the issues. I loop through this array with: For Each prjName in prjPaths which is working fine, however we have quite a temperamental environment / VPN. So what I'm trying to achieve is to log in a simple manner whether a workflow has run without errors (warnings I don't mind). Any ideas on how to write this for each report to a file?   Array gathering All these Report.egp are in different folders and may be modified / updated to new versions by any member of the team. I built a vbscript to create a text array by searching for EGP files in locations, but when I include this and use the "strText" in the above prjPaths = Array("strText") it doesn't work, but if I write this to a file it's exactly how I've manually put the list into the array. Again, any ideas?   Monitoring Last one I promise!  When you run a script for SAS it runs in the background and you can see in the task manager that something is running but not which. I have a MsgBox at the end to tell me that it's all run, but it would be great to see that it's currently running or even better, which part of the array is currently running.   Thanks for any and all help! ... View more

Hi, I'm looking to move our reporting to a more automated basis; however, I've got an issue with the VBS / Task Scheduler option. SAS is installed on our laptops, we have to connect via VPN when we WFH so we can't automate "while logged on" with the windows task scheduler. (Obvious suggestion is the permanently on machine at the office, but that has more "political" issues than anything!) So, I've been looking into the SAS management console option. I can't find an explanation as to whether and EGP can be scheduled. Firstly, does anyone know if this is possible? Secondly, if so, any ideas on which component is needed: SAS DATA Step batch Server or SAS Generic Batch Server At which point I'm hoping it's "easy" to use the schedule manager! Any help is appreciated! ... View more

Hi,   I'm doing a looped import of a set of files in a folder. So far I have this:     %let path=\\server\Monthly; %let tranloc = 2019-04; filename folder "&path\&transloc\"; options validmemname=extend; /* Making a list of all files in the folder */ data IL_FilesInFolder; length Line 8 File $300; List = dopen('folder'); do Line = 1 to dnum(List); File = trim(dread(List,Line)); output; end; drop list line; run; DATA IL_FIF; SET IL_FilesInFolder; WHERE File CONTAINS 'Monthly_Transaction_Extract'; RUN; data _null_; set IL_FIF end=final; call symput(cats('File', _N_), trim(File)); call symput(cats('Name', _N_), trim(nliteral(substr(File,1,LENGTH(File)-4)))); call symput(cats('Table', _N_), trim(nliteral(substr(File,41,10)))); if final then call symputx(trim('Total'), _N_); /* replaced symput by symputx */ run; %macro inloop; %do i = 1 %to &Total; proc import datafile="&path\&transloc\&&name&i...csv" out=WORK.&&Table&i dbms=csv replace; GUESSINGROWS=5000; run; %end; %mend inloop; %inloop This month I had an error during the inloop section. The problem... one of the transaction extract files was empty. This is entirely possible so no problem there.   What I then considered was conditionally importing based on whether the file was empty. I figured file size was the best way to do this. I found the following: https://blogs.sas.com/content/sasdummy/2017/09/08/filename-zip-details/   Which seemed like it might be the right starting point, but I'm struggling to adapt this to loop through my list of files, I'm guessing because this assigns the file name based on a single zip as opposed to the folder.   Any help would be appreciated, but if a different approach is better I'm happy to consider this. For reference, I have no access to the file production process so I can't step in earlier to resolve this.   Thanks   ... View more

I have a list of flags that I would like to define in a %LET statement   %LET vcodes = LCI LJL DIB MEH CRB LEB BAS AGE STC DMA; I then need to filter a couple of tables based on these, I've done this with a string of values, but it doesn't seem to work for characters:   PROC SQL; CREATE TABLE codes AS SELECT * FROM Source_table WHERE warning_code IN (&vcodes); RUN; I have also tried: PROC SQL; CREATE TABLE codes AS SELECT * FROM Source_table WHERE warning_code IN ("&vcodes"); RUN; With no luck, is there a trick to this? Why does it work for numeric values, but not character?   Thanks in advance! ... View more

The database setup at my organisation is SQL Server tables copied onto our SAS server. The SQL tables were setup to run pre-programmed SQL queries, but now SAS is the tool used. This however creates an issue with some tables having variables that are too long for SAS, but work in SQL. The label for the source variable is correct and not shortened.   The source table (in SQL Server) names: Consolidated_Arrears_Vs_Portfolio_Balance_Ltd Consolidated_Arrears_Vs_Portfolio_Balance_Pure   In SAS: Consolidated_Arrears_Vs_Portfoli Consolidated_Arrears_Vs_Portfoli   SAS Labels: Consolidated_Arrears_Vs_Portfolio_Balance_Ltd Consolidated_Arrears_Vs_Portfolio_Balance_Pure   So, how do I tell the difference between these two when I'm writing code / query builder?   Thanks in advance.   (I have no control over the SQL Server code so I can't change the underlying tables or how these are copied to the SAS server) ... View more

Hi,   I have code that creates financial batch files that distribute funds from an external party. They have recently levied a 40p (or cent if this helps clarify) charge per transfer. They send a transfer that is then broken down into several accounts, Obviously this works fine for any even number up to 40, however, any time the number of accounts is odd, then the split won't be to a round pence.   Any ideas how I can include this kind of logic?   Thanks for any help! ... View more

Hi there, I'm new to the SAS forums, but been using Enterprise Guide 5.1 for about a year now (soon upgrading to the latest EG).   I have a project where I transpose month by month data from vertical to horizontal, thereby creating a column for each month. Obviously this adds a new column each month, which I then have to manually add to the query that follows it.   I'm wondering whether there is any way to automatically add these new columns to my query, or alternatively, to tranpose without generating the "Source" and "Label" columns. I'm a new user so while not being afraid of using code to do this, I have zero background in coding (hoping to learn this soon though)!   Thanks in advance for any help. ... View more