topic Re: SAS dataset not displaying variable format in SAS Enterprise Guide

SAS dataset not displaying variable format

dbillig — Thu, 24 Jul 2014 15:14:36 GMT

I Have a sas dataset where all variables have a format tied to them using proc format. However, the dataset isn't displaying those formats when I have the dataset open, it just shows the raw value. So for examle 1=male for gender variable. When I look at the sas dataset I see "1", but if I do a proc print I see "male", so I know the variable actually does have the format because it shows up in proc print.

Anyone know why the format isn't displaying when I look at the raw dataset? Is there an option in EG that toggles between seeing the raw value vs the formatted value or something?

Thanks,

Dave

Re: SAS dataset not displaying variable format

ballardw — Thu, 24 Jul 2014 15:22:20 GMT

If you have a custom format, which your result of "male" implies, you need to make sure that the library with the format is in the search path.

If you didn't place the format in a permanent library and it was created in WORK, then it was likely erased at the end of your previous session.

Re: SAS dataset not displaying variable format

dbillig — Thu, 24 Jul 2014 15:40:06 GMT

It's a format created with "proc format". It was created in work too, but it was created in my active session, I know the format is tied to the sas dataset because i can see it when doing a "proc print", so I don't think it's an issue with sas not linking them properly. It just doesn't show up when I'm looking at the sas dataset, the sas dataset shows "1", proc print shows "male"

Re: SAS dataset not displaying variable format

Lida — Thu, 26 Mar 2015 16:55:24 GMT

Hi Dave,

I have exact same problem. Did you find a solution to it?

Thanks! lidia

Re: SAS dataset not displaying variable format

SuryaKiran — Tue, 11 Oct 2016 14:47:52 GMT

I got similar ploblem and looking around for any solution.