Hi all,   When I run sas services (./sas.servers start), SASInformationRetrievalStudioforSAS service does not work. when ı run this command;  ./IRStudio.sh start I get this error; Traceback (most recent call last): File "/sas/config/Lev1/Applications/SASInformationRetrievalStudioforSAS/start.py", line 24, in <module> error_log_file = os.path.join(log_dir, "information-retrieval-studio-server-errors.log") File "/usr/lib64/python3.6/posixpath.py", line 94, in join genericpath._check_arg_types('join', a, *p) File "/usr/lib64/python3.6/genericpath.py", line 151, in _check_arg_types raise TypeError("Can't mix strings and bytes in path components") from None TypeError: Can't mix strings and bytes in path components   How can ı fix it?     ... View more

Ods layout isn't supported in ODS RTF. I have tried ods region column_span=3 style={padding=0 margin=0}; to create 3 columns then do ods region column_span=1 style={width=4in padding=0 margin=0 just=l}; I have tried many things by I can't get the charts side by side. I have a long code within ods html which contains proc ghart, proc sgplot etc. Some are side by side in the html file. How can I recreate this within ods rtf?   ... View more

I would like to merge two dataset using one variable in one data set and multiple variables in the second data set. Here are the examples of the data sets. I need to use ID from data1 and merge on either ID1, ID2, or ID3 from data2.   data data1; input ID VAR1 $; datalines; 1 A 1 B 1 C 2 A 2 C 3 A 3 B ; run; data data2; input ID1 ID2 ID3 VAR2; datalines; 1 . . 22 1 . . 25 4 2 . 40 4 2 . 24 4 2 . 29 5 6 3 12 5 6 3 15 ; run; ... View more

Hello guys. I have a difficult task that needs help with. So I am working on some contracts data with Policy as the key. 1 Police_ID can have multiple endorsement (AKA Version). For example: POLICE_ID   END_ID POLICE_EFFECTIVE_DATE  POLICE_EXPIRY_DATEEND_SER_EFFECTIVE_DATE END_SER_END_DATE A                      0             01Jan2024                                31Dec2024                  01Jan2024                                   05Mar2024 A                      1              01Jan2024                                31Dec2024                 06Mar2024                                  31Dec2024   As we can see, a single POLICE_ID (Policy number) can have 2 END_ID (endorsement or we call it version) with different endorsement date (END_EFFDATE and END_EXPDATE).   Here is the task that i have been cracking my head. The data is not in the desired form at the moment and i am supposed to transform the data into that format as above. This is what I got:  Below sample is all for a single POLICE_ID. In reality, I have more than 100,000 of POLICE_ID. Scenario A (Extended Period) Originally         END_ID END_SER_EFFECTIVE_DATE END_SER_END_DATE POLICE_EFFECTIVE_DATE POLICE_EXPIRY_DATE 0 1/1/2024 31/12/2024 1/1/2024 31/12/2024 1 1/2/2024 31/12/2024 1/1/2024 31/12/2024 2 1/1/2025 31/1/2025 1/1/2024 31/12/2024 It should be transformed into: END_ID END_SER_EFFECTIVE_DATE END_SER_END_DATE POLICE_EFFECTIVE_DATE POLICE_EXPIRY_DATE 0 1/1/2024 31/1/2024 1/2/2024 31/1/2025 1 1/2/2024 31/12/2024 1/2/2024 31/1/2025 2 1/1/2025 31/1/2025     In the end result, for END_ID = 0, the value of "END_SER_END_DATE" is populated from "END_SER_EFFECTIVE_DATE"-1 in END_ID = 1. The logic for this is because there shouldn't be any date of "END_SER_XXX_DATE" overlap with the next line of "END_ID". Moreover, since this is an extended scenario, the POLICE_EFFECTIVE_DATE and POLICE_EXPIRY_DATE is now changed. For POLICE_EFFECTIVE_DATE, it will be based on the new POLICE_EXPIRY_DATE - 1 year. Data step to produce Scenario A sample data (original): data insurance_data; infile datalines dlm=',' dsd; format END_SER_EFFECTIVE_DATE END_SER_END_DATE POLICE_EFFECTIVE_DATE POLICE_EXPIRY_DATE ddmmyy10.; input POLICE_ID $ END_ID END_SER_EFFECTIVE_DATE :ddmmyy10. END_SER_END_DATE :ddmmyy10. POLICE_EFFECTIVE_DATE :ddmmyy10. POLICE_EXPIRY_DATE :ddmmyy10.; datalines; AA,0,01/01/2024,31/12/2024,01/01/2024,31/12/2024 AA,1,01/02/2024,31/12/2024,01/01/2024,31/12/2024 AA,2,01/01/2025,31/01/2025,01/01/2024,31/12/2024 ; run;     Scenario B (Shifted Period) Originally         END_ID END_SER_EFFECTIVE_DATE END_SER_END_DATE POLICE_EFFECTIVE_DATE POLICE_EXPIRY_DATE 0 1/1/2024 31/12/2024 1/1/2024 31/12/2024 1 15/2/2024 31/12/2024 1/1/2024 31/12/2024 2 1/2/2024 31/1/2025 1/1/2024 31/12/2024   It should be transformed into: END_ID END_SER_EFFECTIVE_DATE END_SER_END_DATE POLICE_EFFECTIVE_DATE POLICE_EXPIRY_DATE 0 1/2/2024 14/2/2024 1/2/2024 31/1/2025 1 15/2/2024 31/1/2025 1/2/2024 31/1/2025 For this scenario, END_SER_EFFECTIVE_DATE of the final row of END_ID will become the new END_SER_EFFECTIVE_DATE for the first nearest date to 1/2/2024 and new POLICE_EFFECTIVE_DATE for the same POLICE ID of all END_ID.  Like wise, the END_SER_END_DATE in the final END_ID will become the new END_SER_END_DATE for the END_ID before the final END_ID (which in this example is END_ID = 1) and new POLICE_EXPIRY_DATE for the same POLICE ID of all END_ID.  Lastly, remove the final END_ID. Data step to produce Scenario B sample data (original): data insurance_data; infile datalines dlm=',' dsd; format END_SER_EFFECTIVE_DATE END_SER_END_DATE POLICE_EFFECTIVE_DATE POLICE_EXPIRY_DATE ddmmyy10.; input POLICE_ID $ END_ID END_SER_EFFECTIVE_DATE :ddmmyy10. END_SER_END_DATE :ddmmyy10. POLICE_EFFECTIVE_DATE :ddmmyy10. POLICE_EXPIRY_DATE :ddmmyy10.; datalines; AA,0,01/01/2024,31/12/2024,01/01/2024,31/12/2024 AA,1,15/02/2024,31/12/2024,01/01/2024,31/12/2024 AA,2,01/02/2024,31/01/2025,01/01/2024,31/12/2024 ; run; I hope both scenarios are clear. Feel free to ask anything as I understand the logic may not be simple and that more illustrations can be provided if you need more info.     ... View more

In this post I want to examine the use case of needing to authenticate a service account into a SAS Viya environment. Specifically, we’ll examine how an external process like a CI/CD pipeline might authenticate a non-personal service account to the SAS Viya environment to be able to run code in that environment. ... View more