topic Re: How to Obtain **OTHER** Format values ??? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107057#M258593 <HTML><HEAD></HEAD><BODY><P>Yes, my output is correct. but i need the expected output.. Since i will be using some process based on that dataset..</P></BODY></HTML> Fri, 14 Jun 2013 08:31:17 GMT suraestar 2013-06-14T08:31:17Z How to Obtain **OTHER** Format values ??? https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107055#M258591 <HTML><HEAD></HEAD><BODY><P><STRONG>How to Obtain **OTHER** Format values ???</STRONG></P><P>Consider the below code</P><P><BR />proc format;<BR /> value first<BR /> 2='Two'<BR /> 3='Three';</P><P> value final<BR /> 1='One'<BR /> other=[first.];<BR />run;</P><P><BR />proc format library=work cntlout=formats;<BR />run;</P><P><BR />Dataset content from format dataset.</P><P><SPAN style="color: #575757; text-decoration: underline;"><STRONG>Expected Output:</STRONG></SPAN><BR />FMTNAME&nbsp; START&nbsp;&nbsp; LABEL<BR />FINAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; One<BR />FINAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Two<BR />FINAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Three</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Actual Output</STRONG></SPAN><BR />FMTNAME&nbsp; START&nbsp;&nbsp; LABEL<BR />FINAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; One<BR />FINAL&nbsp;&nbsp;&nbsp; **OTHER**&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FIRST40.</P><P></P><P></P><P>Many Thanks...</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/11250iDB91E506E40A2804/image-size/large?v=1.0&amp;px=600" border="0" alt="Capture.PNG" title="Capture.PNG" /></BODY></HTML> Fri, 14 Jun 2013 07:01:18 GMT https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107055#M258591 suraestar 2013-06-14T07:01:18Z Re: How to Obtain **OTHER** Format values ??? https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107056#M258592 <HTML><HEAD></HEAD><BODY><P>Your FINAL format says to display 1 as 'One', with any other value displayed using the FIRST. format.&nbsp; This means that 2 and 3 will be formatted as 'Two' and 'Three', whereas other numbers will be displayed as they are stored, due to not being included in the FIRST format.&nbsp; The OTHER statement covers all other values, not just those included in the FIRST format, therefore your cntlout output is correct</P></BODY></HTML> Fri, 14 Jun 2013 08:06:48 GMT https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107056#M258592 Keith 2013-06-14T08:06:48Z Re: How to Obtain **OTHER** Format values ??? https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107057#M258593 <HTML><HEAD></HEAD><BODY><P>Yes, my output is correct. but i need the expected output.. Since i will be using some process based on that dataset..</P></BODY></HTML> Fri, 14 Jun 2013 08:31:17 GMT https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107057#M258593 suraestar 2013-06-14T08:31:17Z Re: How to Obtain **OTHER** Format values ??? https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107058#M258594 <HTML><HEAD></HEAD><BODY><P>You either need to detail the specific values in the format statement (2,3 = [first.])</P><P>or use the FIRST format values as well as those from FINAL in the cntlout output.</P></BODY></HTML> Fri, 14 Jun 2013 10:55:18 GMT https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107058#M258594 Keith 2013-06-14T10:55:18Z Re: How to Obtain **OTHER** Format values ??? https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107059#M258595 <HTML><HEAD></HEAD><BODY><P>Thanks Keith...</P></BODY></HTML> Fri, 14 Jun 2013 11:15:14 GMT https://communities.sas.com/t5/SAS-Programming/How-to-Obtain-OTHER-Format-values/m-p/107059#M258595 suraestar 2013-06-14T11:15:14Z