Author: fangya

SAS ANYALPHA Function

SAS day 56: ANYALPHA  Background Story: Once we had an excel sheet with an extreme variety of date formats that don’t make sense. Is there a method to clean the data so they will be meaningful dates? Raw Data: Solutions Ideas: After observing the data structure, we notice it either starts with a letter or number. Therefore, we will apply…

Proc Export +Proc Report to Fancy Excel Output

SAS day 55 Background Story: Once we need to generate an Adverse Event listing for the medical team to review in excel, I was amazed by my colleague’s colorful output from SAS. I was just simply happy to look at the output! Example: I will use SAS.cars to generate the output   SAS Code:   *—————————–*; * To generate excel…

Essentialism

book 8: essentialism i read this book back in Feb, didn’t write the summarization until today. I almost forgot about it, until recently, i have been working in my home. At the beginning, i had an amazing schedule about doing work, yoga, practice violin… then i found out, i barely got any of these done. Even sadder, i did less…

Social media & sharing icons powered by UltimatelySocial