This thread has gone off on a tangent, but there does not appear to be any place to move the new thread to a thread of its own.  Probably because this "article" is not really a "question" to begin with.   There are two issues here.  @Rick_SAS seems to be trying to answer the question HOW to start posting a new question/thread.  That appears to be much harder now with the newest update.  When you are looking a particular board (community) you will see an orange start new topic button up to the right of the search area new the top of the page. But that button only appears when you are looking at the list of topics in a particular board. It does not show up when looking at an existing "topic".  Or when looking at the higher level folder above the board level.   The second problem is getting the system to take your new topic.  For that you need to specify a specific board to place the new topic into.  When you start the post using the Start a new Topic button from with a board  then it does work. ... View more

If you want to define your variables use a LENGTH or ATTRIB statement. The INFORMAT statement just tells SAS what default INFORMAT to use when the variable is referenced on an INPUT statement.  It is only as a side effect that it will set the type and length for a variable and then only if the variable has not been previously defined in the data step.  So if you attach a numeric informat then the variable will become type num and length of 8.  If you specify a character informat for a previously unknown variable then the type will be char and length will be the length used in the INFORMAT (or default length for that informat).  And depending on the INFORMAT this default length could be wrong.  Consider this example.  The variable ITEM2 is defaulting to length $1 and so it does not have room to store the actual values like 'Apple', proc format ;   invalue $example 'A'='Apple' 'B'='Banana' 'C'='Carrot' other='Unknown'; run; data xx;   length item1 $20;   informat item1 item2 $example1.;   input item1 @1 item2; cards; A B C D ;;;; proc print; run; ... View more

First, I am sorry to tell you that I'm a Sir, and then I 'm wonder that where do you want to export? I can give you a example as follows: data a; a=1; format a mmddyys10.; run; proc export outfile="C:\Users\Pactera\Desktop\test.txt" dbms=tab replace; run; And the results is as following: So, you can see that the results' format is what you want. ... View more