Members

Blog Posts

Hack 7.1 Avoiding File Lock Problems

Posted by Michael A. Raithel on November 27, 2017 at 8:26am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue

Keeping SAS platforms secure. Learn how at GHSUG, OASUS and OPUS

Posted by Michelle Homes on November 10, 2017 at 11:59pm 0 Comments

G'Day SAS Canada Community,

Paul Homes and I are excited to be attending and presenting at a few user group meetings in the coming weeks. We'll be at GHSUG, OASUS and OPUS to share how we at Metacoda help SAS customers keep their…

Continue
 

Latest Activity

Aroop Ghosh replied to Natasha Ulanowski's discussion December 13 - Programming Problem in the group Friends of SAS Programming Problems
"/* In normal use, the results stated in the challenge will not be achieved. Both Gift 1 and 2 datasets will be identical to the dataset FROMME(including the values and the number of obs in FROMME). The reason is due to the fact the IN option (att to…"
1 hour ago
Horst Wolter replied to Natasha Ulanowski's discussion December 13 - Programming Problem in the group Friends of SAS Programming Problems
"Oops! You're right Art!  My cut & paste error gave me what I wanted to see so I didn't check further. Also, your post about different character lengths holds true. Below is my revised code: data FROMME;input freewill…"
9 hours ago
Richard Bemile replied to Natasha Ulanowski's discussion December 13 - Programming Problem in the group Friends of SAS Programming Problems
"positioning of (in=) can count on how many observations the dataset has respective to the other dataset"
11 hours ago
Arthur Tabachneck replied to Natasha Ulanowski's discussion December 13 - Programming Problem in the group Friends of SAS Programming Problems
"The only way I can see getting that result is if FREEWILL had different lengths in the two datasteps. Here is one example where GIFT2 will end up with one observation, but GIFT2 will have 5: data fromme;  length freewill $5;  input…"
11 hours ago
Arthur Tabachneck replied to Natasha Ulanowski's discussion December 13 - Programming Problem in the group Friends of SAS Programming Problems
"Your second merge was wrong. Unlike the code in the problem you merged toyou with itself in the gift2 datastep."
11 hours ago
Horst Wolter replied to Natasha Ulanowski's discussion December 13 - Programming Problem in the group Friends of SAS Programming Problems
"The attachment doesn't have the full code. Have to see the image in the Programming Problem. Below is the code I used and sample data to test. data fromme;input freewill;datalines;12345;run; data toyou;input freewill;datalines;1;run; DATA…"
12 hours ago
Arthur Tabachneck replied to Natasha Ulanowski's discussion December 13 - Programming Problem in the group Friends of SAS Programming Problems
"Horst: Please provide some example data. I don't see the logic! Both in=love statements are attached to fromme"
12 hours ago
Donald Wildeboer replied to Natasha Ulanowski's discussion December 13 - Programming Problem in the group Friends of SAS Programming Problems
"This happened because I gave 5 gifts by freewill and you only gave 1 gift by freewill and depending on the order that we exchange them the end-of-file is reached and gifting stops. :'-("
13 hours ago
Horst Wolter replied to Natasha Ulanowski's discussion December 13 - Programming Problem in the group Friends of SAS Programming Problems
"If FROMME has 5 observations and TOYOU has only 1 observation then GIFT1 will have 5 observations and GIFT2 will have only one observation because of the position of IN=LOVE (first with FROMME. second is with TOYOU)."
13 hours ago
Natasha Ulanowski added a discussion to the group Friends of SAS Programming Problems
Thumbnail

December 13 - Programming Problem

Please post your solution's to this week's programming problem here. Data set for the problem is attached here. Thanks!See More
14 hours ago
Rodger Zhang replied to Natasha Ulanowski's discussion December 6 - Programming Problem in the group Friends of SAS Programming Problems
"As many have mentioned that I also had challenge to completely understand what the question really meant. To get the stats for the difference between Q2 and Q1, I would just add sum((Q2-Q1)) as Q2_Q1_Diff first and include all descriptive statistics…"
Monday
Moustapha Oke posted a status
"best code for equivalence testing of two analytical methods?"
Monday
Richard Bemile replied to Natasha Ulanowski's discussion December 6 - Programming Problem in the group Friends of SAS Programming Problems
"proc sql; create table sep_004 as select visit, mean(totalscore) as mean, max(totalscore) as max, min(totalscore) as min, std(totalscore) as std, nmiss(totalscore) as nmiss, n(totalscore) as n, ('004') as Study from (select PID, visit,…"
Saturday
Mathieu Gaouette replied to Natasha Ulanowski's discussion December 6 - Programming Problem in the group Friends of SAS Programming Problems
"/* Original code presented */proc sql; create table sep_004 as select visit, mean (totalscore) as mean, max(totalscore) as max, min(totalscore) as min, std(totalscore) as std, nmiss(totalscore) as nmiss, n(totalscore) as n, ('004') as…"
Friday
olayinka awoyemi replied to Natasha Ulanowski's discussion December 6 - Programming Problem in the group Friends of SAS Programming Problems
"proc sql;create table sep_004 asselect visit, mean (totalscore) as mean, max(totalscore) as max, min(totalscore) as min,std(totalscore) as std, nmiss(totalscore) as nmiss, n(totalscore) as n, ('004') as Study, change, mean (change) as…"
Dec 7
Horst Wolter replied to Natasha Ulanowski's discussion December 6 - Programming Problem in the group Friends of SAS Programming Problems
"/* I thought the question meant to take the LAG so I created the SQL equivalent of SAS LAG. I had the SQL split into parts and it seemed to work so I combined it all but didn't test thoroughly.  */ data sep004;input PID visit Q1 Q2;…"
Dec 7
John Lam replied to Natasha Ulanowski's discussion December 6 - Programming Problem in the group Friends of SAS Programming Problems
"- I don't think I understand the question and I am assuming Q2 exists in the dataset- This SQL has not been tested proc sql; create table sep_004 as select visit, mean (totalscore) as mean, max(totalscore) as max, min(totalscore) as min,…"
Dec 7
Michael Levinshtein replied to Natasha Ulanowski's discussion December 6 - Programming Problem in the group Friends of SAS Programming Problems
"It's very hard to understand a problem. I think you have to be more specific."
Dec 7
Bruce Densmore replied to Natasha Ulanowski's discussion November 29 - Programming Problem in the group Friends of SAS Programming Problems
"I agree with you on both counts, but if you look at my notes (attachment) from 15MAR2017, where the limit was only 500,000, both of those cases potentionally exist ... but neither surfaced in the results.  It may be, that in MERGE the first…"
Dec 6
Donald Wildeboer replied to Natasha Ulanowski's discussion December 6 - Programming Problem in the group Friends of SAS Programming Problems
"Agreed. I think sample data would have gone a long way. There is the possibility for many different answers!"
Dec 6

Forum

WHERE clause question in SAS Dataset

Started by Sasha Mathew in Featured Discussions. Last reply by Sasha Mathew Dec 6. 1 Reply

Trying to filter out the dataset according to dates. The filter is being applied to a datetime column with format datetime19. and informat 19. The data does have time component when I look at the datasetWhat I have found is the following works:data…Continue

PUT LOG

Started by Sasha Mathew in General Discussions. Last reply by Sasha Mathew Dec 6. 2 Replies

I am just starting to learn SAS and am trying to use the PUT function in SAS. Based on what I read if I do this:%put one line of text.;In the SAS log I should see:One line of text.However I found when running SAS 9.3 on our server, the log shows…Continue

Tags: OUTPUT, PUT

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

 
 
 

Photos

  • Add Photos
  • View All

Videos

  • Add Videos
  • View All

© 2017   Created by Steve Mahoney.   Powered by

Badges  |  Report an Issue  |  Terms of Service