topic Re: [coding] adding observing order in dataset in SAS Procedures

[coding] adding observing order in dataset

Ken_oy — Fri, 16 Nov 2012 17:08:07 GMT

Hi everyone, really don't know how to search such kind of question, so I start a new discussion.

Please see the dataset below, I have colum "location" and 'L' only, I want to create a new column "order".

"L"s were repeated measurements for different "location"s. My question is how I can create column 'order' by coding? Thanks.

Linlin — Fri, 16 Nov 2012 17:12:17 GMT

data want;

set have;

by location notsorted;

if first.location then order=0;

order+1;

run;

Ken_oy — Fri, 16 Nov 2012 17:15:49 GMT

@Linlin. Thank you!!