topic Re: Keeping Nth Column in SAS Programming

Keeping Nth Column

SAShole — Mon, 14 May 2012 15:00:28 GMT

I have a dataset that looks like this:

CBG tru1-tru100.

where cbg is a unique identifier tru is an array with a label that identifies its monthly date.

i want to pull the data together into quarters, so i want every 3rd column for tru1-tru100.

Any Ideas?

i was thinking about transposing and then using the mod function.

Re: Keeping Nth Column

FriedEgg — Mon, 14 May 2012 15:17:41 GMT

data foo;

length cbg tru1-tru100 8;

run;

proc sql noprint;

select name into :names separated by ' '

from dictionary.columns

where libname='WORK'

and memname='FOO'

and substr(name,1,3)='tru'

and mod(input(substr(name,4),3.),3)=0;

quit;

data bar;

set foo;

keep &names;

run;

Re: Keeping Nth Column

Linlin — Mon, 14 May 2012 15:23:20 GMT

data have;

id =22;

array q(*) q1-q30;

do _n_=1 to dim(q);

q(_n_)=1; end;

run;

%macro test;

data want;

set have;

keep id %do i=3 %to 30 %by 3;

q&i %end;;

run;

%mend;

%test

proc contents data=want;run;

Re: Keeping Nth Column

SAShole — Mon, 14 May 2012 16:02:50 GMT

Thanks FriedEgg & LinLin.

@LinLin I never knew that you could put a do loop in a keep statement!

Re: Keeping Nth Column

Haikuo — Mon, 14 May 2012 16:28:46 GMT

Hi Jeffrey,

What LinLin has used is not a regular 'do loop', instead, it was a Macro loop, which, for one, you can only use it inside a macro; for two, you can literally put it any where inside macro. Its purpose is nothing but to render a 'text string'.

Regards,

Haikuo