yesterday
Sajid01
Meteorite | Level 14
Member since
03-01-2017
- 1,247 Posts
- 719 Likes Given
- 81 Solutions
- 320 Likes Received
-
Latest posts by Sajid01
Subject Views Posted 79 yesterday 56 Sunday 2017 12-06-2024 08:51 AM 636 12-05-2024 08:49 PM 2135 12-05-2024 08:09 PM 303 11-28-2024 07:27 AM 483 11-20-2024 06:13 PM 863 11-20-2024 06:08 PM 922 11-20-2024 06:02 PM 714 11-18-2024 05:33 PM -
Activity Feed for Sajid01
- Got a Like for Re: SAS EG and Disk write. yesterday
- Posted Re: SAS EG and Disk write on SAS Enterprise Guide. yesterday
- Got a Like for Re: Jdbc jar file path is needed to call with java. Monday
- Posted Re: Jdbc jar file path is needed to call with java on SAS Programming. Sunday
- Liked Re: Code isn't working just right for hollandnumerics. 12-12-2024 07:35 PM
- Liked Re: Code isn't working just right for PaigeMiller. 12-12-2024 07:33 PM
- Got a Like for Re: How to stop converting date from UK to US format while reading from excel. 12-06-2024 10:44 AM
- Got a Like for Re: How to stop converting date from UK to US format while reading from excel. 12-06-2024 10:43 AM
- Posted Re: How to stop converting date from UK to US format while reading from excel on Administration and Deployment. 12-06-2024 08:51 AM
- Liked Re: Manipulating excel workbook for Ksharp. 12-06-2024 08:35 AM
- Got a Like for Re: Manipulating excel workbook. 12-06-2024 07:17 AM
- Posted Re: Manipulating excel workbook on SAS Programming. 12-05-2024 08:49 PM
- Posted Re: How to stop converting date from UK to US format while reading from excel on Administration and Deployment. 12-05-2024 08:09 PM
- Liked Re: Compute session resetting while working SAS Studio in SAS Viya 4 lts 2024.03 for sasefj. 12-04-2024 01:07 PM
- Got a Like for Re: Compute session resetting while working SAS Studio in SAS Viya 4 lts 2024.03. 12-03-2024 07:00 AM
- Posted Re: SAS Command executable in Viya on Moving to SAS Viya. 11-28-2024 07:27 AM
- Liked Deployment SAS Viya 4 DR env on Red Hat OpenShift 4.14 Using Red Hat ACM for Ahmed_Dhaoui. 11-28-2024 07:08 AM
- Got a Like for Re: CAS Connection issue SAS Viya 4. 11-25-2024 11:13 AM
- Got a Like for Re: Backup Strategy Recommendations for SAS Viya on Kubernetes (On-Premises). 11-25-2024 11:10 AM
- Got a Like for Re: Compute session resetting while working SAS Studio in SAS Viya 4 lts 2024.03. 11-20-2024 06:50 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 2 1 3 -
My Liked Posts
Subject Likes Posted 1 yesterday 1 Sunday 1 12-06-2024 08:51 AM 1 12-05-2024 08:09 PM 1 12-05-2024 08:49 PM
10-19-2024
09:33 AM
Hello
I am in agreement with @Tom about "No idea how Enterprise Guide decides when to create a MY SAS files folder for a user." IMHO solving this issue requires an understanding of the mechanism of how these files are created
(Where ignorance is bliss, knowledge is power).
... View more
10-17-2024
11:45 AM
Hello Your server appears to be connecting to the server defined by authdomain=SQLSVR . Your SAS Admin should be able to provide the details. You can try a direct libname statement to connect to the new server. This link has the details.
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0gz66qe8msnkyn1jgnhrr0l2k8y.htm
... View more
10-17-2024
11:31 AM
Hello The issue appears to be the syntax. I would prefer to write your content in sasenv_local as follows.
export ODBCHOME=/sas/AccessClients/9.4/SQLServer:/etc
export LD_LIBRARY_PATH=/sas/AccessClients/9.4/SQLServer/lib:/etc/snowflake_ODBC/lib:/usr/lib64:$LD_LIBRARY_PATH
export ODBCINI=/sas/AccessClients/9/4/SQLServer/odbc.ini:/etc/odbc.ini
export ODBCINST=/sas/AccessClients/9/4/SQLServer/odbcinst.ini:/etc/odbcinst.ini
export SIMBAINI=/etc/snowflake_ODBC/lib/simba.snowflake.ini
I assumed that the lib folder for sql server is at /sas/AccessClients/9.4/SQLServer/lib. If not please make appropriate changes. I would recommend that whenever you make changes to this file, get it validated by the Linux Admin for syntax.
... View more
10-04-2024
09:04 AM
Just curious, I hope the vbs file is located on the remote machine. This is, in my experience, the requirement. When one logs in via SSH, it is as good as logging locally to the machine. If one can run the script by physically logging in to that machine, then the expectation is that it should run after connecting via ssh. If it does not, and if you are in a managed environment, then, please get your Windows Admin involved and make find out if there are any restriction.
... View more
10-03-2024
09:01 AM
I have seen cases where SAS EG jobs being executed using external schedulers. In the instant case in addition to the suggestion by @ChrisHemedinger, I feel assistance on Windows Admin should be taken in resolving this issue.
... View more
10-02-2024
06:41 PM
Hello This is something for which one should approach SAS Tech Support
... View more
10-02-2024
06:24 PM
Hello @kumarsandip975 Have a look here https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/whatsdiff/n1cvbtjl85iu1un1pvem0xa3fgrm.htm
... View more
10-02-2024
06:11 PM
1 Like
Hello @sas_chinmay The message "Warning: Argument is deprecated" is not an error. It means that a newer method / or approach of providing the value of the argument is preferred. You may be following an older approach and have provided arguments according to that. Typically there would be no loss of functionality. If things are not working there is a chance that there are errors elsewhere.
... View more
10-02-2024
06:05 PM
Hello @jbond007 When the database name has changed , then in essence it is a new connection. The connection is being made to a new server/database. So prima facie yes. Details of registering tables could be found here https://documentation.sas.com/doc/en/bicdc/9.4/bidsag/n0g5t6jbzorstsn18d5e9h7ngdkw.htm Typically SAS Administrators would be able to handle this situation with ease.
... View more
10-02-2024
05:53 PM
Hello @js5 When one logs in to another machine using SSH it is as good as logging into that machine. With your error being 'Could not create object named "SASEGObjectModel.Application.8.1" ' there are two things that need to be checked
1.SAS EG 8.1 is installed on that machine.
2.Make sure that SAS EG executible and the cscript file locations are in your path. This can be verified using echo %PATH% command in the command shell.
If not then add the paths to the environment variables.
... View more
09-23-2024
10:08 PM
Hello @viswmmo Please pay attention to the I/O error as mentioned in the message I/O error on POST request f... Your job must be performing and I/O (Read / Write) and that is not happening. Are you connecting to some external database OR reading/Writing to a shared drive? If yes please look into it.
... View more
09-23-2024
10:03 PM
2 Likes
Hello @freshstarter There are multiple approaches to address your issue depending upon your environment and practices. One approach would be to create an authentication domain. This is typically done at the admin level. Please refer to the following references.
38204 - Using the AUTHDOMAIN= option with SAS/ACCESS® 9.2 engines (For SAS 9.x) creating domains and credentials using the sas-viya CLI (SAS Viya) The other approach would be to create a libref in the autoexec.sas or use encoded passwords as suggested by @Patrick
... View more
09-23-2024
02:06 PM
Hello @GuidoG I think the "Personal Way" in Part 1 of this article gives you a hint. One should be able to create a libref using libname statement referring to an accessible physical location.
... View more
09-11-2024
10:19 AM
Hello I see this in the log "
<hostnameX> Failed to connect to the host via ssh: Shared connection to hostnameX closed
Looks like this issue needs resolution.
... View more
09-11-2024
09:39 AM
Hello @SASExpo On rereading your posts, I see one important point you have mentioned and something that should have been taken a note off earlier. "Our users open a RDP session to a Windows terminal server that hosts the SAS client software, their user profiles for Windows are mapped to a share via group policy." This makes it clear why a large number of temp files are created at one location, why they accumulate over time and why profiles are stored on a shared server. My understanding is that Windows OS retains these .tmp files for the default duration.
The first option would be to make configuration changes to delete files older than "a set duration" if that is feasible (Not a windows expert). Alternatively write a PowerShell script to take care of this. I have used the term "a set duration" because in my experience SAS EG users keep their EG projects open for days together, and it is not an easy task to get this workflow changed. Deleting the tmp file for the session in use could create issues for the user. Therefore this "set duration " has to be agreed upon by all stake holders. The smaller the better.
If this approach is not workable for any reason, then the other feasible option would be to move the EG client to the user's local machine.
... View more