Typically a sas depot has a folder for stand alone clients for SAS EG and SAS AMO. If your intention is to have the latest SAS EG only, I suggest that you may contact SAS Tech Support to see if this alone can be downloaded. This  would simplify the process. I wish somebody from SAS enlightens on this approach. ... View more

Hello @SMarieH1521  I see this in the log output you have posted : OS Memory 2097148.00k. The default value of -memsize option is 2 GB. This could be one reason for the error. You can progressively increase this value  till you get the result. If your job is the only one running process, then a value of MAX can be used. Bear in mind that in addition to SAS, OS and other processes will be consuming memory. Once the available RAM is exceeded, depending on the OS settings, memory contents will be swapped to disk and this slows down the system   and eventually   the system may hang. ... View more

Hello @Sandeep77  You have mentioned "I did a proc compare step but it shows 50 records and says the max limit has reached." This is the default and can be overridden with different otpions. Have a look at the documentation here. SAS Help Center: Syntax: PROC COMPARE PROC COMPARE Statement In particular have a look at this example SAS Help Center: Comparing Values of Observations Using an Output Data Set (OUT=). ... View more

Hello @SASuserlot  Prima facie this appears to be a local non SAS issue. The first step is to approach your local IT support / SAS Admin for resolution. ... View more

Hello @amitbjambhulkar  This has something to do with your configurations of your local installation. The appropriate approach would be to approach the SAS Administrator at your place. ... View more

Hello @HeatherNewton  The error indicates that either the user's identity has not been created in the metadata server OR he may not have been added to authentication provider(LDAP/AD etc) and proper groups assigned. The SAS Administrator (or somebody who performs these duties) at your place should be able to assist.   ... View more

Hello @Daily1  SAS Viya pulls the list of users from the authentication providers typically LDAP/AD. New users would need to be added at the authentication provided level. Manual addition is not possible directly into SAS Viya. ... View more

Hello @vamsinuthalapat  While it is possible to have multiple workspace location, but SAS will randomly select it. I am not aware of your environment but on Linux system users session folders are created with permission 700. It does offer a degree of privacy. (Typically sas admins and installer account are do not have sudo/root access on Linux server). Better have a tract open with SAS tech Support. ... View more

Hello Sorry to hear about your issue. Is your SAS a local install on your PC/Laptop ? OR you have SAS client like SAS EG locally installed and SAS running on the server? ... View more

Hello SASWork is a temporary storage area. Once the user session ends normally the space is freed. Can you please elaborate a bit as to why customization is needed? In the meantime the following are some helpful links. Using SASv9.cfg, autoexec.sas, SAS Registry, and Options to Set Up Base SAS® Solved: How to change the WORK library folder location based on user - SAS Support Communities 37593 - Dynamic allocation of the SAS® Work folder in a Windows operating environment ... View more

Hello @SASdevAnneMarie  If the size of data too big for Excel consider Microsoft Access / PowerBI depending on your needs and end usage. ... View more

Hello @SASPreK  This is my humble opinion to your question based on your initial post. (Often SAS provides many ways of doing the same thing. I am showing how I would do it.) You need to tell SAS that you are reading date values and their format by using  the informat statement. This was not done in your code. Optionally tell SAS how to store the date values by using the format statement. Once done the age can be calculated. Add 'AGE" option to yrdiff  function to tell that you are calculating age.  Look here for details on yrdiff. Your updated code will be as follows data have; informat dob sample_dt yymmdd8.; format dob sample_dt yymmddn8.; input dob sample_dt; age=yrdif(dob, sample_dt, 'AGE'); datalines; 19650214 20100429 19800724 20210823 19991208 20090908 ; run; The output will be as follows   ... View more

Hello @tan-wongv  If you want the outcome as you have shown, then you would need to modify @Tom 's code as follow   data have; input DMRN $ last_visit :date. UI recorded_time :date.; format last_visit recorded_time date9.; cards; 31 26AUG2021 0 06APR2018 31 26AUG2021 0 16JAN2020 31 26AUG2021 1 4MAY2021 31 26AUG2021 1 26MAY2022 33 24MAY2022 0 02MAR2020 33 24MAY2022 0 24MAY2022 35 01DEC2014 0 25MAR2013 35 01DEC2014 1 05JAN2015 ; data want ; set have; if ui=1 then new_date = recorded_time; else if ui=0 and DMRN=31 then new_date="04MAY2021"d; else new_date = last_visit; format new_date date9.; run; The result would be as you wished   ... View more