topic IMPORT particular columns and rows only in SAS Procedures

IMPORT particular columns and rows only

jhh197 — Tue, 28 Jun 2016 19:06:17 GMT

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

Re: IMPORT particular columns and rows only

Reeza — Tue, 28 Jun 2016 20:06:12 GMT

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.

Re: IMPORT particular columns and rows only

SASKiwi — Tue, 28 Jun 2016 20:31:05 GMT

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.