Members

Blog Posts

Hack 6.3 Customizing Footnotes For More Professional Looking Reports

Posted by Michael A. Raithel on October 2, 2017 at 8:28am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue

Hack 6.3 Customizing Footnotes For More Professional Looking Reports

Posted by Michael A. Raithel on October 2, 2017 at 8:28am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue
 

Latest Activity

Aroop Ghosh replied to Natasha Ulanowski's discussion October 18 - Programming Problem in the group Friends of SAS Programming Problems
"I have used Proc Rank where you can read the relative ranks of each country in the corresponding variable.  In the case of a tie both values get an identical rank. The highest number has the rank of 1, unless there is a tie then the tied…"
8 hours ago
Bruce Densmore replied to Natasha Ulanowski's discussion October 18 - Programming Problem in the group Friends of SAS Programming Problems
"I played with this for a while and then settled on a solution that involved PROC SQL generating summary macros, %MACRO, the macro IN operator (in line 2 ... notice the OPTION MINOPERATOR in line 2), arrays, CALL SORTN in reverse order (line 54), and…"
14 hours ago
Arthur Tabachneck replied to Natasha Ulanowski's discussion October 18 - Programming Problem in the group Friends of SAS Programming Problems
"I like the approach that Horst took, so my code is basically the same: data country;  input USA AUS ENG;  datalines;1000 2000 5003000 1000 2001500 1500 10002200 1100 1500700 150 9003000 1000 500; %macro nth_highest(country,nth);  proc…"
14 hours ago
Michael Levinshtein posted a status
"%let n=3; data b; input v @@; datalines; 1000 2000 500 ... ; proc sort data=b ; by descending v; proc print data=b(firstobs=&n obs=&n); run;"
17 hours ago
CB replied to Natasha Ulanowski's discussion October 18 - Programming Problem in the group Friends of SAS Programming Problems
"*2nd highest for the  usa variable; proc sql; select usa, (select count(*) from (select distinct usa from country) as b where b.usa gt a.usa) as n from country a where calculated n = 1 ; quit; *1st highest for the  aus variable; proc…"
18 hours ago
Mathieu Gaouette replied to Natasha Ulanowski's discussion October 18 - Programming Problem in the group Friends of SAS Programming Problems
"I went pretty straight forward.  This will work if we feed it valid values.  If we try to get a position that exceeds the number of rows, it will fail. data weekly_challenge ; length USA 8. AUS 8. ENG 8. ; input USA AUS ENG;datalines…"
18 hours ago
Horst Wolter replied to Natasha Ulanowski's discussion October 18 - Programming Problem in the group Friends of SAS Programming Problems
"data country; input USA AUS ENG;datalines;1000 2000 5003000 1000 2001500 1500 10002200 1100 1500700 150 9003000 1000 500;run; /* nth highest number */ %macro high(place,n);proc sql; select distinct a.&place from country as a where (select…"
19 hours ago
Harry is now a member of SAS Canada Community
yesterday
Bruce Densmore replied to Natasha Ulanowski's discussion October 11 - Programming Problem in the group Friends of SAS Programming Problems
"I agree with, and have very little to add to, what Art said.  So I decided to show how I would attempt to show (or debug) what is going on. Here is the sample data I used ... LAWS and OTHER ... Here's my code ... Lines 16-20…"
yesterday
Natasha Ulanowski added a discussion to the group Friends of SAS Programming Problems
Thumbnail

October 18 - Programming Problem

Please post your solutions to this week's programming problem here. Thank you!See More
yesterday
Estela Lutero Tavares replied to Natasha Ulanowski's discussion October 11 - Programming Problem in the group Friends of SAS Programming Problems
"1. I am guessing the condition on the WHERE was met when first run, and then not met afterwards.  2.  WHERE and IF give the same results"
Friday
Richard Bemile replied to Natasha Ulanowski's discussion October 11 - Programming Problem in the group Friends of SAS Programming Problems
"1. The condition in the where statement wasn't met the following day. 2. Nothing changes same result."
Friday
Aroop Ghosh replied to Natasha Ulanowski's discussion October 11 - Programming Problem in the group Friends of SAS Programming Problems
"1. The first time the code ran on a dataset that had at least one record in which STATUS = 'BARREL ' as well as TYPE = 'PORK', with one space character after barrel and both values in upper case.  The  second day the…"
Oct 12
olayinka awoyemi replied to Natasha Ulanowski's discussion October 11 - Programming Problem in the group Friends of SAS Programming Problems
"1. Maybe the condition was met when it was run the first day with a particular dataset and otherwise the second day with a different dataset. 2. No difference changing from "where" to "if". The only difference could be in CPU…"
Oct 12
Profile IconEmerson Romanhuki and Beatrix(Bea) Dixon joined SAS Canada Community
Oct 12
Aroop Ghosh replied to Natasha Ulanowski's discussion October 4 - Programming Problem in the group Friends of SAS Programming Problems
"Hello, If anyone is interested I have posted a video tutorial on Youtube showing the steps for completing the Oct 4th challenge Targetted Bar Chart Video Aroop"
Oct 11
Rodger Zhang replied to Natasha Ulanowski's discussion October 11 - Programming Problem in the group Friends of SAS Programming Problems
"First of all, the question missed a RUN; statement which results the error message of “ERROR 180-322: Statement is not valid or it is used out of proper order.”.   With RUN; statement, there should not be any difference if…"
Oct 11
Donald Wildeboer replied to Natasha Ulanowski's discussion October 11 - Programming Problem in the group Friends of SAS Programming Problems
"1. What probably happened is recordset from the second day had no records that matched the where statement. 2. Other possibilities that could happen if the where statement was replaced with an if statement is: Same successfully reporting count of…"
Oct 11
Tom Kari replied to Natasha Ulanowski's discussion October 11 - Programming Problem in the group Friends of SAS Programming Problems
"There were no records in dataset "laws" with both status = "BARREL" and type = "PORK". Therefore the data step was never executed. If a subsetting if is used, the same result will occur (I tested it). If an "if…"
Oct 11
John Lam replied to Natasha Ulanowski's discussion October 11 - Programming Problem in the group Friends of SAS Programming Problems
"1) What happened?    - LAWS has no observation.     - No observation satisfies the condition. If data is not always in upper case, use upcase      to check each variable as in:       …"
Oct 11

Forum

Dataset URL for the Weekly Programming Problems

Started by Aroop Ghosh in Featured Discussions Jul 22. 0 Replies

Hello,I would like to use SODA  for the Weekly Programming Problems and use the dataset directly without downloading them, but have been unable to determine the URL. Can somebody tell me please the URL to use for the datasets used for the Weekly…Continue

Logsitic Regression Interaction Term

Started by Sam Davie in Featured Discussions. Last reply by SZ YAO Apr 18. 1 Reply

Hello,I am working on an analysis where I would like to know whether an intervention acts differently across levels of income (5 levels total). I'd like to do this for females only, and adjust for age. In the end, I'd like to obtain an odds ratio…Continue

Available SAS software

Started by Rex Deus in Featured Discussions. Last reply by Arthur Tabachneck Mar 21. 1 Reply

SAS Admin question,I run "proc setinit" and don't see SAS EG as available software, yet SAS EG is fully usable and running fine, am I missing something here?Continue

Do Loop?

Started by Sam Davie in Featured Discussions. Last reply by Arthur Tabachneck Nov 16, 2016. 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

 
 
 

Photos

Loading…
  • Add Photos
  • View All

Videos

  • Add Videos
  • View All

© 2017   Created by Steve Mahoney.   Powered by

Badges  |  Report an Issue  |  Terms of Service