Build Collateral Damages


If you read this article, you are lucky enough to read your bills without asking your mum or your colleagues, read the books and magazines you enjoy and even more, you can write to your beloved ones. You’re autonome.

When it comes to a programming language like SAS, being analphabet means you depend on someone to extract the information you’re looking for. You have to specify your needs without even knowning how to phrase your demand. Things goes back and forth without much improvement and take ages. You’re frustrated. You cannot check your hypothesis. You’re limited to your actions. You have to stick to what is given to you whether it it good or not. Your hands are tide.

Stage 1

Being enough knowledgable to conduct basic tasks and phrase your demand in a meaningful way.

At this stage, you can evaluate if the langage you’ve picked up is something you could enjoy.

But there this little voice which tells you that you need something more. You can do better. You want to be confident in your code. You don’t want to be the machine repeating similar tasks over and over again. You want the machine to work for you.

Stage 2

Mastering is the way to enjoyment. you get more passionnate as you can handle the tool efficiently. You now deliver en enjoy fixing things as issues occurs, learning new things.

It’s time to be proactive, adapt and develop solutions specific to your industry. The goal? What about reducing the stress your colleagues are facing when completing some tasks? Let’s build solutions to identify issues, simplify processes, provide accurate, reliable outputs in a consistent, automatic manner. Illustrate your ideas with minimum viable solutions rather than having to specifiy to someone else. Learn from every experience to get your team better and better at what they do. Make them proud of themselve.

Stage 3

Stage 3 is about having the team to work as one.

Building Collateral Damages

So if you’re a manager, xxformat value is just about working with people and for people. That’s it.

But you know what? It’s how you get your best team, a dedicated team which provide high quality output in a timely manner. You best team is the one who want to anticipate issues, standardize, automate to be stress free when it comes to meet deadline when delivering outputs.

I want to learn SAS Programming

Ask ChatGPT

99 prompts to learn SAS programming

Email is your Trigger

From Knowledge to Skills

Applied to the SAS Programming Language


Office Collection: Reference Manuals

  • Topics selection and contents structure is based on 10-year experience in clinical research
  • Make it easy to read and reproduce examples
  • Multiple Access Options:
    • Online Read Access: Have access to the documentation wherever you are (Office, Home-Office, Transportation)
    • Printed Version: Annotate the documents


Mind Mapping

Tip Sheets:

  • proc datasets

Fill the Gap Handout

Before the lessons

Discovery: Investigate programs, logs and outputs to learn by experiencing, question your discovery and formulate assumptions

Overview Kick-Off Sessions

During the Lessons

Lesson Goal

Lesson Gap-Fill+Quizz

After the lessons

  • Submit code (examples provided in the office collection)
  • Pros and Cons: Put into parallel syntaxes: question on previous syntaxes while learning new ones
    • sorting using proc sort vs. sorting using proc sql
    • transposing using proc transpose vs. sorting using arrays
  • Extend existing code
  • Fix issues (log + 40 series)
  • Use cases (maillib)
  • Adapt templates
    • Create an Excel file
  • Create Snippets
    • Header

  • Test code
  • Validate code
  • Double programming

Self-Evaluation, Diagnosis

  • Be able to retrieve the information from the lecture notes
  • Dealing with one program
    • Identify errors
    • Create your own program with syntax guidance
    • Create your own program without any syntax guidance
  • Dealing with multiple programs
    • Create a projet across
    • Validate a projet

External Evaluation

Matrix for management

by Senior manager (GPP)

Use Case

  • Exploire your data before conducting any statistical analysis
  • Build a table from TFL

Team, Build Interactions

  • Webinar:
    • present a function or set of functions: index vs. find
    • present a function or set of functions: put, input
    • _n_
    • filename + file/infile
    • Macro Approach vs. Data Step Approach
    • ods trace on;
    • Coloring with proc report
    • Multiple approaches to solve the same issue: no. of observations in a datasets
    • Multiple approaches to solve the same issue: create macro variables
    • smallest, proc univariate, proc rank
    • metadata: proc contents, dictionaries and functions
  • Code review
    • Forum: publish some code and ask for feedback of other programmers in the team
    • Catch bugs
    • Make sure your code is readable and maintainable
      • Is it easy for other people to read it? Do they understand what you’re doing?
    • Junior can learn from senior by reading their code
    • Senior can give feedback by reading juniors code