Members

Blog Posts

What Value Does SGF Bring Your Company?

Posted by John Lam on January 26, 2016 at 8:32am 0 Comments

Value:

1)      Knowledge gained by attendees

2)      Be able to consult with experts

3)      Obtain up-to-date technology information

4)      Help resolve/handle common issues (such as big data)

 

All…

Continue

Big Data Competitions require Big Commitment

Posted by Mark Morreale on January 11, 2016 at 6:14pm 0 Comments

A new trend appears to be blowing up 2015 and going into 2016 --  Big Data Competitions. Competitions are the bread and butter of Business Schools and with the rise of Big Data and Analytics so has the request for SAS to sponsor a special…

Continue
 

Latest Activity

Profile IconHelen Hu, Rene Paquin, al leung and 1 more joined SAS Canada Community
2 hours ago
Rene Paquin liked Lindsay Hart's blog post The SAS Canada Academic Program …and beyond!!
14 hours ago
Aroop Ghosh joined Mackenzie Keelan's group
Thumbnail

Friends of SAS Programming Problems

This is where we will post the weekly posed programming problems so you can come back to the question, ask questions and help each other out! If you are not a member of Friends of SAS join here: https://sas.influitive.com/join/Cust_CanCommSee More
yesterday
Shirley Li replied to Taylor Brown's discussion February 3rd 2016 Problem Solutions in the group Friends of SAS Programming Problems
"@Arthur. I wouldn't even know where to start. :)  i can't believe you're using the university edition to do everything. I think SAS should reward you a copy of their software :) haha"
Wednesday
Arthur Tabachneck replied to Taylor Brown's discussion February 3rd 2016 Problem Solutions in the group Friends of SAS Programming Problems
"@Shirley: I would much rather have been able to use a solution like the one you offered, but that was the only way I could reproduce the graphs :)  "
Wednesday
Shirley Li replied to Taylor Brown's discussion February 3rd 2016 Problem Solutions in the group Friends of SAS Programming Problems
"WOW!!!!!!"
Wednesday
Arthur Tabachneck replied to Taylor Brown's discussion February 3rd 2016 Problem Solutions in the group Friends of SAS Programming Problems
"I'm confused as the desired results don't match the data. Also, while I'd think that gchart and sgpanel or greplay would be easier, none are available in the SAS University Edition. As such, I divided the actual and predict values by…"
Wednesday
Shirley Li replied to Taylor Brown's discussion February 3rd 2016 Problem Solutions in the group Friends of SAS Programming Problems
"proc sgpanel data=prdsale; panelby quarter; vbar product / response=actual nostatlabel transparency=.5; vbar product / response=predicted barwidth=.6 nostatlabel transparency=.5;run;"
Wednesday
Carl Vallieres replied to Taylor Brown's discussion February 3rd 2016 Problem Solutions in the group Friends of SAS Programming Problems
"/* Report 1 *//* my solution - one graph, easier to read and compare */proc gchart data=prdsale; vbar product / sumvar=actual group=quarter subgroup=product ; run; /* solution asked */proc sgpanel data=prdsale;panelby quarter / columns=2;rowaxis…"
Wednesday
Peter Timusk replied to Taylor Brown's discussion January 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"Part 2 not quite solved PROC SQL;   CREATE TABLE WORK.HEALTHDATA2 AS    SELECT t1.Patient_ID,           t1.'Admission Date'n,           t1.'Discharge Date'n,           t1.'Institution From Number'n,           t1.'Institution From Type'n,…"
Wednesday
Peter Timusk replied to Taylor Brown's discussion January 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"Reply 1 This is just my date  values cleaning work program. PROC SQL;   CREATE TABLE WORK.HEALTHDATA2 AS    SELECT t1.Patient_ID,           t1.'Admission Date'n,           t1.'Discharge Date'n,           t1.'Institution From Number'n,          …"
Wednesday
Herve Momo replied to Taylor Brown's discussion January 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"/* Using SAS 9.4 University edition*/FILENAME REFFILE "/folders/myfolders/27JAN2016/Jan27ProgrammingChallenge.xlsx" TERMSTR=CR; PROC IMPORT DATAFILE=REFFILE DBMS=XLSX OUT=WORK.Data; GETNAMES=YES; sheet="Data";RUN; /* macro to…"
Tuesday
Taylor Brown added a discussion to the group Friends of SAS Programming Problems
Thumbnail

February 3rd 2016 Problem Solutions

Please post your solutions to the February 3rd problem here, thank you!See More
Tuesday
John Lam replied to Taylor Brown's discussion January 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"Thanks Arthur.  I actually learned about this date format from one of your sessions and I thank you for it.  Now I need to put my think cap on."
Tuesday
Shirley Li replied to Taylor Brown's discussion January 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"Hi olayinka, The time is from one hospital discharge to the next. Therefore, it should be from the discharge_date of one observation and the admission date of the next observation for the same patient. Each observation is a discharge. Patients…"
Tuesday
olayinka awoyemi replied to Taylor Brown's discussion January 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"PROC IMPORT DATAFILE="H:\SAS\Jan27ProgrammingChallenge2.xls" OUT=WORK.Jan27ProgrammingChallenge2 REPLACE DBMS=XLS; SHEET="Sheet1"; GETNAMES=YES;RUN; /* -------------------------------------------------------------------- PROC…"
Tuesday
Martha Casanova liked Mark Morreale's blog post Big Data Competitions require Big Commitment
Tuesday
Martha Casanova liked John Lam's blog post What Value Does SGF Bring Your Company?
Tuesday
Arthur Tabachneck replied to Taylor Brown's discussion January 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"@John: Apparently, anydtdte only considers the first 3 characters of the month name. Try the following: data test;  informat date anydtdte20.;  format date date9.;  input date &;  cards;Janmary 1, 2015Febbral 5, 2015Marching…"
Monday
John Lam replied to Taylor Brown's discussion January 27th 2016 Problem Solutions in the group Friends of SAS Programming Problems
"Just one comment: informat ANYDTDTE somehow recognizes 'Janary' as January, which made my life a lot easier."
Monday

Forum

Need a tutor in Montréal

Started by Mathieu Mireault in General Discussions. Last reply by Aroop Ghosh Nov 25, 2015. 1 Reply

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

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

libname issue

Started by Anne Xu in General Discussions. Last reply by Christopher Battiston Oct 4, 2015. 1 Reply

Hi,I have just installed SAS UE and I try to run :libname test1 '/myforders'Could anyone help me, please? The log shows:1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;5556 libname test1'/myfolders'5758 OPTIONS NONOTES NOSTIMER NOSOURCE…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