Home

HeidiDT

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!

HeidiDT

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.

JHE

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

hhchenfx

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;

Nyac122

i am trying to recode my district variables so i can use proc reg and its not working . WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed data flgrads; input districts $ 1-9 year $ 10-20 percentage; datalines; alachua 2016-2017 82.7 alachua 2017-2018 88 alachua 2018-2019 88.5 alachua 2019-2020 90.4 alachua 2020-2021 86.6 baker 2016-2017 81 baker 2017-2018 75.5 baker 2018-2019 78.8 baker 2019-2020 84.5 baker 2020-2021 85.7 bay 2016-2017 78.0 bay 2017-2018 81.1 bay 2018-2019 82.5 bay 2019-2020 88.5 bay 2020-2021 90.2 bradford 2016-2017 78.9 bradford 2017-2018 89 bradford 2018-2019 87.7 bradford 2019-2020 98.2 bradford 2020-2021 85 brevard 2016-2017 85.9 brevard 2017-2018 88.1 brevard 2018-2019 88.3 brevard 2019-2020 90.3 brevard 2020-2021 90.6 broward 2016-2017 81 broward 2017-2018 84.3 broward 2018-2019 86.2 broward 2019-2020 89.4 broward 2020-2021 89.1 calhoun 2016-2017 80.9 calhoun 2017-2018 86.9 calhoun 2018-2019 87.9 calhoun 2019-2020 89.9 calhoun 2020-2021 93.1 Charlotte 2016-2017 81.0 Charlotte 2017-2018 87.6 Charlotte 2018-2019 86.4 Charlotte 2019-2020 90.4 Charlotte 2020-2021 90.9 Citrus 2016-2017 78.9 Citrus 2017-2018 84.1 Citrus 2018-2019 86.0 Citrus 2019-2020 87.1 Citrus 2020-2021 88.1 Clay 2016-2017 88.4 Clay 2017-2018 91.1 Clay 2018-2019 91.9 Clay 2019-2020 93.4 Clay 2020-2021 92.7 Collier 2016-2017 88.2 Collier 2017-2018 91.9 Collier 2018-2019 91.9 Collier 2019-2020 92.2 Collier 2020-2021 92.7 Columbia 2016-2017 70.7 Columbia 2017-2018 88.4 Columbia 2018-2019 92.4 Columbia 2019-2020 95.4 Columbia 2020-2021 95.6 MiamiDade 2016-2017 80.7 MiamiDade 2017-2018 85.4 MiamiDade 2018-2019 85.6 MiamiDade 2019-2020 89.6 MiamiDade 2020-2021 90.1 DeSoto 2016-2017 63.8 DeSoto 2017-2018 60.9 DeSoto 2018-2019 71.3 DeSoto 2019-2020 84.6 DeSoto 2020-2021 82 Dixie 2016-2017 89.5 Dixie 2017-2018 96.9 Dixie 2018-2019 90.6 Dixie 2019-2020 89.8 Dixie 2020-2021 84 Duval 2016-2017 80.8 Duval 2017-2018 85.1 Duval 2018-2019 86.5 Duval 2019-2020 90.2 Duval 2020-2021 89.6 ; proc print; run; data flgrads2; set flgrads; Alachua= (district= 0); Baker= (districts= 1); Bay = (districts= 2); Bradford= (districts= 3); Brevard= (districts= 4); Broward= (districts= 5); Calhoun= (districts= 6); Charlotte= (districts= 7); Citrus= (districts= 8); Clay= (districts= 9); Collier= (districts= 10); Columbia= (districts= 11); MiamiDade= (districts= 12); DeSoto= (districts= 13); Dixie= (districts= 14); Duval= (districts= 15); run;