https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497681#M131999 <P>Doesn't the ANYALPHA() function return a numeric result? How is PROC FORMAT supposed to use that function to generate a character string?&nbsp; Make an INFORMAT instead.</P> <PRE>236 proc format ; 237 invalue anyalpha other=[anyalpha()] ; NOTE: Informat ANYALPHA has been output. 238 run;</PRE> Fri, 21 Sep 2018 04:41:24 GMT Tom 2018-09-21T04:41:24Z https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497675#M131995 <P>i wanted to create one format but it gave error see like below&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/23435i43A8FAB90C7EBA7E/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Fri, 21 Sep 2018 04:21:34 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497675#M131995 thanikondharish 2018-09-21T04:21:34Z https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497677#M131997 <P>It looks like you have a very old version of SAS, where this syntax was not supported.</P> <P>&nbsp;</P> <P>Run&nbsp;&nbsp;<FONT face="courier new,courier">%put &amp;sysvlong;</FONT> and report here.</P> Fri, 21 Sep 2018 04:28:53 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497677#M131997 ChrisNZ 2018-09-21T04:28:53Z https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497681#M131999 <P>Doesn't the ANYALPHA() function return a numeric result? How is PROC FORMAT supposed to use that function to generate a character string?&nbsp; Make an INFORMAT instead.</P> <PRE>236 proc format ; 237 invalue anyalpha other=[anyalpha()] ; NOTE: Informat ANYALPHA has been output. 238 run;</PRE> Fri, 21 Sep 2018 04:41:24 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497681#M131999 Tom 2018-09-21T04:41:24Z https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497683#M132001 <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/159">@Tom</a> it works for me. <BR /> Fri, 21 Sep 2018 05:04:32 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497683#M132001 ChrisNZ 2018-09-21T05:04:32Z https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497864#M132125 <P>When the OP format is valid syntax it returns '0' or '1' for the formatted value.</P> <P>Of course you can't do calculations with the result very well...</P> Fri, 21 Sep 2018 15:17:40 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-format/m-p/497864#M132125 ballardw 2018-09-21T15:17:40Z