topic Re: Formats when viewing dataset in SAS Programming

Formats when viewing dataset

deleted_user — Thu, 11 Jun 2009 17:30:13 GMT

I have a dataset with formats, 1=Male, 2=Female. When I open the dataset or use proc print, all I see is "Male" and "Female", but I would rather see the 1 and 2. Is there a way to change the options for viewing or do I have to remove the formats?

Re: Formats when viewing dataset

sbb — Thu, 11 Jun 2009 17:46:35 GMT

Specify a FORMAT statement with your variable name and leave off the output format parameter, as in:

FORMAT MY_VAR ;

Scott Barry
SBBWorks, Inc.

Re: Formats when viewing dataset

deleted_user — Thu, 11 Jun 2009 18:18:23 GMT

So is there no way to remove it when I view the dataset? Most of the time I like to just click on the dataset to view it instead of using proc print.

Re: Formats when viewing dataset

sbb — Thu, 11 Jun 2009 19:39:00 GMT

Yes, right-click on the column to change the attribute FORMAT.

Scott Barry
SBBWorks, Inc.

Re: Formats when viewing dataset

Peter_C — Fri, 12 Jun 2009 07:03:09 GMT

use sas system viewer to examine the data set.
It has a button/icons for formatted and unformatted views. It has other good features too.