@Tom
Thank you so much Tom! With the sample codes you gave me in answering my last post, I sucessfully solved the problem of importing excel tables and changing the charater variables into numeric. That saved me a lot of typing work, since I have more than 6000 excel tables of sic3 indutries and later more than 6000 sas datasets and each with around 100 variables. The original data tables in excel were named with the state name together with the sic3 codes(eg. Florida101,Texas201, NewMexico361, Massachusetts311 etc.). Since the state name and sic3 code are included in the excel table names, they are not included as variables in the original excel tables. What I want is to add the state names and sic3 code as two variables to each sas dataset. The codes I posted yesterday is to deal with this problem.
I submitted the code you provided me, but sas gives the following error message:
1 + %addvar(FlORIDA101)
22: LINE and COLUMN cannot be determined.;
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string,
a numeric constant, a datetime constant, a missing value, INPUT, PUT.
What's wrong?
... View more
