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