06-28-2016 03:06 PM
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
A2 (SAS DATASET)
06-28-2016 04:06 PM
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.
06-28-2016 04:31 PM
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.