Hi,   Sorry, this is a question and answer board.  Even if I had the time to go over a full table output's worth of training, that code is proprietary.  The company you work for should have code libraries and plenty of examples, and you could check out the Phuse Code Library http://www.phusewiki.org/wiki/index.php?title=Standard_Scripts   ... View more

Please be a bit more specific on your question. What do you mean my "separate"?   If you mean make a varaible numeric or character the way the variable is created will set whether it is numeric or character. By default most variables will be numeric. SAS does not have any "mixed" type. A variable is either numeric or character. If you want to see the character values the variable must be character.   In a simple example such as you provide using $ after the variable name will tell SAS to read the last column as character. The default when done this way will hold a maximum of 8 characters. If you specify an INFORMAT or LENGTH statement for the varaible before use you can set the length longer to hold a longer value.   data temp1; input a b c letter $; datallines; 1 1 1 x 1 1 1 y 1 1 1 z ; run;   data temp1; Length letter $ 25; /*<= set maximumn number of characters a variable will hold to 25*/ input a b c letter $; datalines; /*<= corrected spelling*/ 1 1 1 x 1 1 1 y 1 1 1 z 2 2 2 Amuchlongerstring ; run;   or data temp1; informat letter $25. ; /*<=read variable using 25 characters*/ input a b c letter $; datalines; 1 1 1 x 1 1 1 y 1 1 1 z 2 2 2 Amuchlongerstring ; run; Also you can enclose a value in single or double quotes in an assignment statement data temp1; informat letter $25. ; /*<=read variable using 25 characters*/ input a b c letter $; anothervar = 'This is a different string value'; /*<= note that when using this approach without a Length statement the length will the that of the first value encountered in the code in this case 32*/ datalines; 1 1 1 x 1 1 1 y 1 1 1 z 2 2 2 Amuchlongerstring ; ... View more