Members

Blog Posts

Hack 3.4 Creating a Detailed Directory Listing of Files in A SAS Data Library

Posted by Michael A. Raithel on May 2, 2016 at 8:45am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue

SASGF 2016

Posted by Peter Timusk on April 22, 2016 at 3:30am 1 Comment

I enjoyed the company of  a coworker this year at SAS Global Forum. We talked SAS programming and work issues for the flight down and back. I was invited to meetings of executives and SAS staff as requirements were discussed for problems. I…

Continue
 

Latest Activity

Chantale Lecours is now a member of SAS Canada Community
7 hours ago
Mamadou Dakouo updated their profile
21 hours ago
Mamadou Dakouo liked Irene Lee Newton's group SAS Canada Consulting Opportunities
21 hours ago
Mamadou Dakouo joined Irene Lee Newton's group
Thumbnail

SAS Canada Consulting Opportunities

Looking to use your SAS skills on short-term consulting contracts? SAS Canada Consulting occasionally requires external support in the areas of SAS analytics, DI and BI.  Please visit often for regular updates!See More
21 hours ago
Arthur Tabachneck replied to Martha Casanova's discussion May 4th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"Horst: I can't test this either (I REALLY don't like these kinds of problems being posed!), but my guess would be that the sqlfunctions=all libname option might be all that is needed. "
22 hours ago
Horst Wolter replied to Martha Casanova's discussion May 4th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"I can't test the solution but from what I read in the SAS reference manual there is a dbidirectexec option which will pass implicit SQL to the database for processing. So the solution might be as simple as adding the following line of code…"
yesterday
Martha Casanova added a discussion to the group Friends of SAS Programming Problems
Thumbnail

May 4th 2016 Problem Solutions

Please post your solutions to this week's problem here. Thank you!See More
yesterday
Martha Casanova commented on Peter Timusk's blog post SASGF 2016
"It was great meeting you at SGF Peter!  "
Tuesday
Martha Casanova liked Peter Timusk's blog post SASGF 2016
Tuesday
Profile IconEric Yang, Reza Ghaeli and Tong Qi joined SAS Canada Community
Tuesday
Michael A. Raithel posted a blog post
Monday
Horst Wolter replied to Taylor Brown's discussion April 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"/* create the table of jobs */data table; input v1 $ v2 $ ; datalines;JOB_A JOB_BJOB_C JOB_DJOB_E JOB_AJOB_F JOB_CJOB_G JOB_A; run; /* create data for lookup table */data look; set table;rename v1=key v2=data;run; /* create the result table */data…"
Apr 28
Arthur Tabachneck replied to Taylor Brown's discussion April 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"data have;  input (V1 V2) ($);  cards;JOB_A JOB_B JOB_C JOB_DJOB_E JOB_AJOB_F JOB_CJOB_G JOB_A; data want (drop=rc);  set have;  if _n_=1 then do;    length v3 $5;    call missing(of v3);    declare…"
Apr 28
Randy Wanye replied to Randy Wanye's discussion Difference between Datetime variables using INTCK function
"I solved the problem and this is how I did it. data counts; set mydata; array Ins {*} In: ; array Outs {*} Out: ; do k = 1 to dim(ins) - 1; time = intck('hour', outs[k], ins[k+1]); if time >= 0 and time <= 72 then output; end; run;"
Apr 28
John Lam replied to Taylor Brown's discussion April 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"data job_stream job(keep=k); input k $ d $; cards; JOB_A JOB_B JOB_C JOB_D JOB_E JOB_A JOB_F JOB_C JOB_G JOB_A JOB_H JOB_G ; run; data match(keep=v1-v20); length d $5. k $5. v1-v20 $5.; array v{20} $ v1-v20; if _N_ = 1 then do; declare hash…"
Apr 28
Profile IconKanchan Bajwa, Anand Kumar, Orlando Paz and 3 more joined SAS Canada Community
Apr 28
Randy Wanye updated their profile
Apr 27
Randy Wanye posted a discussion

Difference between Datetime variables using INTCK function

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 27AUG12:10:42 27AUG12:09:45 27AUG12:09:45 5 07AUG12:23:16 09AUG12:22:13 07AUG12:23:16 10AUG12:15:59I want to calculate the difference between In2 and Out1, that is I want In2 - Out1 in hours(the difference between when they were out and when they…See More
Apr 27
Profile IconYolanda Wang, Zahid A. Butt and SHIRLEY TSENG joined SAS Canada Community
Apr 26
Taylor Brown added a discussion to the group Friends of SAS Programming Problems
Thumbnail

April 27th 2016 Problem Solutions

Please post your solutions to this week's problem here. Thank you!See More
Apr 26

Forum

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

Exit a SAS script based on a condition

Started by Terry in Featured Discussions. Last reply by gskn4u Nov 5, 2015. 1 Reply

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

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

Need a tutor in Montréal

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

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

 
 
 

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