Hi Allstat
I have an issue.. I am using the ODBC with proc sql. This is my code
proc sql noprint;
connect to odbc
as atest (noprompt="DRIVER=Microsoft Excel Driver (*.xls);
DBQ=xxxxx.xls;");
create table day4 as
select * from connection to atest
(
select * from "abc tensile test 6-2-11.is$"
);
disconnect from atest;
quit;
Now the excel file reads in, but in my original data file I have some values
for id that have 201 202 203 R201 R202. So SAS gives me missing values for
all the character variables but reads in only numeric.
How do I define conversion of numeric to character variable inside my data
step above in proc sql.
Any help is appreciated
Thanks
You may leave the list at any time by sending the command
SIGNOFF allstat
to [log in to unmask], leaving the subject line blank.
|