Tag: format

Import .Rdata to SAS, along with Labels

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) […]

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 format from dataset

data fmt(keep=fmtname start label);&nbsp &nbsp &nbsp set temp;&nbsp &nbsp &nbsp fmtname=”TRTFMT”;&nbsp &nbsp &nbsp start=trtgrp;&nbsp &nbsp &nbsp label=trtlbl;run;proc format library=work cntlin=fmt;run;=================TEMP:trtgrp&nbsp &nbsp &nbsp 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…