Help using Base SAS procedures

subsectioning the data

Reply
Regular Contributor
Posts: 161

subsectioning the data

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.
Super User
Posts: 11,343

Re: subsectioning the data

> 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.
Occasional Contributor
Posts: 14

Re: subsectioning the data

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
Regular Contributor
Posts: 161

Re: subsectioning the data

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
Regular Contributor
Posts: 161

Re: subsectioning the data

Thank you all

ballardw suggestion worked I actually used this:

data new_data (keep=A1 A2 A3);
set old_data (OBS=35);
run;
Ask a Question
Discussion stats
  • 4 replies
  • 212 views
  • 0 likes
  • 3 in conversation