Recently in the SAS Community Library: Your often contains the information you need, but not sequenced in the order required for processing. @SASJedi shows you how to properly sequence data so you can compare the data in one table to the data in another, conduct merges or joins and more.
Hi, over the weekend we did some OS security updates where our Viya install resides (linux environment). After patching was complete, the services did not fully restart. Basic troubleshooting of bringing the services down and back up led to a majority of them being "down" or "not ready", so we rolled back to a VSphere snapshot taken about 16~ hours before (prior to any changes taking place). Reviewing logs, found some certificate errors. 2024-06-16 20:48:49.144 ERROR 16999 --- [ main] c.s.c.rest.boot.vault.CertificateUtil : service [VAULT_CERTIFICATE_REQUEST_ERROR] Vault PKI back end failed to issue certificate. 2024-06-16 20:47:29.064 INFO 16999 --- [ main] c.s.c.rest.boot.vault.CertificateUtil : service [VAULT_CERTIFICATE_REQUEST] Requesting SSL certificate from Vault PKI back end for: cawina06.cyphersystems.com 2024-06-16 20:47:29.079 WARN 16999 --- [ main] c.s.c.rest.boot.vault.CertificateUtil : service Encountered exception issuing certificate from Vault. org.springframework.vault.VaultException: Status 400: cannot satisfy request, as TTL is beyond the expiration of the CA certificate We are considering running the playbook renew-security-artifacts.yml but we are unsure of what the side effects of this would be and if we could make matters worse doing so. -Eric
... View more
Hello, With this syntax: proc sgplot data=plot ;
vbox value / category=DV group=genre ;
run; SGPLOT produces a VBOX with different colors for the two groups defined in GROUP= See graphs below. Instead, I would like the two levels of groups (liteary and popular) to have different patterns (for instance, small dots for one and small x for the other). I have been looking into various options with ATTRMAP, but I do not seem to be able to get it. Suggestions?
... View more
I have data which has already been aggregated like this:
Category
Groups
People
A
23
235
B
45
754
C
12
89
And I want something like this (prefer Proc Report for the bells and whistles)
Category
Groups
Groups Percent
People
People Percent
A
23
28.8%
235
21.8%
B
45
56.3%
754
69.9%
C
12
15.0%
89
8.3%
Total
80
100.0%
1078
100.0%
All the examples I can find online seem to use dis-aggregated data.
... View more
I am using the SAS elarning courses in my institution course, and assigning as homework the Virtual lab-based demos and/or activities. I want the students to be able to save their final product work of an activity/demo and upload it in the dropbox of the brightspace D2L LMS.
Are there options that enable the user to do so? if so, what is the best/easiest option? Thanks.
Kaddour
... View more
Hi, I am using this code for pulling the birthdate >17years FLOOR(intck('MONTH',datepart(pt.BIRTH_DATE), date())/12)> 17 But the person who has DOB of 06/29/2006 is considered as 18years and pulling that person. i tried not to use FLOOR and it still gives me the same 18years. Can I fix this.
... View more