Prev: proc report and generate frequencies based on a number of
Next: anyway to use %include() inside a pass-through query?
From: jn mao on 24 Feb 2010 15:28
Hi SAS-Ls,

I did import an Excel data, but after I import it to SAS and run contents, =
it shown some variables with 1 of Len, and $1 for Format. Actually they are=
numbers in Excel data but were set as Char type. So when I tried to conver=
t those variables from char to num, it doesn't work.=20

For e.g.
variable=A0 type=A0 Len=A0 format=A0 informat
A=A0=A0=A0 char=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=A0=A0 $1.=A0=A0 $1.

I need to convert variable A to a numeric type, how should I reformat it? I=
have 20 such variables.=A0 Can someone help me out this? Thanks much!

Jane
=0A=0A=0A
 | 
Pages: 1
Prev: proc report and generate frequencies based on a number of
Next: anyway to use %include() inside a pass-through query?