Hello @sasjradmin  Please make sure that the locations where your sas jobs read from and write to (for example SASWORK,data etc) are local to the new computer. If these are remote/networked locations that may contribute to slowness. ... View more

Hello @kevin_stanford  There is one thing that I would like to point SAS EG is a desktop application. If it is taking time to start, then one needs to a have a look at the desktop- its resources and the number of applications that are running. Just to for a test, save and stop all applications. Restart your desktop and start EG and see how much time it takes. The issue may be at the desktop/network level. ... View more

Hello @js5  "It does what I want it to do when started from a Citrix session on a machine SAS EG is installed, but if I ssh into the machine and try to run it, I get the error:" Is the same user account used in both instances? Please make sure that the PATH variable has the same value in both cases. ... View more

Hello @Pato485  I see this in your post "This is working: LIBNAME mylib ODBC dsn='NMI' schema=dbo; Because it is windows auth, but when we tried it through username and password - and odbc connection sql server, it doesnt work. And we dont know why" Please check authentication mechanism defined in SQL server. ... View more

I think the best option is to create a ticket with SAS Tech Support. ... View more

Hello @shoin  Thanks for the question.Two questions. Have you preassigned the libraries? Did anybody pointed to the library with mouse pointer and right clicked to assign the library? Did this work? ... View more

Hello @alepage  Have a look at this https://www.sas.com/en_us/webinars/ate-viya-architecture-data-movement.html ... View more

Hello @ravi999985  It depends on what you are doing. 1.For any one using SAS EG for using SAS on a UNIX server,  a very minimal knowledge of UNIX is sufficient (case sensitivity,  file /path conventions etc, may be ssh/scp). 2.For someone using the Unix shell to write and execute SAS code, write/use shell scripts then a good working knowledge of the shell (BASH/KSH whichever that is  being used) is needed. Focus on developing a knowledge of shell scripting/programming rather than memorizing a few commands. ... View more

Hello @scwein  In your scenario, with the constraint of using proc sql, I would first add  columns to the table using Alter table statement  and then in the next step would perform the join. If you want to do it in one step as you are trying, I would  prefer  a data step instead. ... View more

Hello @POOJAA  The path to pursue depends on your interests. Looks like you have been trying for data analysts position. Good number of positions in data analysts require a knowledge of Python, some visualization tools like Tableau , Power BI and Excel. R is also good to have. I would strongly recommend learning Data analysis with Python, R and Power BI or Tableau Learning these tools requires substantial time and resources. These skills would add value to your skills in SAS. ... View more

Hello @Mahis  Your error indicates that object spawner is not able to authenticate the user. Suggest you approach SAS Tech Support for assistance. ... View more

If it is the intention to send email with http post request and if you are open to looking at python, then please have a look at https://stackoverflow.com/questions/58242068/i-want-to-send-file-as-attachment-to-an-api-post-request ... View more

Hello @haibh  Did you get a chance to look at this? https://support.sas.com/kb/57/650.html ... View more

Hello Prima facie this is not a SAS issue. The following link has more information on why the error occurs. https://stackoverflow.com/questions/26244425/general-error-unable-to-open-registry-key-temporary-volatile-from-access   ... View more

Hello Your query, if it is as posted, would be pulling all the data earlier than the specified date. Add more filter conditions and consider using the between operator if you want to pull data between two dates. Have a look at the following link. It is about pulling last seven years data https://stackoverflow.com/questions/27599557/how-to-get-last-7-days-data-from-current-datetime-to-last-7-days-in-sql-server ... View more