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

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

Nandish Avlani, William Blackler, Mariia Samoilenko and 4 more joined SAS Canada Community

25 minutes 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 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

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

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

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

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

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

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

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

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

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