IMPORT particular columns and rows only

[jhh197]

Hi ,

I have an excel file which looks like below A1 and it has data from A TO G  and i want to create a sas dataset A2  which has A TO C coloumns only and also from row3  Can anyone pls help

A1 (EXCEL)

sales01	sales01	sales01	sales04	sales05	sales06	sales07
PS	CV	CC
ID	item1	item266
0	236	456
0	236	456
1	321	333
2	254	222

A2 (SAS DATASET)

ID	item1	item266
0	236	456
0	236	456
1	321	333
2	254	222

[Reeza]

What version of SAS are you using? Have you tried specifying the Range option? You will need to know the exact range ahead of time though. 

[SASKiwi]

If your column headings don't change you could import exactly the columns you require using the LIBNAME statement with the EXCEL engine (assuming you have SAS/ACCESS to PC Files) and using a DATA step or SQL.