topic Re: subsectioning the data in SAS Procedures

subsectioning the data

R_A_G_ — Fri, 08 Apr 2011 15:56:18 GMT

Hello,

I have two related problems.

1) I have a data set with 100 observation I only need the first 15 of them.

2) next only need 5 variables of the 14 variables

I used KEEP statement but my data came out with the wrong order. These are binary data and I need to keep the order the way it was in the original data.

Thanks
R.A.G.

Re: subsectioning the data

ballardw — Fri, 08 Apr 2011 20:34:25 GMT

> Hello,
>
> I have two related problems.
>
> 1) I have a data set with 100 observation I only need
> the first 15 of them.

on the set statement ( or just about anywhere you have a DATA= use the OBS= option

Data newdata;
set olddata (obs=15);
run;

Also look at FIRSTOBS.
>
> 2) next only need 5 variables of the 14 variables
>
> I used KEEP statement but my data came out with the
> wrong order. These are binary data and I need to keep
> the order the way it was in the original data.

Which order? Sort, as in row order, or columns in a dataset. If the latter I wouldn't worry about as other applications that may want the data would either link to the variable name or when you export the data then specify the column order.

Re: subsectioning the data

piggy — Sat, 09 Apr 2011 08:10:36 GMT

you can use retain to reorder your variables

data new (keep=name height weight);
retain height weight name;
set sashelp.class;
run; Message was edited by: piggy

Re: subsectioning the data

R_A_G_ — Sat, 09 Apr 2011 14:40:40 GMT

Thank you for the suggestions.

but I want to keep the same order (sort) as the original data. my problem is that once I KEEP the desired variables they get sorted by the KEEP variables.

thanks

Re: subsectioning the data

R_A_G_ — Sat, 09 Apr 2011 15:20:56 GMT

Thank you all

ballardw suggestion worked I actually used this:

data new_data (keep=A1 A2 A3);
set old_data (OBS=35);
run;