Posted by Michael A. Raithel on December 5, 2016 at 8:44am 0 Comments 0 Likes

Posted by Michael A. Raithel on November 28, 2016 at 8:42am 0 Comments 0 Likes

Arthur Tabachneck replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"Bruce: That was based on my original interpretation of the problem statement .. which I trashed right after posting my proposed solution. I seem to recall it calling for 100 boats arriving each day. I didn't bother to consider the…"

1 hour ago

Bruce Densmore replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"How do you figure that my "approach would have the same effect", especially when my results, as provided in my posting, appear to show otherwise?
I chose not to limit the depth of the potential queue (ie. lag1-lag5) so that I could use the…"

2 hours ago

Arthur Tabachneck replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"Bruce,
Your approach would have the same effect, but I used an approach that did the same thing but only requiring one pass through the data. Based on the original problem statement (that was looking for any instances where at least five boats were…"

2 hours ago

Aroop Ghosh replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"Thanks Bruce for taking the time to explain the inconsistency, I will definitely check out your approach. It was my first time attempting a simulation problem using SAS.
cheers,
Aroop"

4 hours ago

Bruce Densmore replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"From your results ...
I am making this comment only because I found it in my own code and it took me a while to resolve. For obs #13 there is only 1 boat in the queue, and that is obs #12. Obs #11 was in the queue for obs #12, but obs…"

4 hours ago

Arthur Tabachneck replied to Sean Robson's discussion December 7 Problem Solutions in the group Friends of SAS Programming Problems

"I feel like I'm in a Dilbert cartoon where the punch line (aimed at the pointy haired boss of course) is, "OK.You want me to waste time to include a sort that isn't needed, as well complicate things by wrapping the code within a…"

9 hours ago

Aroop Ghosh replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"Just under the wire, done quickly, not very elegant.
Please see code and results attached, including bonus question. "

yesterday

Sean Robson added a discussion to the group Friends of SAS Programming Problems### December 7 Problem Solutions

Please post your solutions to this week's problem here. The dataset needed to complete the problem is attached below. Thank you! See More

yesterday

Michael A. Raithel posted a blog post### Hack 4.4 Creating SAS Date Variables with the MDY Function

SAS Programming Professionals,Check out this hack: http://michaelraithel.blogspot.com/2016/12/hack-44-creating-sas-date-variables.html ...excerpt from my book: Did You Know That? Essential Hacks for Clever SAS Programmershttp://www.amazon.com/Michael-A.-Raithel/e/B001K8GG90/ref=ntt_dp_epwbk_0I plan…See More

Monday

John Lam replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"Adding days is a good idea. I ran the process multiple times each day."

Monday

Arthur Tabachneck replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"John, FWIW, your method of inputting time doesn't take any longer than using the "t" suffix and, in fact, can sometimes be quicker (although both are basically equivalent).
I was concerned with your statement that you were running…"

Saturday

John Lam replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"Thanks Bruce. Yes, I am aware of the t input for time (and d for date). I don't know why I used input statement in that data step. I guess my mind was on lock queue."

Friday

Bruce Densmore replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"I see that you used the following code to set the start and end times ... start_time = input('06:00', time5.); end_time = input ('18:00', time5.);
Are you aware of the existance of SAS date and…"

Friday

John Lam replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"I have been testing this process in the last 3 days, andand did not find the queue reached its capacity. The longestqueue was 3 (happened only in one run!)
Although I post the solution now (rather than 7 days later), I will continue to test if…"

Friday

Bruce Densmore replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"My results are attached to my submission so that you do not have to run my code to see them.
I rarely get to do simulation ... so I just gradually worked through what I think needed to be done. This is what I cam up with .. and it was all done with…"

Nov 30

Jean-François Ducré-Robitaille replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"Here is my solution. I think with the 15 minutes delay, there can be more than 2 boats at the same time in the queue, but it is very unlikely (with a service time of 30 minutes and, let say a fix delay of 15 minutes between boats, there will be…"

Nov 30

Arthur Tabachneck replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"Sean: Not a problem! I was only concerned that I might have misunderstood.
Using your new criterion, here is my code:
proc format; invalue arrival 1-5=15 6-15=20 16-30=25 31-50=30 51-70=35 71-85=40 86-95=45 96-100=50 ; value na .='N/A'…"

Nov 30

Sean Robson replied to Sean Robson's discussion November 30 Problem Solutions in the group Friends of SAS Programming Problems

"Hi Art,
An oversight on my part, my apologies. For simplicity, I would say adjust the restriction to see if the queue ever exceeds one boat (if so you can indicate this as over capacity). Let me know if this works!
Sorry for the mix-up, Sean"

Nov 30

Started by Sam Davie in Featured Discussions. Last reply by Arthur Tabachneck Nov 16. 1 Reply 0 Likes

Hi,I have a large dataset containing information about patients of a medical clinic, which doctor they are registered with (Registering Doctor), and which they saw on that particular visit (Attending Doctor). For each patient, I'd like to calculate…Continue

Started by Malcolm Ponnayan in Featured Discussions Oct 17. 0 Replies 0 Likes

Good Morning everyone ! I am new to SAS and to this community here online. I am planning to do my basic foundation certification with SAS. Could anyone please help me with some inputs and guidance on preparation materials, books, or any other…Continue

Started by Warren Mok in Featured Discussions Sep 22. 0 Replies 0 Likes

Dear Sir/Madam, I want to be able to call the function INTRR with a dynamic number of arguments. My program calls INTRR this way: EIRn = INTRR(1, -Orig_Bal %c(n)); My macro c is as follows:macro c(t); %do i = 1 %to…Continue

Started by Michael A. Raithel in Featured Discussions Sep 19. 0 Replies 0 Likes

SAS Programming Professionals,Check out this hack: …Continue