how to import a excel with format into sas?

[France]

dear all, 

I have imported an .XLSX file into SAS by the following code,

proc import datafile = 'C:\Users\70660\Desktop\Datastream_GB.xlsx' OUT=sa_step5.DATASTREAM_GB1 DBMS=XLSX replace;

Sheet='Total1';
RANGE='A1: I16458';
GETNAMES=YES;
run;

But I confuse what should I do if I expect to define the FORMAT of the variable during the proc import step. could you please give me some suggestions? 

thanks in advance.

[Kurt_Bremser · Accepted solution]

If you want to control how data is imported into SAS, you must not use the Excel file format. Export your data to a text file from Excel, and read that with a data step where you can set attributes as you please.

[Vince_SAS]

It would be helpful if you could post a workbook with sample data, explain the results that you got, and explain the results that you want.

Vince DelGobbo

SAS R&D