I have to read a csv file and produce sas dataset When I am trying to read it ,single quote is behaving similar to double quote and all the data in other fields  after single quote is read as one value. How can I fix it? Please dont ask me why data in a field  has only single quote. It is some encrypted field. I cannot alter source data in any way   Sample code and data: data test; infile inf delimiter = '|' missover dsd lrecl=32767 firstobs=2; followed by informat format and input statements ;   Input csv file has data like this |'|2023-12-12|30|40||||||DENG| Now output dataset is taking all the above values in single field "crys_id_local" instead of multiple fields. sample output crys_id_local ============ |2023-12-12|30|40||||||DENG|       ... View more

Hello SAS users,   I was sent a SAS data file that I want to open. The issue is that, when I save the file into a folder on my PC and then create a SAS library that points to this folder, SAS cannot "see" this file, the library seems empty. The extension of the file is .sas7bdat, which suggests a regular file. However, when I right clink on the file it says that it opens with "SAS Enterprise Guide 6.1", and I am not sure what this is. I want to save this file as a regular SAS file that I can access. How can I do this? I am using SAS 9.4. Thank you Costas ... View more

I am creating indicator variables for character variables with a dataset imported from excel. In this dataset there are multiple misspellings, extra spaces, etc. so I copied and pasted each value of the variable from a PROC FREQ to get something like the below:      IF oldvar='oldvaluex' OR IF oldvar='olddvaluex' OR IF oldvar='oldvaluex ' ...etc. then newvar=0; ELSE if oldvar='oldvaluey' OR IF oldvar='old valuey' OR IF oldvar=' oldvaluey '... then newvar=1; ELSE newvar='.';     In comparing oldvar with newvar using PROC FREQ I noticed some variations of 'oldvar' were being coded as missing. In searching through these forums I found that it was likely a spacing problem and by using oldvar=compress(oldvar,,'C') prior to creating my indicator variable, these values were now appropriately coded to newvar.    However, I am now working on another variable which is still producing missing values after using oldvar2=compress (oldvar2,,'C') and also attempting oldvar2= Compress(oldvar2,'0D0A'x).    Any ideas on what else I could try?  ... View more

Error from server (BadRequest): error when creating "site.yaml": admission webhook "validate.nginx.ingress.kubernetes.io" denied the request: nginx.ingress.kubernetes.io/configuration-snippet annotation cannot be used. Snippet directives are disabled by the Ingress administrator Following the sas viya : SAS Help Center: Deploy the Software for configuring kustomization.yaml file referred by sas doc and again encountered with same error. And how to correctly configure the kustomization.yaml file configMapGenerator: parameter. ... View more

Join our upcoming live administration workshop on SAS Viya! If you are looking for the Viya 3.5 workshop, stay tuned for registration information for our next administration workshop.   Americas: September 24th, 2024 - 10am to 2pm EST * Registration for this event is now closed   EMEA: October 1st, 2024 - 9am to 1pm GMT +1 * Registration for this event is now closed   APAC: October 3rd, 2024 - 9am to 1pm IST [India] * Registration for this event is now closed   This workshop is open to all customers, geared towards administrators. It is free and virtual and will be recorded. Please note these workshops will be delivered in English. If you are unable to attend but would still like access to the information, please register to get access to the recording and follow-up materials. You will be able to create or log into your SAS profile. All registrants will be sent the meeting links within a few days after registering. Registration closes 2 business days before the event.    This workshop introduces administrators to SAS Viya platform administration. This workshop series is based on SAS Customer Success hints and tips, as well as our in-depth SAS Education courses. We’ll touch on reoccurring duties that an administrator needs to know, introduce the components that make up the platform, and how to support and maintain it.     Learn How To   Compare the differences between SAS Viya and prior versions  Identify the tasks that are expected as a SAS Viya platform administrator   Identify the tasks that are performed by a Kubernetes administrator   Explain the benefits of Kubernetes as the underlying SAS Viya architecture, and learn some Kubernetes essentials  Identify the components of the SAS Viya platform   Describe security in the SAS Viya platform   Understand various administrative tools and interfaces available to use as an administrator   Identity options for monitoring the SAS platform    Who should attend   Administrators who support a SAS Viya platform    SAS Products Covered   SAS Viya     Prerequisites   There are no formal prerequisites for this workshop, but prior administration experience is helpful.     Event Agenda   What is SAS Viya 4?  SAS Platform Version Comparisons   SAS Viya Platform Architecture   Kubernetes Essentials   Workload Classes   Operating SAS Viya Servers and Services   Introduction to User Management   Authentication   Security Overview: General Authorization   Security Overview: CAS Authorization   Migration Overview   SAS Administration Tasks   SAS Administration Roles and Tools   Tour of SAS Environment Manager   Observability   Workload Management  ... View more