BookmarkSubscribeRSS Feed
Geeman
Fluorite | Level 6

Hi SASers,

 

I have an Excel 2010 macro file that I want to import into SAS 9.3, 32bit. I want to avoid having to rename the varible name F1 F2 F3...is there a way to import the excel sheet at line 5 is the varible names and at line 6 data starts.  Is there a way to specify datarow or namerow in the following SQL? Proc import did not work to avoid F1  F2  F3...?

 

Varible name starts at line 5

Data Starts at line 6  

 

PROC SQL ;

CONNECT TO EXCEL (PATH="C:\SAS\Programs\EaxceltoSAS\filename.XLSM" );

create table Temp as SELECT * FROM CONNECTION TO EXCEL

(SELECT * FROM [sheet2$]) ;

DISCONNECT FROM EXCEL;

QUIT;

 

 

1 REPLY 1
Reeza
Super User

You can try specifying the RANGE to include the titles and the data in a PROC IMPORT

 

This user had a similar question.

https://communities.sas.com/t5/SAS-Procedures/Proc-Import-Excel/td-p/51087

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 1 reply
  • 805 views
  • 0 likes
  • 2 in conversation