Home

mkiran

Can you guide me the connection setup guide for GoogleBIG Query from SAS9.4 M8 on RHEL?. We do have license to SAS Access Interface to BigQuery, making direct connection using libname statement through credentail file using BigQuery engine is not working even though we have a 443 port enabled from the server.

alepage

Hello, I am running many SAS code in cascade and I have this error: ERROR: You cannot open WORK.FICHIER_IBC_CORR.DATA for output access with member-level control because WORK.FICHIER_IBC_CORR.DATA is in use by you in resource environment IOM ROOT COMP ENV. How to solve this issue. Is it related to my SAS EG config.

sassy_seb

Hello, I am getting the following error messages when trying to merge two datasets. One of the datasets I am getting from a csv file, so maybe the issue could be there? I was trying to specify the length of the PID variable for the redcap_sort dataset from the redcap one, which is the one we got from the csv file. However, I keep getting messages that the variable has multiple lengths and it keeps truncating the data. Any PID after 999 gets shortened. So 1000 and 1001 become 100, 1010 becomes 101, etc. Any help or a nudge in the right direction would be greatly appreciated, thank you so much. Edit: The programming with the csv file already has: data work.redcap; %let _EFIERR_ = 0; infile &csv_file delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1 ; informat pid $500. ; informat pid_ini $500. ; and the code for format: format pid $500. ; It has this for all the variables. I thought the above code would make it so that the variables would have that limit of 500 characters?

monkk

It seems that all the online resources on this topic construct the matrices in such a way that the rightmost one is intended to be applied first. I think it's cool, but I prefer from left to right. Just curious. Is this a matter of personal preference, convention, performance reasons, or something else?

rick_b

Hi, all. My last post (https://communities.sas.com/t5/SAS-Programming/Calculate-How-Prior-Bet-Profits-Losses-Influence-Future-Betting/m-p/928006#M365143) went unsolved (thanks very much to those who gave it a look). I am clarifying here and asking for additional help. Unnecessary columns have been removed and desired calculations are now described within the datalines. Description: When a gambler decides how much to bet, their decision is influenced by their prior wager outcomes (perhaps they start to double down if they have sustained losses, for example), and I am trying to examine how NFL gamblers' prior betting profits/losses influence their next-round-of-betting behavior. I need a rolling sum of the profits/losses from just the last very round of completed NFL events as shown below. data WORK.bets (drop=product_account_id bet_id eleven_digit_account_id net_stake); infile datalines; input product_account_id:$10. bet_id:$15. eleven_digit_account_id:$11. net_stake:3. bet_date:mmddyy10. bet_time:time8. bet_day_of_week:$10. event_date:mmddyy10. event_time:time8. event_day_of_week:$10. bet_profit:5. desired_output:5.; format bet_date mmddyy10. bet_time time8. event_date mmddyy10. event_time time8.; *Note: games (aka 'events') last three hours from start to finish; *Note: there are many gamblers, each with a unique product_account_id, so summing needs to begin anew when a new product_account_id arrives; datalines; 12101170 81758848.516 00012101170 2 10/9/2023 20:29 Monday 10/9/2023 20:16 Monday 2 . 12101170 81758939.516 00012101170 3 10/9/2023 20:30 Monday 10/9/2023 20:16 Monday 2.4 . 12101170 81759255.516 00012101170 2 10/9/2023 20:34 Monday 10/9/2023 20:16 Monday 1.68 . 12101170 81760925.516 00012101170 3 10/9/2023 20:48 Monday 10/9/2023 20:16 Monday 2.61 . 12101170 81764937.516 00012101170 3 10/9/2023 21:26 Monday 10/9/2023 20:16 Monday -3 . 12101170 81768542.516 00012101170 3 10/9/2023 22:03 Monday 10/9/2023 20:16 Monday 2.64 . 12101170 82231252.516 00012101170 3 10/14/2023 14:38 Saturday 10/15/2023 13:01 Sunday 2.73 8.33 *the Monday events have expired and the payouts are now known, desired_output is the sum of the first six rows of bets* 12101170 82231251.516 00012101170 3 10/14/2023 14:38 Saturday 10/15/2023 13:05 Sunday 2.73 8.33 *the last known event outcomes were again last Monday, same calculation* 12101170 82231250.516 00012101170 3 10/14/2023 14:38 Saturday 10/15/2023 13:05 Sunday 2.46 8.33 *same here* 12101170 82231253.516 00012101170 3 10/14/2023 14:38 Saturday 10/15/2023 16:26 Sunday 2.85 8.33 *same here* 12101170 82231254.516 00012101170 3 10/14/2023 14:38 Saturday 10/15/2023 16:27 Sunday -3 8.33 *same here* 12101170 82231345.516 00012101170 3 10/14/2023 14:39 Saturday 10/15/2023 13:05 Sunday 2.46 8.33 *same here* 12101170 82231346.516 00012101170 3 10/14/2023 14:39 Saturday 10/15/2023 13:05 Sunday 2.73 8.33 *same here* 12101170 82231347.516 00012101170 3 10/14/2023 14:39 Saturday 10/15/2023 16:26 Sunday 2.85 8.33 *same here* 12101170 82231348.516 00012101170 3 10/14/2023 14:39 Saturday 10/15/2023 16:27 Sunday -3 8.33 *same here* 12101170 82231466.516 00012101170 3 10/14/2023 14:40 Saturday 10/15/2023 13:05 Sunday 2.73 8.33 *etc....* 12101170 82231465.516 00012101170 3 10/14/2023 14:40 Saturday 10/15/2023 13:05 Sunday 2.46 8.33 12101170 82231467.516 00012101170 3 10/14/2023 14:40 Saturday 10/15/2023 16:26 Sunday 2.85 8.33 12101170 82348229.516 00012101170 3 10/15/2023 7:49 Sunday 10/15/2023 9:35 Sunday -3 8.33 12101170 82348234.516 00012101170 3 10/15/2023 7:49 Sunday 10/15/2023 13:01 Sunday -3 8.33 12101170 82348231.516 00012101170 3 10/15/2023 7:49 Sunday 10/15/2023 13:01 Sunday 2.61 8.33 12101170 82348230.516 00012101170 3 10/15/2023 7:49 Sunday 10/15/2023 13:03 Sunday -3 8.33 12101170 82348233.516 00012101170 3 10/15/2023 7:49 Sunday 10/15/2023 13:04 Sunday 2.55 8.33 12101170 82348235.516 00012101170 3 10/15/2023 7:49 Sunday 10/15/2023 13:05 Sunday 2.94 8.33 12101170 82348232.516 00012101170 3 10/15/2023 7:49 Sunday 10/15/2023 13:05 Sunday 2.73 8.33 12101170 82348267.516 00012101170 3 10/15/2023 7:50 Sunday 10/15/2023 13:01 Sunday 2.61 8.33 12101170 82348270.516 00012101170 3 10/15/2023 7:50 Sunday 10/15/2023 13:01 Sunday -3 8.33 12101170 82348266.516 00012101170 3 10/15/2023 7:50 Sunday 10/15/2023 13:03 Sunday -3 8.33 12101170 82348269.516 00012101170 3 10/15/2023 7:50 Sunday 10/15/2023 13:04 Sunday 2.55 8.33 12101170 82348271.516 00012101170 3 10/15/2023 7:50 Sunday 10/15/2023 13:05 Sunday 2.94 8.33 12101170 82348268.516 00012101170 3 10/15/2023 7:50 Sunday 10/15/2023 13:05 Sunday 2.73 8.33 12101170 82348305.516 00012101170 3 10/15/2023 7:51 Sunday 10/15/2023 13:01 Sunday -3 8.33 12101170 82348307.516 00012101170 3 10/15/2023 7:51 Sunday 10/15/2023 13:01 Sunday 2.85 8.33 12101170 82348308.516 00012101170 3 10/15/2023 7:51 Sunday 10/15/2023 13:03 Sunday -3 8.33 12101170 82348306.516 00012101170 3 10/15/2023 7:51 Sunday 10/15/2023 13:05 Sunday 2.94 8.33 12101170 82348304.516 00012101170 3 10/15/2023 7:51 Sunday 10/15/2023 13:05 Sunday 2.73 8.33 12101170 82439386.516 00012101170 3 10/15/2023 13:14 Sunday 10/15/2023 13:04 Sunday -3 -3 *this bet was placed on Sunday at ~1:00 p.m., the last event in which the gambler experienced a payout began Sunday at 9:35 a.m. and ended Sunday at 12:35 p.m., that bet's profit was -3* 12101170 82439455.516 00012101170 3 10/15/2023 13:14 Sunday 10/15/2023 13:01 Sunday 2.73 -3 *same here* 12101170 82439531.516 00012101170 3 10/15/2023 13:14 Sunday 10/15/2023 13:05 Sunday 2.73 -3 *same here* 12101170 82478787.516 00012101170 3 10/15/2023 16:02 Sunday 10/15/2023 16:06 Sunday 2.46 33.03 *this bet was placed on Sunday at ~4:00 p.m., the most recent profits are from events played on Sunday from ~1:00 to ~4:00, profits are the sum of rows 7-18 plus rows 20-36 (profit from row 19 has already been captured)* 12101170 82478786.516 00012101170 3 10/15/2023 16:02 Sunday 10/15/2023 16:26 Sunday 2.73 33.03 12101170 82478788.516 00012101170 3 10/15/2023 16:02 Sunday 10/15/2023 16:26 Sunday 2.73 33.03 12101170 82478789.516 00012101170 3 10/15/2023 16:02 Sunday 10/15/2023 16:27 Sunday -3 33.03 12101170 82478974.516 00012101170 3 10/15/2023 16:02 Sunday 10/15/2023 16:06 Sunday 2.46 33.03 12101170 82478973.516 00012101170 3 10/15/2023 16:02 Sunday 10/15/2023 16:26 Sunday 2.73 33.03 12101170 82478975.516 00012101170 3 10/15/2023 16:02 Sunday 10/15/2023 16:27 Sunday -3 33.03 12101170 82479827.516 00012101170 6 10/15/2023 16:03 Sunday 10/15/2023 16:26 Sunday 5.46 33.03 12101170 82479826.516 00012101170 6 10/15/2023 16:03 Sunday 10/15/2023 16:27 Sunday -6 33.03 12101170 82482465.516 00012101170 3 10/15/2023 16:07 Sunday 10/15/2023 16:26 Sunday 2.73 33.03 12101170 82493073.516 00012101170 2 10/15/2023 16:34 Sunday 10/15/2023 16:26 Sunday 1.92 33.03 12101170 82550551.516 00012101170 2 10/15/2023 20:57 Sunday 10/15/2023 20:23 Sunday -2 11.22 *this bet was placed on Sunday at ~8:00 p.m., the last profits were from games played earlier that day at 4:00 p.m. (rows 40-50)* 12101170 82553228.516 00012101170 2 10/15/2023 21:23 Sunday 10/15/2023 20:23 Sunday -2 11.22 *same here* 12101170 82555259.516 00012101170 2 10/15/2023 21:44 Sunday 10/15/2023 20:23 Sunday -2 11.22 *same here* 12101170 82646184.516 00012101170 3 10/16/2023 20:25 Monday 10/16/2023 20:16 Monday -3 -6 12101170 82647533.516 00012101170 3 10/16/2023 20:34 Monday 10/16/2023 20:16 Monday -3 -6 12101170 82647545.516 00012101170 6 10/16/2023 20:34 Monday 10/16/2023 20:16 Monday -6 -6 12101170 82899789.516 00012101170 2 10/19/2023 20:23 Thursday 10/19/2023 20:16 Thursday 1.96 -12 12101170 82904693.516 00012101170 3 10/19/2023 20:59 Thursday 10/19/2023 20:16 Thursday 2.64 -12 12101170 82906147.516 00012101170 3 10/19/2023 21:08 Thursday 10/19/2023 20:16 Thursday -3 -12 12101170 83235976.516 00012101170 3 10/22/2023 9:23 Sunday 10/22/2023 13:02 Sunday -3 1.6 12101170 83235974.516 00012101170 3 10/22/2023 9:23 Sunday 10/22/2023 13:03 Sunday -3 1.6 12101170 83236035.516 00012101170 3 10/22/2023 9:24 Sunday 10/22/2023 13:02 Sunday -3 1.6 12101170 83236033.516 00012101170 3 10/22/2023 9:24 Sunday 10/22/2023 13:03 Sunday -3 1.6 12101170 83236190.516 00012101170 3 10/22/2023 9:25 Sunday 10/22/2023 13:02 Sunday -3 1.6 12101170 83237824.516 00012101170 3 10/22/2023 9:36 Sunday 10/22/2023 13:01 Sunday -3 1.6 12101170 83237827.516 00012101170 3 10/22/2023 9:36 Sunday 10/22/2023 13:02 Sunday -3 1.6 12101170 83237823.516 00012101170 3 10/22/2023 9:36 Sunday 10/22/2023 13:03 Sunday -3 1.6 12101170 83237825.516 00012101170 3 10/22/2023 9:36 Sunday 10/22/2023 13:05 Sunday 2.64 1.6 12101170 83237829.516 00012101170 3 10/22/2023 9:36 Sunday 10/22/2023 16:06 Sunday -3 1.6 12101170 83237922.516 00012101170 3 10/22/2023 9:36 Sunday 10/22/2023 13:01 Sunday -3 1.6 12101170 83237924.516 00012101170 3 10/22/2023 9:36 Sunday 10/22/2023 13:02 Sunday -3 1.6 12101170 83237921.516 00012101170 3 10/22/2023 9:36 Sunday 10/22/2023 13:03 Sunday -3 1.6 12101170 83237926.516 00012101170 3 10/22/2023 9:36 Sunday 10/22/2023 16:06 Sunday -3 1.6 12101170 83238000.516 00012101170 3 10/22/2023 9:37 Sunday 10/22/2023 13:01 Sunday -3 1.6 12101170 83238002.516 00012101170 3 10/22/2023 9:37 Sunday 10/22/2023 13:02 Sunday -3 1.6 12101170 83237999.516 00012101170 3 10/22/2023 9:37 Sunday 10/22/2023 13:03 Sunday -3 1.6 12101170 83238004.516 00012101170 3 10/22/2023 9:37 Sunday 10/22/2023 16:06 Sunday -3 1.6 12101170 83238165.516 00012101170 3 10/22/2023 9:38 Sunday 10/22/2023 13:01 Sunday -3 1.6 12101170 83238164.516 00012101170 3 10/22/2023 9:38 Sunday 10/22/2023 13:03 Sunday -3 1.6 12101170 83238170.516 00012101170 3 10/22/2023 9:38 Sunday 10/22/2023 13:03 Sunday -3 1.6 12101170 83238167.516 00012101170 3 10/22/2023 9:38 Sunday 10/22/2023 16:06 Sunday -3 1.6 12101170 83238244.516 00012101170 3 10/22/2023 9:38 Sunday 10/22/2023 13:01 Sunday -3 1.6 12101170 83238249.516 00012101170 3 10/22/2023 9:38 Sunday 10/22/2023 13:03 Sunday -3 1.6 12101170 83238246.516 00012101170 3 10/22/2023 9:38 Sunday 10/22/2023 16:06 Sunday -3 1.6 12101170 83238318.516 00012101170 3 10/22/2023 9:39 Sunday 10/22/2023 13:03 Sunday -3 1.6 12101170 83238315.516 00012101170 3 10/22/2023 9:39 Sunday 10/22/2023 16:06 Sunday -3 1.6 12101170 83263216.516 00012101170 6 10/22/2023 11:14 Sunday 10/22/2023 13:02 Sunday -6 1.6 12101170 83395974.516 00012101170 3 10/22/2023 16:35 Sunday 10/22/2023 16:06 Sunday -3 -63.36 *only events at 1:00 p.m. earlier on this day should be included in the sum (rows 60-87 excluding rows 69,73,77,81,84,86)* 50001170 83395975.52 50001170 3 10/21/2023 16:35 Saturday 10/22/2023 13:06 Sunday -3 . *new gambler* 50001170 83395972.52 50001170 3 10/21/2023 16:35 Saturday 10/22/2023 13:26 Sunday 2.55 . *new gambler* 50001170 83395973.52 50001170 3 10/21/2023 16:35 Saturday 10/22/2023 13:26 Sunday 2.55 . *new gambler* 50001170 83398125.52 50001170 3 10/21/2023 16:44 Saturday 10/22/2023 13:06 Sunday -3 . *new gambler* 50001170 83398126.52 50001170 3 10/21/2023 16:44 Saturday 10/22/2023 13:06 Sunday -3 . *new gambler* 50001170 83398127.52 50001170 3 10/23/2023 16:44 Monday 10/29/2023 16:26 Sunday 2.64 -3.9 *sum of last 5 rows* 50001170 83398128.52 50001170 3 10/23/2023 16:44 Monday 10/29/2023 16:26 Sunday 2.82 -3.9 *same calculation as above row* 50001170 83403470.52 50001170 3 10/23/2023 17:13 Monday 10/29/2023 16:06 Sunday -3 -3.9 *Etc.* 50001170 83403472.52 50001170 3 10/23/2023 17:13 Monday 10/29/2023 16:26 Sunday -3 -3.9 50001170 83408418.52 50001170 3 10/23/2023 17:44 Monday 10/29/2023 16:26 Sunday -3 -3.9 50001170 83417137.52 50001170 3 10/23/2023 18:35 Monday 10/29/2023 16:06 Sunday -3 -3.9 50001170 83417136.52 50001170 3 10/29/2023 12:35 Sunday 10/29/2023 16:06 Sunday 1.71 -3.9 50001170 83417135.52 50001170 3 10/29/2023 12:35 Sunday 10/29/2023 16:26 Sunday -3 -3.9 50001170 83417134.52 50001170 3 10/29/2023 12:35 Sunday 10/29/2023 16:26 Sunday 1.89 -3.9 50001170 83417192.52 50001170 3 10/29/2023 12:35 Sunday 10/29/2023 16:26 Sunday -3 -3.9 50001170 83540873.52 50001170 3 10/29/2023 19:35 Sunday 10/29/2023 20:16 Sunday -3 -8.94 *sum of profits for events on prior 10 rows* 50001170 83575341.52 50001170 3 10/29/2023 19:35 Sunday 10/29/2023 20:16 Sunday -3 -8.94 *same calculation as above row* 50001170 83576079.52 50001170 3 10/29/2023 19:35 Sunday 10/29/2023 20:16 Sunday -3 -8.94 *same calculation as above row* proc print; run;