Prev: 5.28: perl How can I read in an entire file all at once?
Next: SAS Macro - Is there a way to use an if statement to set two variables?
From: FPAStatman on 17 Mar 2010 14:31
Does anyone know of a way to specify different ranges in Proc Import?
For example, if I have the labels on row 2 and the data doesn't
actually start until row 15, is there a way to skip rows 3-14?

Thank you
From: montura on 17 Mar 2010 14:59
data excel;
set excel;
row=_n_;
run;

proc sql;
delete from excel
where row LT 15;
quit;
From: FPAStatman on 18 Mar 2010 10:09
Deleting rows is easy, but what if you don't want to read them, as it
can change the format that Proc Import reads? If the first 15 rows
are missing, or are filled with notes, and you only have 10 rows of
actual data to read in, then the data is set to character even if the
data are all numerical, as the majority of values are now character.
When you are reading in multiple excel sheets, and some have these
note rows, is there a way to skip the note rows to avoid multiple
character to numeric changes?

 | 
Pages: 1
Prev: 5.28: perl How can I read in an entire file all at once?
Next: SAS Macro - Is there a way to use an if statement to set two variables?