About sascodequestion

sascodequestion · ‎11-24-2018

Thanks Nik. The issue was coming because the linux servers are having more than 1 NIC cards. Mentioning which one to use in the inventory.ini file fixed the issue.

sascodequestion · ‎11-24-2018

@JuanS_OCS, Did you found any solution for your issue? what sas support suggested? I am also facing the similar issue where the error is written to the identity logs continuously. Thanks in advance.

sascodequestion · ‎11-23-2018

Hello NIk, Yes you were write. In all of my servers /tmp was set to non executable. Changing that to exec fixed the issue. Now after the assessment i went ahead with the deployment and now i am facing the below error. Please take a look. fatal: [deployTarget]: FAILED! => { "changed": true, "cmd": [ "bash", "-c", "source /opt/sas/viya/config/consul.conf && /opt/sas/viya/home/bin/sas-bootstrap-config status leader" ], "delta": "0:00:00.094242", "end": "2018-11-23 06:48:24.463456", "invocation": { "module_args": { "_raw_params": "bash -c 'source /opt/sas/viya/config/consul.conf && /opt/sas/viya/home/bin/sas-bootstrap-config status leader'", "_uses_shell": false, "argv": null, "chdir": null, "creates": null, "executable": null, "removes": null, "stdin": null, "warn": true } }, "msg": "non-zero return code", "rc": 1, "start": "2018-11-23 06:48:24.369214", "stderr": "Get https://localhost:8501/v1/status/leader: dial tcp [::1]:8501: getsockopt: connection refused\nERROR: Unable to determine the address of the Raft leader for the data center in which the Consul agent is running.", "stderr_lines": [ "Get https://localhost:8501/v1/status/leader: dial tcp [::1]:8501: getsockopt: connection refused", "ERROR: Unable to determine the address of the Raft leader for the data center in which the Consul agent is running." ], "stdout": "", "stdout_lines": [] } PLAY RECAP *********************************************************************************************************************************************************************************************************************************** cas-controller : ok=126 changed=26 unreachable=0 failed=0 cas-worker1 : ok=125 changed=22 unreachable=0 failed=0 cas-worker2 : ok=125 changed=22 unreachable=0 failed=0 deployTarget : ok=187 changed=54 unreachable=0 failed=1 localhost : ok=14 changed=1 unreachable=0 failed=0

sascodequestion · ‎11-22-2018

Hi Everyone, At my customer site i am installing VIYA 3.4 on redhat Linux machines. I have completed all pre installation tasks as per the deployment guide. When i am executing the the below command it is failing with the below error. We have 4 machines in the architecture 1 is for micro services, 1-CAS Contoller, 2-CAS Workers. i have created the account "sas" as installer (with same uid and gid in all the machines) account and it has sudo previliges in all the 4 machines and also enabled passwordless ssh. Please let me know if i am missing anything. command :ansible-playbook system-assessment.yml Error: TASK [ensure_install_user : Ensure installation user and group are present] ****************************************************************************************************************************************************************** fatal: [deployTarget]: FAILED! => {"changed": true, "msg": "non-zero return code", "rc": 126, "stderr": "Shared connection to 974760-xxxxxxxxxxxxxxxxx closed.\r\n", "stderr_lines": ["Shared connection to 974760-xxxxxxxxxxxxxxxxxclosed."], "stdout": "/bin/sh: /tmp/.sas.ansible/ansible-tmp-1542907964.41-102175813031644/create_sas_user_group.sh: Permission denied\r\n", "stdout_lines": ["/bin/sh: /tmp/.sas.ansible/ansible-tmp-1542907964.41-102175813031644/create_sas_user_group.sh: Permission denied"]} fatal: [cas-controller]: FAILED! => {"changed": true, "msg": "non-zero return code", "rc": 126, "stderr": "Shared connection to 974762-xxxxxxxxxxxxxxxxx closed.\r\n", "stderr_lines": ["Shared connection to 974762-sasinttst02.incres earch.com closed."], "stdout": "/bin/sh: /tmp/.sas.ansible/ansible-tmp-1542907964.44-267215150093204/create_sas_user_group.sh: Permission denied\r\n", "stdout_lines": ["/bin/sh: /tmp/.sas.ansible/ansible-tmp-1542907964.44-267215150093204/create_sas_user_group.sh: Permission denied"]} fatal: [cas-worker1]: FAILED! => {"changed": true, "msg": "non-zero return code", "rc": 126, "stderr": "Shared connection to 974763-xxxxxxxxxxxxxxxxx closed.\r\n", "stderr_lines": ["Shared connection to 974763-sasinttst03.incresearch.com closed."], "stdout": "/bin/sh: /tmp/.sas.ansible/ansible-tmp-1542907964.48-209654282955594/create_sas_user_group.sh: Permission denied\r\n", "stdout_lines": ["/bin/sh: /tmp/.sas.ansible/ansible-tmp-1542907964.48-209654282955594/create_sas_user_group.sh: Permission denied"]} fatal: [cas-worker2]: FAILED! => {"changed": true, "msg": "non-zero return code", "rc": 126, "stderr": "Shared connection to 974764-xxxxxxxxxxxxxxxxx closed.\r\n", "stderr_lines": ["Shared connection to 974764-sasinttst04.incresearch.com closed."], "stdout": "/bin/sh: /tmp/.sas.ansible/ansible-tmp-1542907964.52-154406900839758/create_sas_user_group.sh: Permission denied\r\n", "stdout_lines": ["/bin/sh: /tmp/.sas.ansible/ansible-tmp-1542907964.52-154406900839758/create_sas_user_group.sh: Permission denied"]}

sascodequestion · ‎03-15-2017

data input; input ID $ period amt; cards; X 201001 10000 X 201004 800 X 201006 200 Y 201101 100 Y 201102 100 Z 201201 . Z 201202 . Z 201203 . ; run;

sascodequestion · ‎02-05-2017

Hi, Thanks for your response. 1.The total number of observations should be devided into 2 groups, which is based on the values of the coulmnD(A1 and A2) 2. The observations should be grouped based on ColumnA,columnB, ColumnC and columnD 3. The Values in the columnD should become new coulmns, for example in the above example we have two different values A1 and A2 so we should get 2 new columns in the output called A1 and A2 3. Column A1 and A2 no need to have same rows. The total number of observation are going to be equal to the higher number of observations in any group. For example if group A1 contains 5 and A2 contains 3, so total number of obs will be equal to 5 and column A2 will have values 0. Hope this is clear

sascodequestion · ‎02-05-2017

Hi Friends, I have a data set like below (input) and need your help in getting the output dataset. data input; input ColumnA $ ColumnB $ ColumnC $ ColumnD$ Value; cards; A B C A1 1 A B C A1 2 A B C A1 3 A B C A1 4 A B C A2 1 A B C A2 2 A B C A2 3 A B C A2 4 ; output: data output; input ColumnA $ ColumnB $ ColumnC $ A1 A2; cards; A B C 1 1 A B C 2 2 A B C 3 3 A B C 4 4 ;

sascodequestion · ‎12-16-2016

Hi Guys, I would like to know if there any specific log which will have the user information with Unsuccesfull attempts. For example I have registered myself in metadata by using User Manager. Now assume that I am trying to access a dashboard in SAS VA, but somehow I don’t have the access to view the dash board. Will this particular transaction is created in any log? Please let me know in case my question is not clear, I will provide some additional information.

sascodequestion · ‎11-28-2016

Hi Guys, I need your suggestion/Help in solving the below error: We are using some kind of logic wchih will synchronize the users from AD and in SMC. When we are executing the logic we are receiving the below error. Have you faced anytime this kind of issue. Please help. MLOGIC(EXECUTE_SYNC.EXEC_MDUCHGLB.MDUCHGLB): %IF condition (%symexist(_mduchglb_timer_)) is FALSE MPRINT(EXECUTE_SYNC.EXEC_MDUCHGLB.MDUCHGLB): proc metadata in=_outxml out=_respons header=FULL; MPRINT(EXECUTE_SYNC.EXEC_MDUCHGLB.MDUCHGLB): run; ERROR: Expected white space before the attribute. NOTE: PROCEDURE METADATA used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

sascodequestion · ‎09-14-2016

Does the real data set actually contain many P1 records, with a different product for each? ANs : Yes Does the variable PRODUCT actually have a nonmissing value on the P1 record? (If it doesn't, could it be added?) ANs: For the P1 record , Product is the last non missing value For the P2 record, Pl1 is the last non Missing value and for P3-Pl2.

sascodequestion · ‎09-14-2016

Data Specifications: I have three Different levels P1, P2 and P3 for each Product. The relation between them is P3 is a level under P2 and P2 is a level under P1. There will be only one row for P1, but there may multiple rows for P2 and P3. Also there will be a status Value (either A,B or C) always for Level-P3. And for P1 and P2 it will be empty. So my requirement here is if All P3’s Have a status called “A” then I should get the same status for my P2. Now if all P2’s has the same status then my P1 also should get same status. If all of my P3’s under a specific P2 are having 2 different statuses then I should get a 4th status called D for my P2, and if all of my P2 have two different status I should get status D for my P1. data Have; input P_Level$ Product$ PL1$ PL2$ B_Flag Status$; infile cards missover; cards; P1 X . P2 X PL11 . P3 X PL11 PL21 1 A P3 X PL11 PL22 1 A P3 X PL11 PL23 1 A P2 X PL12 . P3 X PL12 PL21 1 A P3 X PL12 PL22 1 A P3 X PL12 PL23 1 A P2 X PL13 . P3 X PL13 PL21 1 A P3 X PL13 PL22 1 A P3 X PL13 PL23 1 A P1 Y . P2 Y PL11 . P3 Y PL11 PL21 1 A P3 Y PL11 PL22 1 B P3 Y PL11 PL23 1 A P2 Y PL12 . P3 Y PL12 PL21 1 A P3 Y PL12 PL22 1 A P3 Y PL12 PL23 1 A P2 Y PL13 . P3 Y PL13 PL21 1 A P3 Y PL13 PL22 1 A P3 Y PL13 PL23 1 C ; data Want; input P_Level$ Product$ PL1$ PL2$ B_Flag Status$; infile cards missover; cards; P1 X . . . A P2 X PL11 . . A P3 X PL11 PL21 1 A P3 X PL11 PL22 1 A P3 X PL11 PL23 1 A P2 X PL12 . . A P3 X PL12 PL21 1 A P3 X PL12 PL22 1 A P3 X PL12 PL23 1 A P2 X PL13 . . A P3 X PL13 PL21 1 A P3 X PL13 PL22 1 A P3 X PL13 PL23 1 A P1 Y . . . D P2 Y PL11 . . D P3 Y PL11 PL21 1 A P3 Y PL11 PL22 1 B P3 Y PL11 PL23 1 A P2 Y PL12 . . A P3 Y PL12 PL21 1 A P3 Y PL12 PL22 1 A P3 Y PL12 PL23 1 A P2 Y PL13 . . D P3 Y PL13 PL21 1 A P3 Y PL13 PL22 1 A P3 Y PL13 PL23 1 C ;

sascodequestion · ‎09-09-2016

Hello Ksharp, Your solutions fits exactly as i expected. Only thing is i have some problem with catx function. when i am using fpr morethan 5 qty variables i am getting below warnign generated and the output also not as expected. WARNING: In a call to the CATT function, the buffer allocated for the result was not long enough to contain the concatenation of all the arguments. The correct result would contain 219 characters, but the actual result might either be truncated to 200 character(s) or be completely blank, depending on the calling environment. The following note indicates the left-most argument that caused truncation

sascodequestion · ‎09-09-2016

please check the latest file uploaded

sascodequestion · ‎09-09-2016

Hi Friends, I have requirement for transposing the data from Rows to columns. Please find the attched excel sheet for your reference. Input sheet is the data can be used for input and output data is what i am expecting. Please help.

sascodequestion · ‎09-07-2016

Hi, What do mean by "below level"? Are P2 and P3 below level P1 ANs: Yes For level P1 would you sum all QTY1 and QTY2 from all levels where status = "Y" ? ANs : Yes For level P2 is summing QTY1 and QTY2 from level P3 only where status = 'Y" or sum from both P2 and P3 levels ? ANs: level P3 only where status = 'Y" .

Online Status	Offline
Date Last Visited	‎12-25-2018 09:07 AM

Re: SAS VIya 3.4 Preinstallation task is failing

Re: SAS Viya 3.2 LDAP for SAS Logon

Re: SAS VIya 3.4 Preinstallation task is failing

SAS VIya 3.4 Preinstallation task is failing

missing values

Re: Transpose

Transpose

SAS VA Log

Issue in Proc Metadata

Re: Inheritence

Re: SAS VIya 3.4 Preinstallation task is failing

Re: SAS Viya 3.2 LDAP for SAS Logon

Re: SAS VIya 3.4 Preinstallation task is failing

SAS VIya 3.4 Preinstallation task is failing

missing values

Re: Transpose

Transpose

SAS VA Log

Issue in Proc Metadata

Re: Inheritence

Inheritence

Re: Transpose

Re: Transpose

Transpose

Re: SAS Code fix