Members

Blog Posts

Hack 4.14 Running System Commands from a SAS Program

Posted by Michael A. Raithel on February 27, 2017 at 8:59am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue

Hack 4.13 Reversing Character Strings with the REVERSE Function

Posted by Michael A. Raithel on February 20, 2017 at 9:18am 0 Comments

SAS Programming Professionals,

Check out this hack: …

Continue
 

Latest Activity

Aroop Ghosh replied to Natasha Ulanowski's discussion February 22 - Programming Problem in the group Friends of SAS Programming Problems
"Thanks Cristina!"
9 hours ago
Jean-François Ducré-Robitaille replied to Natasha Ulanowski's discussion February 22 - Programming Problem in the group Friends of SAS Programming Problems
"Here is my code : FILENAME REFFILE 'C:/SAS/FoS/ADVSFebruary22.xlsx'; PROC IMPORT DATAFILE=REFFILE DBMS=XLSX OUT=ADVS; GETNAMES=YES;RUN; PROC SORT DATA=WORK.advs; BY USUBJID ADT;RUN; DATA WORK.advs2; SET work.advs; BY…"
9 hours ago
Cristina Anton replied to Natasha Ulanowski's discussion February 22 - Programming Problem in the group Friends of SAS Programming Problems
"Really nice solution Aroop!"
9 hours ago
Profile IconCristina Anton and Karim Rahim 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
9 hours ago
Michael A. Raithel posted a blog post

Hack 4.14 Running System Commands from a SAS Program

SAS Programming Professionals,Check out this hack: http://michaelraithel.blogspot.com/2017/02/hack-414-running-system-commands-from.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…See More
10 hours ago
Karim Rahim liked Warren Woermke's video
Friday
Horst Wolter replied to Natasha Ulanowski's discussion February 22 - Programming Problem in the group Friends of SAS Programming Problems
"proc import OUT=ADVS DATAFILE= "C:\ADVSFebruary22.xlsx" DBMS=xlsx replace ;GETNAMES=YES;run; title "Vital signs Analysis Population";proc tabulate data=ADVS f=10.2 noseps order=data;class USUBJID TRTP PARAM AVISIT ADT;by…"
Friday
Profile IconKarim Rahim, Corey Harris and Rob Willcox joined SAS Canada Community
Friday
John Lam replied to Natasha Ulanowski's discussion February 22 - Programming Problem in the group Friends of SAS Programming Problems
"  Data visitdata;   length subjID $6. treatment $4.;   informat visitDate date9. heartRate 2.  height_cm 6.2 weight_kg 5.2;   Infile Datalines Missover DELIMITER=',';   input subjID $…"
Friday
Aroop Ghosh replied to Natasha Ulanowski's discussion February 22 - Programming Problem in the group Friends of SAS Programming Problems
"Proc Report solution here:"
Thursday
Arthur Tabachneck replied to Natasha Ulanowski's discussion February 22 - Programming Problem in the group Friends of SAS Programming Problems
"Couldn't find a way to get SAS UE to capture the program path (thus hard coded it) and couldn't find a way to eliminate the by group headers. Other than that, the result comes close to that shown in the problem statement: title…"
Thursday
Mukul Pandey replied to Martha Casanova's discussion February 15 - Programming Problems in the group Friends of SAS Programming Problems
"Third one is/was the correct correct one. While copy/pasting we just need to pay heed to the single quotes. Replace 'em with " or ' and then u can see that third time is the lucky one."
Thursday
Natasha Ulanowski added a discussion to the group Friends of SAS Programming Problems
Thumbnail

February 22 - Programming Problem

Please post your solutions to this week's problem here. The dataset needed to complete the problem is attached below. Thank you! See More
Feb 21
Robert Schultz is now a member of SAS Canada Community
Feb 21
Arthur Tabachneck replied to Martha Casanova's discussion February 15 - Programming Problems in the group Friends of SAS Programming Problems
"i disagree! Noone can come between Carol and Ted: 56 data _null_; 57 IF ('TED' < ('ALICE' < 'BOB') < 'CAROL') THEN PUT '2 TRUE LOVE'; 58 IF ('ALICE' < 'BOB') <= ('CAROL' < 'NoOne') <= ('TED' = 'TED') THEN PUT '2a TRUE LOVE'; 59…"
Feb 16
Bruce Densmore replied to Martha Casanova's discussion February 15 - Programming Problems in the group Friends of SAS Programming Problems
"My results are attached below for reference. Only the third statement brings “TRUE LOVE”. Which begs the question ... “Why?”. All the elements are character so it is just alphabetic order (collating sequence).…"
Feb 15
Scott Wile replied to Martha Casanova's discussion February 15 - Programming Problems in the group Friends of SAS Programming Problems
"data _null_;IF ('TED' < 'ALICE' < 'BOB' < 'CAROL')THEN PUT 'TRUE LOVE';IF ('TED' < ('ALICE' < 'BOB') < 'CAROL')THEN PUT 'TRUE LOVE';IF ('TED' < 'ALICE') < ('BOB' < 'CAROL')THEN PUT 'TRUE LOVE';run; Only the expression…"
Feb 15
Estela Lutero Tavares posted a blog post

Favortie tip

One of my favorite tips came from y supervisor. Always write your comments on every step of the program. As we are always using the same variables, it saves time to keep the codes in a library so programing is more fun, as the repetitive coding can be than using copy and paste. I guess that is most of us do...a lot of copying and pasting. So keep your library simple and organized.See More
Feb 15
Matt Malczewski posted a status
"Saskatoon leads off the Western user group sched on Tues, March 14th. Agenda details: http://www.sas.com/en_ca/events/2017/q1/saskmar17.html"
Feb 15
John Lam replied to Martha Casanova's discussion February 15 - Programming Problems in the group Friends of SAS Programming Problems
"The third one will show 'TRUE LOVE' and here is why: IF ('TED' < 'ALICE' < 'BOB' < 'CAROL') --> false as 'TED' not < 'ALICE' IF ('TED' <…"
Feb 15

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