Members

Blog Posts

Hack 3.20 Saving Duplicate Observations Removed by PROC SORT

Posted by Michael A. Raithel on September 26, 2016 at 9:12am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue

SAS & Bugs & Rock & Roll

Posted by Michael A. Raithel on September 12, 2016 at 8:31am 0 Comments

SAS Programming Professionals,

Check out my latest SAS-oriented blog:   …

Continue
 

Latest Activity

Michael Levinshtein replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"There is my solution"
1 hour ago
Kamran Jafry replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"Here is my solution; Not the most elegant,but it does th job. Wanted to get it done quickly so the code is very linear. Learnt a lot given you can go forward one record to compare to current record. I guess learning is the…"
3 hours ago
Profile IconSandra sun, Hui Wang, Claudia Cornali-Motta and 1 more joined SAS Canada Community
11 hours ago
Aroop Ghosh replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"I agree Chrome is not the ideal PDF viewer, especially when it comes to forms.  However, knowing its deficiencies, I just drag the pdf file into Chrome a window so I can do a clean copy and paste into SAS.  Anyways, i pick up up a lot of…"
17 hours ago
Arthur Tabachneck replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"Aroop, Appreciated, but I have Acrobat set as the default reader in Chrome. I'm not changing that as the Chrome reader doesn't let one complete and save forms. Besides, it just makes the programming challenges a bit more challenging."
21 hours ago
Kamran Jafry 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
21 hours ago
Aroop Ghosh replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"Hi Arthur, If you open the PDF in your browser (I use Chrome), the text formatting of the data table is maintained when you paste in SAS (I am using UE running in Chrome).  Copying it from Acrobat reader will display the behaviour you're…"
yesterday
Aroop Ghosh replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"Data Have;Input Field $ Field_Used Crop $ Start_Year End_Year;Datalines;North 1 Wheat 1960 1976North 1 Beans 1977 1993North 0 N/A 1994 2000East 1 Corn 1960 1968East 1 Beans 1969 1979East 0 N/A 1980 1981East 1 Beans 1982 2000South 0 N/A 1960…"
yesterday
John Lam replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"proc format; invalue Price 'Corn' = 3.6 'Wheat' = 3.82 'Beans' = 4.05 ; run; Data Farm; Infile Datalines Missover; input Field $ Field_Used Crop $ Start_Year End_year; obs = _n_; if Field_Used then do; Duration =…"
yesterday
Horst Wolter replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"proc format; value $grow 'Corn' = 3.60 'Wheat'= 3.82 'Beans'= 4.05 'N/A' = 0;run; data rotation;input Field $ Field_Used $ Crop $ Start_Year :4. End_Year :4.;datalines;North 1 Wheat 1960 1976North 1 Beans 1977…"
yesterday
Bruce Densmore replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"... Some elements are similar to last week's problem.  Only needed INPUT and two calculations to collect the data and initial calculations in the first pass of the data.  The "??" in the INPUT function suppresses the…"
yesterday
Michael Levinshtein commented on Mackenzie Keelan's group Friends of SAS Programming Problems
"Pr2.sas There is my solution"
yesterday
Scott Wile replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"data have; input Field $ Field_Used Crop $ Start_Year End_Year; datalines;North 1 Wheat 1960 1976North 1 Beans 1977 1993North 0 N/A 1994 2000East 1 Corn 1960 1968East 1 Beans 1969 1979East 0 N/A 1980 1981East 1 Beans 1982 2000South 0 N/A 1960…"
yesterday
Arthur Tabachneck replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"When I copy and paste the data (this week and last), it shows up with each variable for each record showing up on a separate line, thus I inputted it that way. I used two data steps after inputting the data: proc format;  invalue price …"
yesterday
Jean-François Ducré-Robitaille replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"I believe that the by statement with notsorted was the key to this challenge."
yesterday
Doug Dover replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"Took a bit, but I did fit it into one pass of the data. I rarely use the 'notsorted' option in a By statement, so, cool! Data d1;input Field $ Field_Used Crop $ Start_Year End_Year;datalines;North 1 Wheat 1960 1976North 1 Beans 1977…"
yesterday
Derek de Montrichard replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"Inelegant but works... NOTE: the format of the final two columns was unspecified... so one version is text (null = blank), the other numerical (null = .) ** data have; input Field $ Field_Used Crop $ Start_Year End_Year; if field =: "N"…"
Wednesday
Jean-François Ducré-Robitaille replied to Sean Robson's discussion September 28 Problem Solutions in the group Friends of SAS Programming Problems
"Here is my suggestion. It's perhaps long, but it produces the required output proc format; invalue crop_type 'Wheat'=3.82 'Beans'=4.05 'Corn'=3.60 'N/A' = 0;run; data field(drop=Last_Field_Used…"
Wednesday
Peter Timusk replied to Sean Robson's discussion September 21 Problem Solutions in the group Friends of SAS Programming Problems
"DATA WORK.BikeReturnData; LENGTH Family_Name $ 7 Given_Name $ 7 Rental_Plan $ 6 Rented_Out 8 Returned 8 ; FORMAT Family_Name $CHAR7. Given_Name $CHAR7. Rental_Plan $CHAR6. Rented_Out HHMM5. Returned HHMM5. ; INFORMAT Family_Name $CHAR7. Given_Name…"
Tuesday
Wei Li is now a member of SAS Canada Community
Tuesday

Forum

calling INTRR function with a dynamic number of arguments

Started by Warren Mok in Featured Discussions Sep 22. 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. 0 Replies

SAS Programming Professionals,Check out this hack: …Continue

SAS 40th Anniversary Special Programming Challenge!

Started by Martha Casanova in Featured Discussions. Last reply by Aroop Ghosh Jul 28. 12 Replies

Follow the instructions in the Exclusive Programming Challenge posted in Friends of SAS and share your solution to the challenge in this Forum.  To have access to the Exclusive Programming challenge you must have completed the Who Thinks They Are A…Continue

SAS CI 360 Video Challenge

Started by Sean Robson in Featured Discussions. Last reply by Martha Casanova Jul 15. 1 Reply

We want you to record a video about what you think the most challenging and/or beneficial aspects of SAS CI 360 are. We also want you to hear whether or not you agree with the 6 steps previously listed, and compare them to your own practices.When…Continue

Tags: 360, CI, SAS

 
 
 

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