BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
France
Quartz | Level 8

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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.

View solution in original post

2 REPLIES 2
Kurt_Bremser
Super User

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
Rhodochrosite | Level 12

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1268 views
  • 0 likes
  • 3 in conversation