Members

Blog Posts

Hack 3.11 Exploiting In-Database Processing with Oracle

Posted by Michael A. Raithel on June 27, 2016 at 8:41am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue

Hack 3.10 Executing Native DBMS Commands with PROC SQL

Posted by Michael A. Raithel on June 20, 2016 at 11:23am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue
 

Latest Activity

John Lam replied to Sean Robson's discussion June 29 Problem Solutions in the group Friends of SAS Programming Problems
"data sales; INPUT SalesID $ SalesJan SalesFeb SalesMar; Qtr1 = sum(SalesJan, SalesFeb, SalesMar); CARDS; W6790 50 400 350 W7693 25 100 125 W1387 . 300 250 ; RUN; proc print data=sales split='*' noobs; var SalesID SalesJan SalesFeb…"
11 hours ago
Arthur Tabachneck replied to Sean Robson's discussion June 29 Problem Solutions in the group Friends of SAS Programming Problems
"I would have thought that the new sum features in 9.4 would accommodate summing within a row but, if it can, I couldn't figure out how to do it. Thus, my solution is basically the same as the one offered by Horst: data sales;  set…"
13 hours ago
Arthur Tabachneck liked Sean Robson's discussion June 29 Problem Solutions
15 hours ago
Horst Wolter replied to Sean Robson's discussion June 29 Problem Solutions in the group Friends of SAS Programming Problems
"data sales; input SalesID $ SalesJan FebSales MarchAmt; Qtr1 = sum(SalesJan, FebSales, MarchAmt);datalines;W6790 50 400 350W7693 25 100 125W1387 . 300 250run; proc print noobs split='*';var SalesID SalesJan FebSales MarchAmt Qtr1;label…"
yesterday
Sean Robson added a discussion to the group Friends of SAS Programming Problems
Thumbnail

June 29 Problem Solutions

Please post your solutions to this week's problem here. Thank you!See More
yesterday
Michael A. Raithel posted a blog post

Hack 3.11 Exploiting In-Database Processing with Oracle

SAS Programming Professionals,Check out this hack:  http://michaelraithel.blogspot.com/2016/06/hack-311-exploiting-in-database.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 each…See More
Monday
Profile IconEstela Lutero and Karen Bowen joined SAS Canada Community
Friday
Karen Bowen posted a status
"Hi, I'm working in Targeted Marketing for a major bank."
Friday
Arthur Tabachneck replied to Martha Casanova's discussion June 22 Problem Solutions in the group Friends of SAS Programming Problems
"Probably not the solution you were expecting, but it is done entirely with SAS code. I used the macro I wrote some years ago before the excelxp tagsets were available (i.e., http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export ).…"
Jun 22
Horst Wolter replied to Martha Casanova's discussion June 22 Problem Solutions in the group Friends of SAS Programming Problems
"ods tagsets.excelxp file='C:\22jun2016.xml' style=sasweb options(sheet_name="class"); proc report data=sashelp.class nowd;column name age sex height weight;define weight /LEFT style(column)=[font_weight=bold] ;define age /RIGHT…"
Jun 22
Martha Casanova added a discussion to the group Friends of SAS Programming Problems
Thumbnail

June 22 Problem Solutions

Please post your solutions to this week's problem here. Thank you!See More
Jun 22
Herve Momo replied to Sean Robson's discussion June 8 Problem Solutions in the group Friends of SAS Programming Problems
"/*Here is my solution*/ %let start_date = 201503; %let end_date = 201606; %let months = 3;   /* loop by number of months from start to end inclusive */   %macro date_loop(start_dte, end_dte, months); data _null_; format start enddte…"
Jun 22
Sean Robson liked Mackenzie Keelan's group Friends of SAS Programming Problems
Jun 21
Michael A. Raithel posted a blog post

Hack 3.10 Executing Native DBMS Commands with PROC SQL

SAS Programming Professionals,Check out this hack:  http://michaelraithel.blogspot.com/2016/06/hack-310-executing-native-dbms-commands.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…See More
Jun 20
Alain Londes is now a member of SAS Canada Community
Jun 17
Peter Timusk replied to Sean Robson's discussion June 15 Problem Solutions in the group Friends of SAS Programming Problems
"Likewise I am going to argue the specs. Just because I get a Monday off if Christmas is on a weekend it does not make it that Christmas is 'observed' on the Monday. I think only Canada Day matters here all other days are observed when they…"
Jun 16
SHIRLEY TSENG updated their profile
Jun 16
John Lam replied to Sean Robson's discussion June 15 Problem Solutions in the group Friends of SAS Programming Problems
"Sorry, I should have been more specific.  If Xmas holiday is observed on Monday because it falls on a weekend, then Boxing date will be observed on Tuesday (we will get 4 days off :) ). In addition to Arthur reply, please note…"
Jun 16
Doug Dover replied to Sean Robson's discussion June 15 Problem Solutions in the group Friends of SAS Programming Problems
"Data holidays; format holiday $30.; format holiday_date observed_date date9.; Array names{11} $30. _temporary_ ("NEWYEAR" "family" "EASTER" "VICTORIA" "CANADAOBSERVED" "civic"…"
Jun 15
Doug Dover replied to Sean Robson's discussion June 8 Problem Solutions in the group Friends of SAS Programming Problems
"%let start_date=201503; %let end_date=201606; %let months=3; %macro date_loop(stdate,enddt,intmonth); Data _NULL_; currdate = input("&stdate.01",yymmdd8.); stopdate = input("&enddate.01",yymmdd8.); put currdate…"
Jun 15

Forum

define.xml / pdf for submission data

Started by Noemi Toiber Temin in Featured Discussions Jun 9. 0 Replies

Please, could anyone connect me with someone experienced in creating the define.xml/pdf for the standard datasets for submission. I am looking for the best way to do this ASAP so anyone able to help would be SO great!! thank you in advance. How did…Continue

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

 
 
 

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