Members

Blog Posts

Hack 4.4 Creating SAS Date Variables with the MDY Function

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

SAS Programming Professionals,

Check out this hack: …

Continue

Hack 4.3 Computing Smallest and Largest Value for Variables in An Observation

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

SAS Programming Professionals,

Check out this hack: …

Continue
 

Latest Activity

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
Profile IconIvy Gracias and nadera s. joined SAS Canada Community
12 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
Thumbnail

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
Profile IconXINRONG YANG, Taesun Yoo and Eddie Ho joined SAS Canada Community
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

Forum

Do Loop?

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

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

New to SAS & basic certification help please !

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

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

calling INTRR function with a dynamic number of arguments

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

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

Hack 3.18 Moving Catalog Entries Between SAS Catalogs

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

SAS Programming Professionals,Check out this hack: …Continue

 
 
 

Photos

Loading…
  • Add Photos
  • View All

Videos

  • Add Videos
  • View All

© 2016   Created by Steve Mahoney.   Powered by

Badges  |  Report an Issue  |  Terms of Service