cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
aloou
‎04-18-2023
  • 54 Posts
  • 3 Likes Given
  • 0 Solutions
  • 2 Likes Received

Data existence in a table

by Obsidian | Level 7 in SAS Programming
‎04-19-2022 05:19 AM
‎04-19-2022 05:19 AM
hello everyone, i have a column containing ID , and a big table containing ID too. How can i check if a list of ID exist or not in the big table, using sas viya.   Many thanks ... View more

Create table like

by Obsidian | Level 7 in SAS Programming
‎03-28-2022 05:45 AM
1 Like
‎03-28-2022 05:45 AM
1 Like
Hello, i would like to create a table using proc fedsql but i can not find how. same like this procedure proc sql; create table casuser.x like biblio.y; quit;   thank you ... View more

Merge tables in CAS

by Obsidian | Level 7 in SAS Programming
‎03-08-2022 11:23 AM
‎03-08-2022 11:23 AM
Hello , When i use a DATA step to merge SAS ®  Cloud Analytic Services (CAS) tables with a BY statement, the following errors appear : ERROR: The first BY variable, variable-name, must have the same format with all input data sets the BY statement applies to when using DATA step in Cloud Analytic Services. ERROR: The action stopped due to errors.   My variable is alphanumeric, do you know how to fix this ?   thank you  ... View more

table.deleterows

by Obsidian | Level 7 in SAS Programming
‎03-08-2022 05:32 AM
1 Like
‎03-08-2022 05:32 AM
1 Like
Hello everyone, i am having a problem with this proc cas , the where statement is not accepted and gets me an error. do you have ideas ?   thanks   proc cas; table.deleterows / table={name="TEST" caslib="mine" where='ID in (select id from triangle)'}; run; ... View more

change data type in CAS

by Obsidian | Level 7 in SAS Programming
‎03-01-2022 11:00 AM
‎03-01-2022 11:00 AM
hello, i have a column with type  numeric , how can i change the type to character or alphanumeric ?   Thank you ... View more

Dynamic prompt SAS VIYA

by Obsidian | Level 7 in SAS Programming
‎03-01-2022 05:30 AM
‎03-01-2022 05:30 AM
Hello, I need to develop a dynamic prompt that offers this :  show whats in a specific table. select a line. Modify the line. Do you have any example codes that might help ?? Many thanks ... View more

Re: SAS connector to hadoop

by Obsidian | Level 7 in Administration and Deployment
‎02-22-2022 05:06 AM
‎02-22-2022 05:06 AM
yes it works. but it loads data in a serial mode (which takes a lot of time for large data). ... View more

Re: SAS connector to hadoop

by Obsidian | Level 7 in Administration and Deployment
‎02-21-2022 05:55 AM
‎02-21-2022 05:55 AM
in a proc cas;  i am using the option DataTranfermode='parallel'   this is how i got that error.   thank you ... View more

SAS connector to hadoop

by Obsidian | Level 7 in Administration and Deployment
‎02-17-2022 09:02 AM
‎02-17-2022 09:02 AM
hello everyone, i am trying to lunch a parallel load from hive to sas but i receive an error :   ERROR: java.lang.RuntimeException: org.xml.sax.SAXParseException; systemId: file:/opt/sas/Hadoop_INT/sitexmls/core-site.xml; lineNumber: 190; columnNumber: 7; The element type "value" must be terminated by the matching end-tag "</value>". ERROR: java.lang.RuntimeException: org.xml.sax.SAXParseException; systemId: file:/opt/sas/Hadoop_INT/sitexmls/core-site.xml; lineNumber: 190; columnNumber: 7; The element type "value" must be terminated by the matching end-tag "</value>".       What should i d o ?   Thanks   ... View more

Merge or join two tables on CAS

by Obsidian | Level 7 in SAS Programming
‎02-15-2022 11:25 AM
‎02-15-2022 11:25 AM
Hello, I have two tables, they have in common only one column which contain data like this 0051A 8547V 1275N 9201M How can i merge or join the two tables (kind of inner join). P.S : developping on SAS VIYA   Thank you ... View more

Re: PROC TABULATE OUTPUT

by Obsidian | Level 7 in New SAS User
‎12-06-2019 08:28 AM
‎12-06-2019 08:28 AM
Hello, i have tried what you have proposed but as an output i keep getting the same as this: ... View more

PROC TABULATE OUTPUT

by Obsidian | Level 7 in New SAS User
‎12-06-2019 08:17 AM
‎12-06-2019 08:17 AM
Hello everyone, i am running a proc tabulate on a table as follows: PROC TABULATE DATA=la_rec.BIL_CTX_REF_HEBDO out=work.tabs ;          CLASS _CHARACTER_ /        ORDER=UNFORMATTED MISSING;         TABLE _CHARACTER_,  N PctN ; ;  RUN; i get as a result i get an outpu as follows: Howevere, i want to get the output well organized as follows :   i will be so grateful for your help. ... View more

Re: Sas cache locator service

by Obsidian | Level 7 in Administration and Deployment
‎11-22-2019 03:32 AM
‎11-22-2019 03:32 AM
The gemfirecommand.log says : Could not bind locator to null [41415] ... View more

Sas cache locator service

by Obsidian | Level 7 in Administration and Deployment
‎11-21-2019 11:34 AM
‎11-21-2019 11:34 AM
Hello everyone, Sas cache locator service ins_41415 is not up and i can not start it. I have stopped sas.servers.mid and then started it now this cache locator is not started. Help please ... View more

Delete from tables

by Obsidian | Level 7 in New SAS User
‎11-15-2019 08:19 AM
‎11-15-2019 08:19 AM
Hello everyone,   I have a table where i want to keep only three years of data. what i want to do is to delete from the table where (DT_OPER : keep three years). DT_OPER is of type date like 2019/10/01. can you help please. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-18-2023 11:47 AM
Likes given to
Likes from
View All
Quick links