topic Re: Custom Steps in SAS Studio

Custom Steps

Mostafa11 — Tue, 26 Sep 2023 10:33:13 GMT

How to install a new python library to be used in the custom step ?

Re: Custom Steps

ballardw — Tue, 26 Sep 2023 14:34:17 GMT

Show the code that generated those errors.

Best is to include a LOG entry if created. Include code along with all the notes, warnings or errors as well.

Copy the text and paste into a text box opened on the forum with the </> icon that appears above the message window to preserve formatting. Also if we have actual text and want to suggest a syntax change we can copy/edit/paste text that is not possible with pictures.

Since your picture of the errors includes a reference to the macro variable &temp_python you need to show what the definition of that macro variable is and perhaps even how it was created. The error message implies that you used the macro variable somewhere SAS expects to encounter a file name that must exist before the code runs. Apparently that file does not actually exist. So make sure it exists or fix the contents of the macro variable.

Re: Custom Steps

adam633_SAS — Wed, 27 Sep 2023 03:12:19 GMT

Please demonstrate your code so that we can truly help you.

Re: Custom Steps

Mostafa11 — Wed, 27 Sep 2023 06:31:02 GMT

When I run it again I have got this error

ERROR: Unhandled Python exception.
>>>
Traceback (most recent call last):
File "<stdin>", line 5, in <module>
File "<stdin>", line 2, in <module>
File "<string>", line 4
!pip install tabula-py
^
SyntaxError: invalid syntax
>>>
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PYTHON used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Re: Custom Steps

LinusH — Wed, 27 Sep 2023 09:48:54 GMT

I don't have access to Viya 4 so bear with me.

According to the documentation it looks like you need to use a SAS program. From your screen shot it looks like you are in a Python wrapper editor kinda, which I guess might work...?

Regardless, the log tells us that your code executed in PROC PYTHON, and somehow your syntax i incorrect.

It would be interesting to see the complete code with PROC PYTHON.