I didn’t play with SAS/IML for a while. I call it back when I need to read some R format data. Technically, .Rdata is not a data format. It’s rather a big container to hold bunch of R objects: In this example, when a .Rdata is loaded, 3 objects are included where ‘data’(the ‘real’ data) […]
Tag: format
SAS Format Viewer and Others (EG)
Today I tried to install a SAS format viewer, one of my favorite SAS AF utilities in a virtual machine, and it came out a bad news and a good news. The bad news is that the website I used to download the SAS Format Viewer (by Frank Poppe) is no longer accessible(LESSON LEARNED: make […]
How to Write a Check? Use SAS Format!
During my initial stay in US last year, one of the interesting exercises was to write a check. The Arabic numerals (the universal language!) were pretty intuitive while I didn’t feel much comfortable on spelling the face value in words: I never played the game! But the good side of this story was, as a […]
Extract the Version of SAS and OS of a SAS Format or Macro Catalog: A Little Bit of Perl Regular Expression
SAS Sample 34444(Determine the operating system in which a format catalog was created) posts piece of codes to get the version of SAS and OS of a SAS format catalog. It is useful since a SAS catalog can be only read in the operating systems same to its source machine. 2 cents add to this […]
Create a SAS dataset from FORMAT library
libname fmts “/temp/formats”;proc format library=fmts cntlout=fmts.fmtout;run;
P Value Format
PVALUEw.d
Create format from dataset
data fmt(keep=fmtname start label);      set temp;      fmtname=”TRTFMT”;      start=trtgrp;      label=trtlbl;run;proc format library=work cntlin=fmt;run;=================TEMP:trtgrp      trt…
Leading Zeroes
Here’s a situation that comes up pretty often. You receive a file that contains zip codes. It’s an excel file and you need to create a SAS data set out of it, so you can do some nifty market analysis. No problem, you clickety clickety through the SA…