You need to get an oauth token before you can create a client. This request is failing because you are not providing an authorization header. This blog explains the process well, you are performing step 2 there without having performed step 1. https://blogs.sas.com/content/sgf/2023/02/07/authentication-to-sas-viya/
... View more
@SatishR Instead of custom code you could also use the BETWEEN operator from your dropdown list to generate the following where expression:
datetime between intnx('dtday',datetime(),-1,'b') and intnx('dtday',datetime(),-1,'e')
... View more
If the target does not support the data type, you need to modify the source data.
Either a temporary solution that preserves the current data: create a view and upload it if that's supported,
or a permanent solution: round the values in the source table.
You might be able to compute a new variable on the fly, I've never tried that (options COMPPGM and COMPVARS, see here).
... View more
In the code provided you are loading from a SAS library (load data=). If you do it in the visual interface, you are loading from the caslib physical level (in CAS called file).
So I would change the code similar to this:
proc casutil;
droptable incaslib="casuser" casdata="sugus_citiday" quiet;
run;
load
incaslib="casuser" casdata="SUGUS_CITIDAY.sashdat"
outcaslib="casuser" casout="sugus_citiday"
promote
;
run;
quit;
You will need to adapt it to your case: caslib name, file to load, name of CAS table. Please note for the casdata= option the file name is case sensitive. You can use this code to see all the files in a caslib:
proc casutil;
list files incaslib="casuser";
run;
quit;
... View more
@SatishR You normally mark the answer that was most helpful to you as solution and not your reply.
This way the actual solution will also appear right after your initial question - which is really helpful if there is a long discussion. Plus you give credit to the one who provide the solution.
... View more
@SASJedi Thanks for reply... I followed steps mentioned by you. I am using SAS VIYA V.03.05. Below code able to establish the cas session and load and unload the table from caslib created. LIBNAME test123 ODBC NOPROMPT="dsn=XXXXXXXXX;Trusted_Connection=yes" SCHEMA=DBO ; cas casauto sessopts=(caslib="test123"); /*To Unload the Data*/ PROC CASUTIL; droptable CASDATA="Class_test" INCASLIB="test123"; QUIT; /*To load the Data*/ proc casutil; load data=test123.Class_test promote; /* 2 */ contents casdata="Class_test"; run;
... View more
