topic Re: how to import a excel with format into sas? in SAS Programming

how to import a excel with format into sas?

France — Wed, 16 Jan 2019 14:48:48 GMT

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.

Re: how to import a excel with format into sas?

Kurt_Bremser — Wed, 16 Jan 2019 15:24:09 GMT

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.

Re: how to import a excel with format into sas?

Vince_SAS — Wed, 16 Jan 2019 23:36:51 GMT

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