Goodmorning everyone. Maybe I didn't understand the mechanism of multi threads. With this simple test code: cas mySession sessopts = (caslib = casuser timeout = 1800 locale = "en_US"); libname mycas cas caslib = casuser; data mycas.ds1; x=2; put "The # of Threads is " _nthreads_; /* 3 */ run; I get 12 lines instead of 1 and the following message in the log: NOTES: Running DATA step in Cloud Analytic Services. Processed intro on _THREADID_ = 11 _NTHREADS_ = 12 Processed intro on _THREADID_ = 4 _NTHREADS_ = 12 Processed intro on _THREADID_ = 2 _NTHREADS_ = 12 Processed intro on _THREADID_ = 5 _NTHREADS_ = 12 Processed intro on _THREADID_ = 3 _NTHREADS_ = 12 Processed intro on _THREADID_ = 1 _NTHREADS_ = 12 Processed intro on _THREADID_ = 12 _NTHREADS_ = 12 Processed intro on _THREADID_ = 7 _NTHREADS_ = 12 Processed intro on _THREADID_ = 10 _NTHREADS_ = 12 Processed intro on _THREADID_ = 8 _NTHREADS_ = 12 Processed intro on _THREADID_ = 9 _NTHREADS_ = 12 Processed intro on _THREADID_ = 6 _NTHREADS_ = 12 NOTE: The ds1 table in caslib CASUSER (sasdemo) has 12 observations and 1 variables. NOTES: DATA statement used (total processing time): real time 0.02 seconds cpu time 0.01 seconds   Why? What is the correct way to load a table into a caslib? Thank you ... View more

Goodmorning everyone. I'm new to SAS Viya, maybe I ask a trivial thing but I can't find a solution. I would simply like to upload a sas dataset from my pc locally. In this video: https://video.sas.com/detail/video/5334369476001/understanding-caslibs-and-loading-data-in-sas%C2%AE-viya%E2%84%A2 a sas library is set up very simply like this: libname orion "c\mydata"; However from sas viya if I set up a library by putting a local path I get the answer that the library does not exist: ... View more

with the NOSYNTAXCHECK options you should avoid the "ERROR:" in the log, but in this example code, inserting the wrong libname engine (basex instead of base), SAS log still returns error. how to do?   options NOSYNTAXCHECK; libname tmp basex "path"; ... View more

I can not understand why the next proc sql update values missing "var1" at c1 = 2 and c2 = 2 (update key). The resulting value is missing. I expected it to remain unchanged at 20   data A; input c1 c2 var1 var2; datalines; 1 1 12 32 1 2 32 21 2 1 12 98 2 2 20 30 2 3 11 11 3 1 21 22 4 1 31 32 2 4 22 22 6 1 77 77 ; data tmp; input c1 c2 var1 var2; datalines; 1 1 999 999 1 2 888 999 2 1 999 999 ; proc sql; update a set var1=(select var1 from tmp as b where a.c1=b.c1 and a.c2=b.c2) where a.c1 in (select c1 from tmp) and a.c2 in (select c2 from tmp) ; quit; ... View more

I do not understand why the result of the following full join triples datetime1 field:   data tab1; input datetime1:datetime16. class1:$70. var1:8.3 ; datalines; 17DEC15:00:00:00 XBC1_01 0 run; data tab2; informat datetime1 datetime16.; input datetime1:datetime16. class1:$70. var1:8.3; datalines; 17DEC15:00:00:00 XBC1_06 . 17DEC15:00:00:00 XBC1_07 . 17DEC15:00:00:00 XBC1_09 . 06JAN16:20:50:00 XBC1_06 1323.510288 06JAN16:20:50:00 XBC1_09 1242.7005635 06JAN16:20:50:00 XBC1_07 1476.8484275 run; proc sql; create table tab_full as select distinct coalesce(a.datetime1, b.datetime1, c.datetime1, d.datetime1)as dt1 format=datetime18. , a.var1 as XBC1_01, b.var1 as XBC1_06, c.var1 as XBC1_07, d.var1 as XBC1_09 from tab1 as a full join tab2 (where=( class1='XBC1_06')) as b on (a.datetime1=b.datetime1) full join tab2 (where=( class1='XBC1_07')) as c on (a.datetime1=c.datetime1) full join tab2 (where=( class1='XBC1_09')) as d on (a.datetime1=d.datetime1) order by dt1; quit; I would expect the following result table "tab_full":   dt1 XBC1_01 XBC1_06 XBC1_07 XBC1_09 1 17DEC15:00:00:00 0 . . . 2 06JAN16:20:50:00 . 1323.510288 1476.8484275 1242.7005635     And not the following:   dt1 XBC1_01 XBC1_06 XBC1_07 XBC1_09 1 17DEC15:00:00:00 0 . . . 2 06JAN16:20:50:00 . . . 1242.7005635 3 06JAN16:20:50:00 . . 1476.8484275 . 4 06JAN16:20:50:00 . 1323.510288 . . ... View more