https://communities.sas.com/t5/SAS-Enterprise-Guide/Switching-off-formats/m-p/40532#M4862 You can use varying techniques with the SAS FORMAT statement, such as:<BR /> <BR /> FORMAT _CHARACTER_ ;<BR /> FORMAT _NUMERIC_;<BR /> FORMAT _ALL_ ;<BR /> FORMAT MYVAR: ;<BR /> <BR /> See example execution below.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <BR /> 24 data x;<BR /> 25 retain a 'A' b 100;<BR /> 26 format a $HEX2. b hex4.;<BR /> 27 putlog _all_;<BR /> 28 run;<BR /> <BR /> a=41 b=0064 _ERROR_=0 _N_=1<BR /> NOTE: The data set WORK.X has 1 observations and 2 variables.<BR /> <BR /> <BR /> 29 data y;<BR /> 30 set x;<BR /> 31 format _all_ ;<BR /> 32 putlog _all_;<BR /> 33 run;<BR /> <BR /> a=A b=100 _ERROR_=0 _N_=1<BR /> NOTE: There were 1 observations read from the data set WORK.X.<BR /> NOTE: The data set WORK.Y has 1 observations and 2 variables. Fri, 25 Jun 2010 16:29:11 GMT sbb 2010-06-25T16:29:11Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Switching-off-formats/m-p/40531#M4861 Hi,<BR /> <BR /> When opening up data tables, I often need to look at the underlying codes of a variable. I know you can change the format of a column to nothing in read write mode to see the underlying variable lables, but is there a quicker and easier way to switch off formatting so you see the underlying values?<BR /> <BR /> Thanks,<BR /> <BR /> Nick Thu, 24 Jun 2010 23:33:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Switching-off-formats/m-p/40531#M4861 nrose 2010-06-24T23:33:15Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Switching-off-formats/m-p/40532#M4862 You can use varying techniques with the SAS FORMAT statement, such as:<BR /> <BR /> FORMAT _CHARACTER_ ;<BR /> FORMAT _NUMERIC_;<BR /> FORMAT _ALL_ ;<BR /> FORMAT MYVAR: ;<BR /> <BR /> See example execution below.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <BR /> 24 data x;<BR /> 25 retain a 'A' b 100;<BR /> 26 format a $HEX2. b hex4.;<BR /> 27 putlog _all_;<BR /> 28 run;<BR /> <BR /> a=41 b=0064 _ERROR_=0 _N_=1<BR /> NOTE: The data set WORK.X has 1 observations and 2 variables.<BR /> <BR /> <BR /> 29 data y;<BR /> 30 set x;<BR /> 31 format _all_ ;<BR /> 32 putlog _all_;<BR /> 33 run;<BR /> <BR /> a=A b=100 _ERROR_=0 _N_=1<BR /> NOTE: There were 1 observations read from the data set WORK.X.<BR /> NOTE: The data set WORK.Y has 1 observations and 2 variables. Fri, 25 Jun 2010 16:29:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Switching-off-formats/m-p/40532#M4862 sbb 2010-06-25T16:29:11Z