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

Donald Wildeboer replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"/* Find any location macro {{{1 */ %macro city_lat_long( table, city ); filename llg url "https://www.google.ca/search?q=lat+long+of+%sysfunc(tranwrd(&city.,%str( ),%str(+)))&source=lnt\&tbs=li:1"; /* NOTE: this could be…"
29 minutes ago
Elizabeth Snell updated their profile
13 hours ago
Scott Bellefeuille replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"with my 4 year old son super excited about the canada vs usa match tonight, he wanted me to prove that Canada was indeed the best! with the data provided, i did a very quick subset of  gold medals count for the sport ice hocokey, PROC…"
yesterday
Scott Bellefeuille replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"amazing, thanks!"
yesterday
Eshetu G. Atenafu replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"My Analysis is based on total medals won in Canada by gender and year to see the total medals trend by gender, since 1924. PROC IMPORT OUT= WORK.OLYMPICS DATAFILE= "E:\SAS\OLYMPICSDATASET.xlsx" DBMS=EXCELCS REPLACE;…"
yesterday
Richard Bemile replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"/*******************************Questions**********************/1. 1.   a. Show which cities and the year in which they held the Olympics.    b. Which country has featured the most in the games compared to the others?   …"
yesterday
Mathieu Gaouette replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"Did some nice findings. The code and results are in the attached EG project. Highlights: The overal number of countries represented (in terms of winning at least one medal) is going up with time. We would think that this would make the maximum…"
yesterday
Phillipe Ross-Siegel replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"I did some quick analysis on the number of medals countries won in cross-country skiing from 1924 - 2006. Code: proc import datafile="H:\OLYMPICSDATASET.xls" dbms = excel out = olympics; run; /* get the data */ data olympics; set…"
yesterday
Rodger Zhang replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"%macro getn(tab,dt); proc import out=&dt  datafile="C:\OLYMPICSDATASET.xlsx"   dbms=xlsx replace; sheet="&tab"; getnames=yes; run; %mend getn; %getn(Medals by Country,OLYMPICSDATASET_COUNTRY); %getn(Medals by…"
yesterday
joe mamone replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"quick sas job to look for country best medal event performance, can use to predict future performance possibilities DATA OLYMPIC; INFILE IFILE; INPUT @006 YEAR 4. @010 CITY $23. @033 SPORT $9. @042 DISCI $15. @057 CTRY $3. @064 EVENT $25.…"
yesterday
Bruce Densmore replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"I was watching the semi-final Women's Canada vs OAR hockey game while playing with this data.  I was using PROC Tabulate to see if the data told me anything, in general.  Then I switched to hockey results.  Here are the last…"
Tuesday
Jean-François Ducré-Robitaille replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"ChallengeOlympics.sas The joined code produces a graphic and print 5 tables. I looked at when events were being introduced and were held there for the last time and who won the gold medal. Beside 1924, it is in 1992 that there were relatively the…"
Tuesday
Jean-François Ducré-Robitaille replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"Very interesting. There are also three way draws, but never for gold, and always for speed skating 500 m and the last time was in 1968. "
Tuesday
olayinka awoyemi replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"My solution focused on determining whether any of the variables could predict the likelihood of winning a medal i.e. gold, silver and bronze. data medal_olym;set olym;if event_gender = "X" then delete;if medal ="Gold" then Gold…"
Tuesday
Mathieu Gaouette replied to Natasha Ulanowski's discussion February 14 2018 - Programming Problem in the group Friends of SAS Programming Problems
"The second line is missing the end semicolumn. Because of that, the input statement reads in 4 variables the last one being "datalines". Then, SAS encounters the '1 2 3' and since it's not a valid statement, it fails and…"
Tuesday
John Lam replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"proc import datafile = '/home/john.lam/OLYMPICSDATASET.xlsx' out = country dbms = xlsx replace ; sheet = 'Medals by Country'; run; proc print data=country;run; proc import datafile =…"
Tuesday
Arthur Tabachneck replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"oops! Forgot to include the country codes workbook."
Tuesday
Marc-André Thivierge replied to Natasha Ulanowski's discussion February 14 2018 - Programming Problem in the group Friends of SAS Programming Problems
"Clearly, there is a semicolon missing after the "INPUT A B C". Closing the input statement with a semicolon resolve both error messages.1st message : SAS doesn't recognize the statement 1 2 3 4 5 6 3 6 9 as it is not a valide SAS…"
Monday
Marc-André Thivierge replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"The latest Canadian Gold medal in the two-man Bobsleigh event in Pyeongchang 2018 Olympics inspired me this simple analysis. The reaction of the German and Canadian team was very beautiful to see as both were very excited winning gold medals. So I…"
Monday
Aroop Ghosh replied to Natasha Ulanowski's discussion Olympics Programming Challenge in the group Friends of SAS Programming Problems
"Thanks Art!  Wish I had waited a day more before submitting my entry :( cheers  Aroop"
Monday

Forum

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

Logsitic Regression Interaction Term

Started by Sam Davie in Featured Discussions. Last reply by SZ YAO Apr 18, 2017. 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

© 2018   Created by Steve Mahoney.   Powered by

Badges  |  Report an Issue  |  Terms of Service