Is there a way that I can have SAS check each variable to determine if it should be character, or numeric and the appropraite length? I currently use the import wizard then copy from the log and modify it as needed, but with many files to read in, this get very time consuming.
if compress(start_date_char) ne '' then
start_date = input(start_date_char, ddmmyy10.);
start_date = .;
if compress(account_number_char) not in ('-', '?', '') then
account_number = input(account_number_char, 8.);
account_number = 0;
Then DROP the _CHAR variables. In this manner, you can trap any data exception from Excel and handle it exactly the way you want. You can also check field lengths. But you'll need to write SAS code.
Message was edited by: Roddy