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

Bruce Densmore replied to Natasha Ulanowski's discussion April 25 2018 - Programming Problem in the group Friends of SAS Programming Problems
"1. How would you select the first transaction made by each customer with a transaction amount less than $200 from a data set containing a detail daily transaction for a period of 2 years? This is how I would do it ... (with thanks to Horst for the…"
6 hours ago
Arthur Tabachneck replied to Natasha Ulanowski's discussion April 25 2018 - Programming Problem in the group Friends of SAS Programming Problems
"Thanks to Roger for both the data and the solution. I couldn't have written it any better! data raw (drop=id i);  input cust_id trx_date: mmddyy10. amount;  format trx_date mmddyy10.;  datalines;1 12/05/2007 2801 12/05/2007 2001…"
7 hours ago
Rodger Zhang replied to Natasha Ulanowski's discussion April 25 2018 - Programming Problem in the group Friends of SAS Programming Problems
"data raw; input cust_id: $1. trx_date: mmddyy10. amount; format trx_date mmddyy10.; datalines; 1 12/05/2007 280 1 12/05/2007 200 1 02/27/2008 500 1 06/30/2008 75 1 10/27/2008 275 1 02/23/2009 900 1 06/01/2009 75 1 08/24/2009 75 1 12/07/2009 75 2…"
8 hours ago
Horst Wolter replied to Natasha Ulanowski's discussion April 25 2018 - Programming Problem in the group Friends of SAS Programming Problems
"data custtrans; input transdt ddmmyy8. custnum amount ; row = _n_; format transdt date9.; datalines; 01/04/16 1 200 01/04/16 1 50 01/04/16 2 199 01/04/16 2 201 15/05/16 1 44 15/05/16 1 55 15/05/16 2 77 15/05/16 2 66 31/12/16 1 1 31/12/16 1…"
8 hours ago
Natasha Ulanowski added a discussion to the group Friends of SAS Programming Problems
Thumbnail

April 25 2018 - Programming Problem

Please post your solution's to this week's programming problem. Thanks!See More
14 hours ago
Louis-René Rheault replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"DATA golf (DROP= stroke_front9 stroke_back9);     MERGE front9 (RENAME=(stroke=stroke_front9)) back9 (RENAME=(stroke=stroke_back9)) ;     BY ssn ;     stroke =…"
yesterday
Bruce Densmore replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"I agree with most of the other submissions ... MERGE with RENAME ... and the MIN of the renamed variables ... Enough said. Bruce"
Monday
Eshetu G. Atenafu replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"proc sort data=FRONT9; by SSN; proc sort data=BACK9; by SSN; run; DATA GOLF;MERGE FRONT9(rename=(STROKE=STROKE_F9)) BACK9(rename=(STROKE=STROKE_F8)); BY SSN;STROKE_MIN=min(of STROKE_F9 STROKE_F9); if STROKE_MIN=. then delete; RUN;"
Monday
Richard Bemile replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"proc sql; create table golf as select b.ssn, min(b.strokes,f.strokes) as stroke from back9 b, front9 f where f.ssn = b.ssn; quit;"
Friday
olayinka awoyemi replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"DATA GOLF (DROP=STROKE9);MERGE FRONT9 BACK9 (RENAME=(STROKE=STROKE9));BY SSN;STROKE=MIN(STROKE,STROKE9);RUN;"
Apr 19
Aroop Ghosh replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"/* Using HASH tables */ * Thanks to Art for the data set; data golf(drop=rc);if _n_=1 then do;if 0 then set front9; declare hash right…"
Apr 19
Horst Wolter replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"data front9;input ssn STROKES;datalines;111111111 60111111111 55111111111 50222222222 .333333333 70444444444 65;run; data back9;input ssn STROKES;datalines;111111111 44111111111 66222222222 59333333333 47444444444 67;run; DATA GOLF(keep=ssn…"
Apr 19
Michael Levinshtein replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"DATA GOLF(drop=stroke_tmp); MERGE FRONT9 BACK9(rename=(stoke=stroke_tmp)); BY SSN; stoke=min(stoke,stroke_tmp); run;"
Apr 19
Rodger Zhang replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"data golf ; merge front9(rename=(stroke=front9_stroke)) back9 (rename=(stroke=back9_stroke)); by SSN; min_stroke=min(front9_stroke,back9_stroke); run; /* Alternatively, SQL procedure can achieve the same result */ proc sql; create table golf_sql…"
Apr 19
Marc-André Thivierge replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"DATA golf (DROP=stroke_front9 stroke_back9); MERGE front9 (RENAME=(stroke=stroke_front9)) back9 (RENAME=(stroke=stroke_back9)); BY SSN; stroke = MIN(stroke_front9, stroke_back9); RUN;"
Apr 19
Mathieu Gaouette replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"Pretty straight forward. data golf ; merge front9(rename=(stroke=stroke_front9)) back9(rename=(stroke=stroke_back9)) ; by ssn ; drop stroke_front9 stroke_back9 ; stroke = min(stroke_front9,stroke_back9) ;run ;"
Apr 19
John Lam replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"data golf(drop=strokef strokeb); merge front9(rename=(stroke=strokef)) back9(rename=(stroke=strokeb)); by ssn; stroke = min(strokef, strokeb); Run;"
Apr 19
Arthur Tabachneck replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"OK. I made up some data that appears to match the problem statement. My proposed solution follows: data front9;  input ssn $9. stroke;  cards;000000001 40000000002 38000000003 44000000004 50000000005 48; data back9;  input ssn $9.…"
Apr 18
Dominique Ouellet posted a photo
Apr 18
Arthur Tabachneck replied to Natasha Ulanowski's discussion April 18 2018 - Programming Problem in the group Friends of SAS Programming Problems
"Are the datasets going to be attached? Currently, they're not in either of the attachments."
Apr 18

Forum

SUAVe (Victoria) Open Problem

Started by Peter Ott in Featured Discussions Apr 16. 0 Replies

Hello fellow SAS user…The next SUAVe meeting is planned for the afternoon of Tuesday May 8th, 2017 at the Queenswood/Arbutus Room in the Cadboro Commons building at UVIC.Attached is a description of the Open Problem for the meeting. If you wish to…Continue

WHERE clause question in SAS Dataset

Started by Sasha Mathew in Featured Discussions. Last reply by Sasha Mathew Dec 6, 2017. 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, 2017. 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, 2017. 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

 
 
 

Photos

  • Add Photos
  • View All

Videos

  • Add Videos
  • View All

© 2018   Created by Steve Mahoney.   Powered by

Badges  |  Report an Issue  |  Terms of Service