... ... POPCoDeS
PoPCoDeS
  • About Me
Navigation bar avatar

POPCoDeS


Assistance to get you out of programming purgatory.

Turn that csv into a format using PROC FORMAT CNTLIN!

Posted on August 26, 2021

Post thumbnail
Post thumbnail
You ever had 10-45 diagnoses that you want to see, but they have some uninterpretable ICD/CPT code? [Read More]
Tags: SAS PROC FORMAT CNTLIN FORMAT PROC SGPLOT PROC FREQ SCAN COMPRESS

Splitting Strings with Delimiters in SAS

Posted on August 11, 2021

Post thumbnail
Post thumbnail
Have you ever encountered a single variable containing multiple values separated by some delimiter? [Read More]
Tags: SAS String Parsing Delimiters SCAN COUNTW DO Loop PROC TRANSPOSE

Removing Negative Prescriptions in SAS

Posted on August 7, 2021

Post thumbnail
Post thumbnail
I was talking to Dr. Brown yesterday, and he brought up an old nightmare of mine: removing prescriptions with negative quantity dispensed values. [Read More]
Tags: SAS Merge By-Group Processing PROC SORT PROC COMPARE

Creating Data-Driven Macros in SAS

Posted on August 5, 2021

Post thumbnail
Post thumbnail
Have you ever copy and pasted code for datasets ranging from 2005 to 2019? You know what I’m talking about. I’m talking about this: [Read More]
Tags: SAS Macros Data-Driven Programming

A Primer on Counting in SAS

Posted on August 4, 2021

Post thumbnail
Post thumbnail
This post is largely for myself, but I hope it can help others. [Read More]
Tags: SAS Counting RETAIN BY-GROUP Processing FIRST. LAST.
  • ← Newer Posts
  • Older Posts →
  • Email me
  • GitHub
  • Twitter
  • ORCID

Michael Q. Maguire, MS, Data Management Analyst II  •  2022  •  michaelqmaguire.com

Powered by Beautiful Jekyll