Members

Blog Posts

Hack 3.8 Deriving Summary Statistics with PROC SQL

Posted by Michael A. Raithel on May 20, 2016 at 8:31am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue

Free RUN Statements for Whoever Wants Them

Posted by Michael A. Raithel on May 16, 2016 at 10:23am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue
 

Latest Activity

Profile IconNandish Avlani, William Blackler, Mariia Samoilenko and 4 more joined SAS Canada Community
25 minutes ago
Jérémie Wolsdorfer updated their profile
26 minutes ago
Alf Wilson updated their profile
19 hours ago
Michael A. Raithel posted a blog post

Hack 3.8 Deriving Summary Statistics with PROC SQL

SAS Programming Professionals,Check out this hack:  http://michaelraithel.blogspot.com/2016/05/hack-38-deriving-summary-statistics.html   ...excerpt from the 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 to post…See More
Friday
olayinka awoyemi replied to Martha Casanova's discussion May 18 Problem Solutions in the group Friends of SAS Programming Problems
"NOTE: This solution is copy and paste from SAS/OR® 13.2 User’s Guide Mathematical Programming proc optmodel;set ACTORS;str actor_name {ACTORS};num daily_fee {ACTORS};num most_scenes = 9; /* most scenes by any actor */num scene_list…"
Thursday
Arthur Tabachneck replied to Martha Casanova's discussion May 18 Problem Solutions in the group Friends of SAS Programming Problems
"Since neither proc clp or proc optmodel are available on SAS UE, and using SAS was required as part of the problem statement, I have to copy and paste one of the published solutions: proc optmodel;    set ACTORS;    str…"
Thursday
John Lam replied to Martha Casanova's discussion May 18 Problem Solutions in the group Friends of SAS Programming Problems
"If you click the link provided on the problem page, you will find the macro solution (using PROC CLP) below: %macro scene; /* Ai_Sj=1 if actor i appears in scene j */ /* Ai_Sj=0 otherwise */ /* Initialize to 0 */ %do i=1 %to 11; /* 11 actors */ %do…"
Thursday
Peter Timusk replied to Martha Casanova's discussion May 18 Problem Solutions in the group Friends of SAS Programming Problems
"I found the problem and solution here in the SAS/OR 14.1 Users Guide: Mathematical Programming. Example 6.6 Scene Allocation Problem I had to know this was a linear programming program and know that Proc OPTmodel does linear programming…"
May 18
Arthur Tabachneck and Jingwei Cao are now friends
May 18
Martha Casanova added a discussion to the group Friends of SAS Programming Problems
Thumbnail

May 18 Problem Solutions

Please post your solutions to this week's problem here. Thank you!See More
May 17
Arthur Tabachneck replied to Martha Casanova's discussion May 11 Problem Solutions in the group Friends of SAS Programming Problems
"The posed Sudoku problem is what would be classified as an "easy" problem, i.e., a problem that can be solve by simply selecting all obvious alternatives. The code would have to be enhanced to solve more complex problems where one has to…"
May 17
RAIMUNDO FONSECA replied to Martha Casanova's discussion May 11 Problem Solutions in the group Friends of SAS Programming Problems
"Wow. Your awesome."
May 17
Martha Casanova replied to Martha Casanova's discussion May 11 Problem Solutions in the group Friends of SAS Programming Problems
"Well done Art! :)"
May 17
Profile IconMamatha Musku and Heather Merry joined SAS Canada Community
May 17
Arthur Tabachneck replied to Martha Casanova's discussion May 11 Problem Solutions in the group Friends of SAS Programming Problems
"Since I'm the only one who has responded to this week's problem (i.e., write code to solve a Sudoku) puzzle, I decided to share my thoughts and explain what motivated me to write the following code. While a number of quite bright SAS…"
May 16
Michael A. Raithel posted a blog post

Free RUN Statements for Whoever Wants Them

SAS Programming Professionals,Check out this hack:  http://michaelraithel.blogspot.com/2016/05/free-run-statements-for-whomever-wants.html  ...excerpt from the 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 to…See More
May 16
Arthur Tabachneck replied to Martha Casanova's discussion May 11 Problem Solutions in the group Friends of SAS Programming Problems
"I was going to post the solution from a SGF paper I had written, but it wouldn't run on SAS UE. As such, here is my alternative, including the code and solution. Matt has asked me not to provide where I get my hints, thus I won't (unless…"
May 12
Arthur Tabachneck replied to Martha Casanova's discussion May 11 Problem Solutions in the group Friends of SAS Programming Problems
"Disregard my previous offer. This week's problem isn't going to be the one I understood would be posted. Art "
May 11
Arthur Tabachneck replied to Martha Casanova's discussion May 11 Problem Solutions in the group Friends of SAS Programming Problems
"If you have any questions about this week's problem please post them here and I'll be glad to answer them. Art"
May 11
Martha Casanova added a discussion to the group Friends of SAS Programming Problems
Thumbnail

May 11 Problem Solutions

Please post your solutions to this week's problem here. Thank you!See More
May 10

Forum

Exit a SAS script based on a condition

Started by Terry in Featured Discussions. Last reply by Michael A. Raithel May 9. 2 Replies

I want to be able to check if a SAS dataset has any observations.It is has 0 observations, I want to exit the SAS script.Any suggestions on what I would do?  Continue

Difference between Datetime variables using INTCK function

Started by Randy Wanye in Featured Discussions. Last reply by Randy Wanye Apr 28. 1 Reply

Hello,I have a dataset that looks likeID In1 In2 Out1 Out21 14AUG12:10:27 16AUG12:08:38 14AUG12:16:25 16AUG12:09:38 2 08AUG12:14:41 09AUG12:07:37 08AUG12:22:14 08AUG12:22:14 3 08AUG12:08:54 09AUG12:23:45 08AUG12:14:04 10AUG12:02:55 4 27AUG12:06:41…Continue

Log window and external file

Started by Terry in Featured Discussions Oct 20, 2015. 0 Replies

Is there a way to have the log information appear in the log window and have it output to an external text file. Continue

Need a tutor in Montréal

Started by Mathieu Mireault in General Discussions Oct 9, 2015. 0 Replies

Hello,I'm fairly new at SAS. I need to use it for a class in university but I don't find the help there very useful. I would need a tutor for an hours or two to realyl understand how SAS works. Could someone help me out in the Montréal area? I'm…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