About Santt0sh

Santt0sh · ‎09-01-2021

Hi Team, I have written a macro, which will read the external files when they are available at a location. The macro keeps looking for the files at the location for a specific interval and until the Max time assigned. Now, this macro will be used in few SAS codes to read the files. I happen to forget where do I add these macros to save me from running it every time the macro is called. As I remember it should be on Autocall. Please suggest on this.

Santt0sh · ‎08-10-2021

Thanks Maarten and Ashok for your guidance and suggestions!!! I would be Thankful if you can help me with a base line code to baseline code for loading AML core on legacy solution (SAS 9) which may serve as a starting point for us. Thanks Santtosh

Santt0sh · ‎08-04-2021

Hi All, We are upgrading to SAS 8.2 AML with SAS Viya3.5 from SAS 7.1 AML. I have a couple of questions, the experts here can Answer or provide me some guidance. As mentioned we are upgrading from SAS 7.1 to the above-mentioned version, in previous versions, we used to read files into Staging is and then load them to CORE now do we 1. need to upload all the files for ex. from 2000 or do we need or have an option of taking the Backup of CORE from SAS 7.1 and try to use it with 8.2 2. As I am aware that SAS 8.2 AML on our system has no SAS DI Studio, or maybe it doesn't come with SAS DI studio instead needs to use SAS Studio. Do we need to rewrite the ETL SAS DI jobs in SAS Studio or use the SAS DI jobs created for the ETL process? Please suggest!!! Regards,

Santt0sh · ‎05-05-2021

Hi All, I am unable to create a CASLIB using the CASLIB statement, but I can create a library (CASLIB) by right clicking the library - create new library - select CAS After the CASLIB is available in libraries still i am not able to list the CASLIB MYPTH. CASLIB MYPTH LIST; i get the below error: 78 CASLIB MYPTH LIST; ERROR: The caslib 'MYPTH' does not exist in this session. ERROR: The action stopped due to errors. NOTE: Action to LIST caslib MYPTH completed for session MYSESSION. 79 80 %studio_hide_wrapper; 88 Kindly suggest, I m using SAS Visual Data Science Decisioning trial provided by SAS. or am i trying anything which i am not authorized to in this trial? In the meantime let me check if i am authorized do what i am trying to using SAS Viya. Thanking you in Advance.

Santt0sh · ‎04-07-2021

Hi Greg, Thanks for the link, i am going through it now. I have a simple question What should be the extension or format the auth file. Now my auth file is in _authinfo.py Should the authfile have the extension ".netrc"?

Santt0sh · ‎04-07-2021

Hi Greg, Error trying to read authinfo file:C:\Users\santo\_authinfo [Errno 13] Permission denied: 'C:\\Users\\santo\\_authinfo' Did not find key oda in authinfo file:C:\Users\santo\_authinfo Permissions for all the users on this folder are granted.

Santt0sh · ‎04-07-2021

Hi Greg, Yes now i am not getting Syntax error, after i tried running the code. Error trying to read authinfo file:C:\Users\santo\_authinfo [Errno 13] Permission denied: 'C:\\Users\\santo\\_authinfo' Did not find key oda in authinfo file:C:\Users\santo\_authinfo Please enter the IOM user id: psantosh0 The OS Error was: The system cannot find the file specified ============================================================== Error trying to read authinfo file:C:\Users\santo\_authinfo [Errno 13] Permission denied: 'C:\\Users\\santo\\_authinfo' Did not find key oda in authinfo file:C:\Users\santo\_authinfo Please enter the IOM user id: psantosh0 The OS Error was: The system cannot find the file specified SAS Connection failed. No connection established. Double check your settings in sascfg_personal.py file.

Santt0sh · ‎04-07-2021

Hi Greg, Nothing has changed even after add or removing the comma. --------------------------------------------------------------------------- KeyError Traceback (most recent call last) <ipython-input-4-99201ba30faf> in <module> 1 import saspy ----> 2 sas_session = saspy.SASsession() 3 cars=sas.sasdata('cars', 'sashelp') 4 cars.head() C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py in __init__(self, **kwargs) 535 if self.sascfg.mode != 'HTTP': 536 try: --> 537 self.pyenc = sas_encoding_mapping[self.sascei] 538 except KeyError: 539 print("Invalid response from SAS on inital submission. printing the SASLOG as diagnostic") KeyError: 'No SAS process attached. SAS process has terminated unexpectedly.'

Santt0sh · ‎04-07-2021

Hi George, No, I haven't added the comma at the end of the IOM line.

Santt0sh · ‎04-07-2021

Hi Greg, yes you were correct US should be Commented and after i commented i ma getting a new error. i m trying to resolve this error, Please suggest me on this . Thanks. ======================================= Traceback (most recent call last): File "C:\ProgramData\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py", line 3418, in run_code exec(code_obj, self.user_global_ns, self.user_ns) File "<ipython-input-3-6370c5ed4af2>", line 2, in <module> sas_session = saspy.SASsession() File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 465, in __init__ self.sascfg = SASconfig(**kwargs) File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 129, in __init__ SAScfg = self._find_config(cfg_override=kwargs.get('cfgfile')) File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 332, in _find_config import sascfg_personal as SAScfg File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sascfg_personal.py", line 10 'iomport' : 8591, ^ SyntaxError: invalid syntax

Santt0sh · ‎04-07-2021

Hi Greg, Thanks for your reply, This is my sascfg_personal.py and the error is for a particular line. 'iomhost' :['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'] Kindly Suggest!! ==================================================== SAS_config_names=['oda'] oda = {'java' : 'C:\\Program Files (x86)\\Common Files\\Oracle\\Java\\javapath\\java.exe', #US Home Region US #'iomhost' : ['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'], 'iomhost' :['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'] #European Home Region #'iomhost' : ['odaws01-euw1.oda.sas.com','odaws02-euw1.oda.sas.com'], #Asia Pacific Home Region #'iomhost' : ['odaws01-apse1.oda.sas.com','odaws02-apse1.oda.sas.com'], 'iomport' : 8591, 'authkey' : 'oda', 'encoding' : 'utf-8' }

Santt0sh · ‎04-06-2021

Thanks for your quick response, yes i am using SAS Studio. import saspy sas_session = saspy.SASsession() Please find the output below. ========================================== Traceback (most recent call last): File "C:\ProgramData\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py", line 3418, in run_code exec(code_obj, self.user_global_ns, self.user_ns) File "<ipython-input-2-6370c5ed4af2>", line 2, in <module> sas_session = saspy.SASsession() File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 465, in __init__ self.sascfg = SASconfig(**kwargs) File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 129, in __init__ SAScfg = self._find_config(cfg_override=kwargs.get('cfgfile')) File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 332, in _find_config import sascfg_personal as SAScfg File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sascfg_personal.py", line 6 'iomhost' :['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'] ^ SyntaxError: invalid syntax

Santt0sh · ‎04-06-2021

Hi All, I am learning to use Python/Jupyter Notebook, I have followed all steps provided in the support doc but i'm still unable to start a SASsession. Can any of the SAS experts help fix this Syntax error(SyntaxError: invalid syntax)? import saspy sas_session = saspy.SASsession() sas_session Please find the error below after i import the saspy and start a SASsession. Traceback (most recent call last): File "C:\ProgramData\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py", line 3418, in run_code exec(code_obj, self.user_global_ns, self.user_ns) File "<ipython-input-20-0483c802e9d9>", line 2, in <module> sas_session = saspy.SASsession() File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 465, in __init__ self.sascfg = SASconfig(**kwargs) File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 129, in __init__ SAScfg = self._find_config(cfg_override=kwargs.get('cfgfile')) File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 332, in _find_config import sascfg_personal as SAScfg File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sascfg_personal.py", line 6 'iomhost' :['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'] ^ SyntaxError: invalid syntax

Santt0sh · ‎01-07-2021

Hi Super User, Thank you for the Solution, this was asked at an interview and this was for my learning and can be of great use in my current project or future projects and i missed to associate the count of the ID's to the ID's and i believe the Interviewer also was expecting the same answer. Even though i used the %put _User_ but missed looking at the Logs and the macro variables resolved.

Santt0sh · ‎01-06-2021

Hi, Thanks for your quick reply, i have tried this option, but the solution you gave me get the ID details and not the count of the ID's Apologies for not asking the right question I tried the below but this will not give me Out1 instead it gives me 1,2,3 and so on proc sql noprint; select distinct count(ID) into :out1- :out3 from test1 group by ID; quit; %put &out1 &out2 &out3; system cpu time 0.00 seconds memory 5590.62k OS Memory 33708.00k Timestamp 01/07/2021 04:24:49 AM Step Count 186 Switch Count 0 Page Faults 0 Page Reclaims 150 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 75 76 %put &out1 &out2 &out3; 3 5 7

Online Status	Offline
Date Last Visited	‎07-22-2025 10:17 AM

Re: i am trying to add '-'between date9.

Re: i am trying to add '-'between date9.

Re: i am trying to add '-'between date9.

i am trying to add '-'between date9.

Re: Need Help running running oracle query usng SAS Pass thru or Libna...

Re: Need Help running running oracle query usng SAS Pass thru or Libna...

Need Help running running oracle query usng SAS Pass thru or Libname f...

Re: SAS AML Custom Scenario Coding

Re: Can we write multiple lines in an excel sheet using Proc report?

Re: Can we write multiple lines in an excel sheet using Proc report?

Understanding Attributes of Kubernetes Persistent Volumes

Re: Need Help running running oracle query usng SAS Pass thru or Libna...

Re: Run schedule now to PPM is success but exited on LSF

Re: Run schedule now to PPM is success but exited on LSF

Re: How to split a table/dataset

Re: create a macro variable uisng proc sql in a pass thru facility rs...

Re: Teradata Spool Space error

to export a Proc Report export to excel with formats and into differe...

How do I import files(.xlsx) files from Tableau

To import an Excel file into SAS with column headers on more than one ...

Do i add user written macros to Autocall?

Re: SAS 7.1 - SAS 8.2 VIYA 3.5 CORE DATABASE

SAS 7.1 - SAS 8.2 VIYA 3.5 CORE DATABASE

unable to create a caslib using the caslib statment.

Re: Unable to start a SASsession

Re: Unable to start a SASsession

Re: Unable to start a SASsession

Re: Unable to start a SASsession

Re: Unable to start a SASsession

Re: Unable to start a SASsession

Re: Unable to start a SASsession

Re: Unable to start a SASsession

Unable to start a SASsession

Re: To produce produce a series of macro variables “outxx” where xx is...

Re: To produce produce a series of macro variables “outxx” where xx is...