topic Re: determining corrent column in SAS Programming

determining corrent column

milts — Fri, 15 May 2009 07:55:07 GMT

hi

is there a way to determine the current column being read by sas and the stop reading the current record and go to the next one?

let's say main table contains 10 columns. i want to read only columns 1-5.

and what if i want to read columns 1-5,then 6-10?

data x;
set main;
.
.
run;

thanks a bunch!

Re: determining corrent column

Peter_C — Fri, 15 May 2009 08:57:38 GMT

yes.
but with so many possibilities and so little information about your data I thìnk the best advice for you would be to read up on infile options COLUMN, LRECL and a lot of examples of the INPUT statement.
It is one of the richest parts of the SAS language functionality. imho

PeterC

Re: determining corrent column

ChrisNZ — Wed, 20 May 2009 05:13:57 GMT

You have a set statement there, not an infile statement.

If this is what you mean, sas reads all columns at once. Read the about the program data vector in the online doc.

Re: determining corrent column

deleted_user — Wed, 20 May 2009 11:28:31 GMT

Hi,

To control observations we can use _N_ which stores the observation number which sas is processing. you can subset your dataset by writing conditions on _N_.

and there are two direct options FIRSTOBS,OBS

if you set FIRSTOBS option to 6 and OBS to 10
sas starts reading from 6th observation to 10 th observation

Hope this will help you,

Regards,
skm