About Rhys

Rhys · ‎01-29-2018

I did something similar using Excel and VBA, after I exported all the xml files using proc export on a loop.

Rhys · ‎01-29-2018

You're right. There is a file location but there's different security on it and it's not really used for storing code. I didn't want to create a new file structure to keep code there, under a growing number of projects with version control that is just a copy of another directory. A macro catalogue seems a little neater and I can store them without the source code. Not that it's working, I can utilise multiple threads, if I start each program separately but running from branch returns errors. No worries, automated parallel processing isn't meant to be.

Rhys · ‎01-25-2018

select case when (var_a / var_b)*100 > 5 then 'Y' else 'N' end as var_c from table

Rhys · ‎01-25-2018

put the where after the from

Rhys · ‎01-25-2018

You have a Cartesian join, de dupe your source tables, with nodupkey or a proc summary.

Rhys · ‎01-25-2018

I'm attempting to utilise parallel processing in EG; it would seem whenever a new process is created, effectively a new session is created with a new work. So any macros defined earlier in the project will not be auto called. In my project flow I have program that defines a macro then forks out to several programs which call that macro. Later in the process I define another macro and then call it multiple times in the same way. My issue is that only the first call is working, all subsequent calls error due to lock. EDIT: If I run the programs individually, they all work fine, running simulataneously, however when I highlight a few at a time and run together or run from branch then the lock errors occur.

Rhys · ‎01-24-2018

Hello, I've created a macro that I can store globally on a linux server defined as follows; options mstored sasmstore = macrolib; libname macrolib '/sas_data/macrolib'; %macro test() / store; macro code... %mend; I can then call the macro in another EG session to execute the macro. %test(); Running... Then if I open a further session I get %test(); ERROR: A lock is not available for MACROLIB.SASMACR.CATALOG. ERROR: Lock held by process 23669. Is there a way to release the lock after the macro has been called but before if finishes executing?

Rhys · ‎01-24-2018

Thanks for your reply. I was thinking of using %include however, the server is on Linux and the client is Windows so it's not easy to get a script into an area that is readable by the server.

Rhys · ‎01-24-2018

Hello, I'm trying to call a macro in EG with Parallel processing enabled. The macro is defined in one program that is then linked to multiple others which all call it. However it will only get called the first time and then is dropped from memory. If I remove the macro definition program and instead place a copy in the call scripts they all run in parallel. However I only want to define the macro once, so any changes aren't made multiple times. How do I define a macro across multiple parallel processes Thanks R

Rhys · ‎01-24-2018

This is exactly what I've been trying to do, however in EG when you have enabled parallel processing, after the macro has been called the first time, it is dropped from memory. I will ask in the EG forums.

Rhys · ‎01-24-2018

No X cmd, although I could use python to do something similar. However I wanted to keep it all in one project

Rhys · ‎01-23-2018

There is no location for me store SAS files on the linux box. This isn't my code, but it can largely be broken up into different where statements which can be processed individually or as "var in (a,b,c)" running on thread 1; data test_a; set input_data; where var = "a"; run; running on thread 2; data test_b; set input_data; where var = "b"; run; running on thread 3; data test_c; set input_data; where var = "c"; run; Just to note, this is how I would run it currently, opening up 3 sessions and just running them simultaneously, which is 3 times faster then in one session subsequently or twice as quick as one big intensive query as one statement.

Rhys · ‎01-23-2018

Hello, I would like to use the same macro across multiple threads in Enterprise Guide to utilise parallel processing for example; I have a macro; %macro loop(thread_var); data test_&thread_var; set input_data; where var = "&thread_var"; run; %mend; I would like to submit this macro into memory then execute it on several threads using different programs on the same process flow all linked to the macro. So I can then run; %loop(a); %loop(b); %loop(c); In three different programs, all running in parallel. Any thoughts on how to do this? My SAS server is on Linux and my client is windows, so I can't use %include. I don't want to copy and paste the macro as I want to only change the code in one place. Thanks R

Rhys · ‎06-16-2017

I'm running a proc cluster on a linux sas server. and producing a proc tree png which gets exported to a windows location. During this process the height and width of the pixels gets reset and the dendrogram is unreadable. I've given up trying to fix that as I've noticed a few problems when converting files from linux to windows using base sas code, where as exports seem to work fine. So my question is, can I create a loop in Enterprise Guide; SAS Step to run cluster and tree, an export step, next loop, with a work table to control the loops? Rhys

Rhys · ‎05-10-2017

ods graphics on; proc logistic data=sample outmodel = model_output plots(only)=roc; model target(event = "1") = var1--var20; weight w; run; ods graphics off; where w = 1 or 0; Hello, if I run the above code, I'm hoping I'll fit a model based on the data where my weight variable is 1 and the output statistics will be where my weight variable is 0? Will the roc plot include all my data or just where w = 1? Thanks

Online Status	Offline
Date Last Visited	‎01-30-2018 06:00 AM

Re: How can i upload XML files to a WEB Service with wsdl address?

Re: Macros and Parallel processing

Re: proc SQL in SAS

Re: proc sql into with a where clause

Re: MERGE statement has more than one data set with repeats of BY valu...

Re: sasmstore locked, only one user can access at a time

sasmstore locked, only one user can access at a time

Re: Parallel Processing with Macros

Parallel Processing with Macros

Re: Macros and Parallel processing

Re: Macros and Parallel processing

Re: Scan for carriage return

Re: proc sql into with a where clause

Re: proc SQL in SAS

Parallel Processing with Macros

Re: Put statements to the log dynamically within datastep

Re: How can i upload XML files to a WEB Service with wsdl address?

Re: Macros and Parallel processing

Re: proc SQL in SAS

Re: proc sql into with a where clause

Re: MERGE statement has more than one data set with repeats of BY valu...

Re: sasmstore locked, only one user can access at a time

sasmstore locked, only one user can access at a time

Re: Parallel Processing with Macros

Parallel Processing with Macros

Re: Macros and Parallel processing

Re: Macros and Parallel processing

Re: Macros and Parallel processing

Macros and Parallel processing

Exporting 100's of images

Weight and proc logistic