Members

Blog Posts

Hack 4.8 Putting Your SAS Programs to Sleep

Posted by Michael A. Raithel on January 16, 2017 at 8:33am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue

Hack 4.7 Increasing the Accuracy of Age Calculations with the YRDIF Function

Posted by Michael A. Raithel on January 9, 2017 at 10:24am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue
 

Latest Activity

olayinka awoyemi replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"proc format;invalue $FiscalYear_start "Australia"='7' "China"='1';run;data have;informat country $14.;informat OrderDate date9.;format OrderDate date9.;informat OrderAmt dollar10.;input store country OrderDate…"
yesterday
Michael A. Raithel posted a blog post

Hack 4.8 Putting Your SAS Programs to Sleep

SAS Programming Professionals,Check out this hack:  http://michaelraithel.blogspot.com/2017/01/hack-48-putting-your-sas-programs-to.html               ...excerpt from my book:  Did You Know That?  Essential Hacks for Clever SAS Programmershttp://tinyurl.com/zfd67rhI plan to post each and every one of the hacks in the book to social media on a weekly basis. …See More
yesterday
Arthur Tabachneck replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"Like!"
Friday
Scott Wile replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"data have; informat country $14.; informat OrderDate date9.; format OrderDate date9.; informat OrderAmt dollar10.; input store country OrderDate OrderAmt; cards; 1234 Australia 04Apr2014 $5000 1234…"
Friday
Aurora Atienza is now a member of SAS Canada Community
Thursday
Arthur Tabachneck replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"My interpretation was based solely on the definition provided by Wikipedia (see: https://en.wikipedia.org/wiki/Fiscal_year ). Regardless, the important aspect of this problem was simply discovering how to use the intnx function to solve such…"
Jan 11
Aroop Ghosh replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"Canadian Federal Gov't FY re. today's date Art's interpretation: 2017 Aroop's interpretation: 2016 Art, I beg to differ, in my experience as an economic analyst in the Fed Gov't the practice is to use the beg period to…"
Jan 11
Bruce Densmore replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"The fiscal year can be determined by “pushing” a date forward by the number of days between the start of the fiscal year and the following January 1st. For example for the bank I once worked for FY2017 runs from NOV2016 through OCT2017.…"
Jan 11
John Lam replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"/* Assumption:                                                      */  /*   Fiscal year is the calendar year when the fiscal year starts   */  /*     Example: Fiscal year 2013 for…"
Jan 11
Arthur Tabachneck replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"Nice use of proc format, but I think you need to change one thing regarding your calculation of FX, namely: FY=intnx(cats("YEAR.",put(country,$fy_start.)), OrderDate, 0, 'E'); If you use 'B', rather than 'E',…"
Jan 11
Aroop Ghosh replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"/* China's fiscal year runs from January 1st thru December 31st and Australia's runs from July 1st to June 30. Produce a file that contains the fiscal year sums represented in the data.*/proc format;value $ fy_start…"
Jan 11
Arthur Tabachneck replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"I used proc sql: data have;  informat country $9.;  informat OrderDate date9.;  format OrderDate date9.;  informat OrderAmt dollar10.;  input store country OrderDate OrderAmt;  cards;1234 Australia 04Apr2014 $50001234…"
Jan 11
Michelle Homes is now a member of SAS Canada Community
Jan 11
Horst Wolter replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"Oops. Thanks Art!"
Jan 11
Arthur Tabachneck replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"Horst: Excellent! However, given the description of fiscal year at https://en.wikipedia.org/wiki/Fiscal_year#Australia, your code requires one change: if country='Australia' then fiscal =…"
Jan 11
Horst Wolter replied to Martha Casanova's discussion January 11 Programming Problems in the group Friends of SAS Programming Problems
"data have;informat country $14.;informat OrderDate date9.;format OrderDate date9.;informat OrderAmt dollar10.;input store country OrderDate OrderAmt;/* add code to create fiscal year */if country='Australia' then fiscal =…"
Jan 11
Martha Casanova added a discussion to the group Friends of SAS Programming Problems
Thumbnail

January 11 Programming Problems

Please post your solutions to this week's problem here. Thank you!See More
Jan 10
Arthur Tabachneck replied to Martha Casanova's discussion January 4 Programming Problems in the group Friends of SAS Programming Problems
"Good tip, but did you know that the anydtdte informat can read such dates directly? e.g.: Data trick;  infile datalines;  format Date date9.;  input Id Date anydtdte11.;  datalines;7017 11 AUG 20065002 6 MAR 20066002 18 APR…"
Jan 10
Scott Bellefeuille 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
Jan 10
olayinka awoyemi replied to Martha Casanova's discussion January 4 Programming Problems in the group Friends of SAS Programming Problems
"HOW TO HANDLE TRICKY DATES What do you do when you have a month as a character like “JAN”? How do you create a correct date in a situation like this? Let’s look an example. Data trick; infile datalines; input Id Day Month$…"
Jan 10

Forum

Do Loop?

Started by Sam Davie in Featured Discussions. Last reply by Arthur Tabachneck Nov 16, 2016. 1 Reply

Hi,I have a large dataset containing information about patients of a medical clinic, which doctor they are registered with (Registering Doctor), and which they saw on that particular visit (Attending Doctor). For each patient, I'd like to calculate…Continue

New to SAS & basic certification help please !

Started by Malcolm Ponnayan in Featured Discussions Oct 17, 2016. 0 Replies

Good Morning everyone ! I am new to SAS and to this community here online. I am planning to do my basic foundation certification with SAS. Could anyone please help me with some inputs and guidance on preparation materials, books, or any other…Continue

calling INTRR function with a dynamic number of arguments

Started by Warren Mok in Featured Discussions Sep 22, 2016. 0 Replies

Dear Sir/Madam,                I want to be able to call the function INTRR with a dynamic number of arguments. My program calls INTRR this way: EIRn = INTRR(1, -Orig_Bal %c(n)); My macro c is as follows:macro c(t);      %do i = 1 %to…Continue

Hack 3.18 Moving Catalog Entries Between SAS Catalogs

Started by Michael A. Raithel in Featured Discussions Sep 19, 2016. 0 Replies

SAS Programming Professionals,Check out this hack: …Continue

 
 
 

Photos

Loading…
  • Add Photos
  • View All

Videos

  • Add Videos
  • View All

© 2017   Created by Steve Mahoney.   Powered by

Badges  |  Report an Issue  |  Terms of Service