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.

Quentin

I'm making a pChart using PROC SHEWHART, and my subgroups (lots) have varying sizes. I want to give each lot the same weight when calculating pbar, rather than let lots with larger sample sizes have more weight. I assumed PROC SHEWHART would have a WEIGHT statement, but it does not. My next thought is to calculate pbar myself, and then pass the value to SHEWHART via the p0 option on the pchart statement. Does this seem like a reasonable approach? As an example, given data like: data have ; input lot pfailed ntested ; cards ; 1 .1 20 2 .2 20 3 .1 20 4 .2 20 5 .4 60 ; PROC SHEWHART will calculate pbar as a weighted mean of the proportions, giving lot 5 more weight than the other lots, and you get pbar=.26. proc shewhart data=have ; pchart pfailed*lot/subgroupn=ntested dataunit=proportion; run ; My thought is to calculate pbar myself as the unweighted mean, and you get pbar=.2, and pass that value to PROC SHEWHART: proc sql noprint; select mean(pfailed) into :pbar trimmed from have ; quit ; %put &=pbar ; proc shewhart data=have ; pchart pfailed*lot/subgroupn=ntested dataunit=proportion p0=&pbar; run ;

BruceBrad

I'm trying to strip some operators from a string, leaving behind variable names. I'm using the following code which doesn't work. Is there some quoting needed? %let expression = vara / (varb + varc); %macro stripsym(string); %sysfunc(translate(&string,,+-*/())); %mend stripsym; %put Output: %stripsym(&expression); %put Desired: vara varb varc;

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;

casse

Hi all, I'm interested in writing a blog application for myself and wondering what the hosting costs would be. I'm open to whatever database tech is recommended, although I'm most familiar w/ T-SQL/AzureSql. Is Azure too expensive for such a small personal project? Are there cheaper alternatives for apps that don't really need to scale? Thanks!