topic Re: Value labels showing in output but not in actual .sas7bdat file in SAS Programming

Value labels showing in output but not in actual .sas7bdat file

robeldritch — Thu, 09 Jul 2020 21:52:13 GMT

I'm wondering why when I run the following program (I'm running EG, 7.1), the table that opens up in the Output Data tab in EG shows the value labels ("Under 18", "18-24", or "25 and over") in the 'Age Range'n column, but when I open y.sas7bdat from the location in which I saved it, the table that is displayed just shows the value codes instead ("a", "b", or "c") for this column.

proc format;
  VALUE  $agerangef 'a' = 'Under 18'
                    'b' = '18-24'
                    'c' = '25 and over';
run;

data lib.y;
	set x;
	length 'Age Range'n $ 11;
	if age<18 & age ~= . then 'Age Range'n = 'a';
		else if age >= 18 & age<=24 then 'Age Range'n = 'b';
		else if age >= 25 then 'Age Range'n = 'c'; 
	format 'Age Range'n $agerangef.;
run;

Thanks!

Re: Value labels showing in output but not in actual .sas7bdat file

Reeza — Thu, 09 Jul 2020 16:14:16 GMT

EG has the nofmterr option set to NO, so it won't generate an error. When you double click and load the file from explorer, you're not attaching it to the format file so it shows you the raw values. If the nofmterr option was set differently it would generate an error about unfound formats.

When you open in within EG the formats are loaded and you'll see the formatted view. I wish there was a way to permanently attach formats to the data set 🙂

Re: Value labels showing in output but not in actual .sas7bdat file

ballardw — Thu, 09 Jul 2020 17:47:36 GMT

If you mean "value labels" in the SPSS sense, then you will be disappointed. SAS uses Formats, which are session based and the data set contains a reference to the default Format name. If the format is not available at the time you use the data set you may get an error (if option FMTERR is in effect) or the default format for the variable type will be used to create a display.

To use the format the SAS session that opens the file will need to know where the format definition is.Which means that either the Proc Format code has to be submitted in that session or have the format in a permanent library and use system option FMTSEARCH to tell SAS to look in that library for format information in addition to the SAS system formats.

And if you are using some other program to view the SAS data set I suspect you will be just plain out of luck.

Re: Value labels showing in output but not in actual .sas7bdat file

robeldritch — Thu, 09 Jul 2020 22:53:05 GMT

Thanks to both of you--this was driving me crazy trying to figure out!