proc import - how to define char or numeric as char
in [SAS]
|
Prev: New book announcement: Discovering Statistics Using SAS by Andy Field & Jeremy Miles
Next: The use of estimate statements in proc mixed
From: zespri on 25 Nov 2009 20:28 Hi a few columns in Excel include both char and numeric, eg. variable date includes 10022009 (most of them in this format) and 10/02/2009 and 10.02.2009 variable language includes English, Japanese, and 14, 19 (their code) list are very long, and I have a few Excel file to import into SAS. when I use proc import, it can't input these variables properly. May I ask how can I define them as character in the proc import process? then, I can handle them in SAS (as I have a lot of variables, using input variable name takes too much time) Thank you |