Accessing SAS Viya, or: How I Learned to Stop Worrying and Love Kubernetes
Recent Library Posts
@fsmunoz reveals how inbound communication in Kubernetes works, using SAS Studio as the starting point, and provides a step-by-step overview of what happens at each layer.
Hi,
I have a macro variable from proc sql select into:DATA_LOAD_DT, which is "20OCT2022:19:41:27.933" in the result.
SYMBOLGEN: Macro variable DATA_LOAD_DT resolves to 20OCT2022:19:41:27.933
How can I convert this Marcro variable DATA_LOAD_DT into "20OCT2022"?
I have tried:
%let dl_date=%sysfunc(put(datepart("&DATA_LOAD_DT."D), date.9.);
%put dl_date;
error: The PUT function referenced in the %SYSFUNC or %QSYSFUNC macro function is not found.
Please advise.
Thank you!
... View more
Hi All I need to schedule my Dataflux jobs to run via CA7. I created a small test process job, with a data job embedded. I then created a shell script to call the process job and created a JCL on the mainframe to run this shell script. The process job gets kicked off, but it is unable to open the embedded data job. I am attaching the log. Please could anyone help? Many thanks!
... View more
Hi All I am ding a load of 183m rows from Dataflux into a SQL Server table. The current job is just a normal insert, but I am playing around with the bulk row count option to see if I can't speed it up (it ran for 42 hours). However, I am getting an error with a datetimeoffset field. The field seems to be a character value in Dataflux, so I would have thought it would be coerced into a datetime value, but I get this error: [4:DEST_ODBC:Consolidated Customer Matchcode] Data Access Plugin - Max. ODBC error count (49999) exceeded. Last error: [22018] [DataFlux][ODBC SQL Server Wire Protocol driver]Invalid character value. Error in parameter 11. (0);[HY008] [DataFlux][ODBC SQL Server Wire Protocol driver]Operation cancelled. Error in parameter 116. (0). I then created a new date variable and converted the character value to a date field (date DOB DOB=todate(left(DateOfBirth,10)), and mapped that to the datetimeoffset field, but I am still getting the same error. Has anyone had any experience with this, and can offer some suggestions, please? To complicate matters further, it runs fine locally but gives that error when running on the server, so I assume it is using different ODBC drivers.
... View more
I need count monthly disenrollment for 2022.
Data table :
MEMBER_ID
ENROLLMENT
DISENROLLEMNT
A0001
2/1/2021
3/1/2021
A0001
5/29/2021
6/24/2021
A0001
7/1/2021
8/1/2021
B0001
6/3/2021
8/2/2021
B0001
10/1/2021
11/1/2021
How do I have the monthly disenroll , and count by member_ID: as following
1. Member_ID, Disenroll_Month_Flg
A0001 202104
A0001 202107
A0001 202209
B0001 202109
B0001 202112
2. Summary: disenroll by month
month count:
202104 1
202107 1
202109 2
202112 1
3. Summery disenroll by member:
Member Count
A0001 3
B0001 2
... View more
Hi,
I want to put hour and minute of the time 20 second before current time into macro variable.
The code below might convey my idea better.
Can you please help?
Thanks,
HHC
%let now=%sysfunc(time() MINUS 20 SECOND);
%let hh=%sysfunc(hour(&now),z2.);
%let mm=%sysfunc(minute(&now),z2.);
%put &hh &mm;
... View more