07-24-2014 11:14 AM
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?
07-24-2014 11:22 AM
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.
07-24-2014 11:40 AM
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"