topic Re: Processing data by group in SAS Procedures

Processing data by group

ZoeyElle — Tue, 15 Mar 2011 05:44:11 GMT

Sample data (4 variables)

Name Date. Remarks. Cardno
Alfred. 7/2/2011 10:41:22 AM Abcdewer. 321345
Alfred 7/2/2011 11:20:35 AM. Derdfgdsfg.
Alfred 7/2/2011 3:05:22 PM. Fsdcfgvddf
Elsie. 7/2/2011. 2:22:12 PM. Gffggffghh. 456321
Elsie. 7/2/2011. 5:45:21 PM. Sddcffdfgg.

Notice the card no for Albert only appears on the first occurence. Subsequent 2 observations has no card no. I need to ensure that cardno 321345 appears on all 3 observations for Albert. How do go about doing that?

Re: Processing data by group

Ksharp — Tue, 15 Mar 2011 06:58:29 GMT

Hi.
How about this:

data temp;

infile datalines truncover;

input Name $ Date

& $50. Remarks $ Cardno ;

datalines;

Alfred 7/2/2011 10:41:22 AM
Abcdewer. 321345

Alfred 7/2/2011 11:20:35 AM. Derdfgdsfg.

Alfred 7/2/2011 3:05:22 PM. Fsdcfgvddf

Elsie 7/2/2011.
2:22:12 PM. Gffggffghh. 456321

Elsie 7/2/2011.
5:45:21 PM. Sddcffdfgg.

;

run;

proc sort data=temp;

by name;

run;

data result;

merge temp(drop=cardno)
temp(keep=name cardno where=(cardno
is not missing));

by name;

run;

[pre]

Ksharp
[/pre]

Re: Processing data by group

yonib — Tue, 15 Mar 2011 07:24:20 GMT

You can try this:

proc sort data=your_data;
by name;
quit;

data cardno_retain(drop=Cardno rename=(Cardno2=Cardno));
set your_data;
retain Cardno2;
by name;
if first.name then Cardno2=Cardno;
run;

Re: Processing data by group

ZoeyElle — Tue, 15 Mar 2011 07:50:50 GMT

Hi Ksharp and yonib;

Will try out the suggestions. Thank you very much!

Re: Processing data by group

Peter_C — Wed, 16 Mar 2011 22:01:08 GMT

more ..
data temp;
infile datalines truncover;
input Name $ Date & $50. Remarks $ Cardnox ;
* deal with change of Name ;
Lname = lag(name) ;
if not missing(cardnox) then cardno = cardnox ;
else
if name ne Lname then call missing( cardno) ;
else
cardnox = cardno ;
retain cardno lname;
drop cardnox lname ;[pre]
datalines;
Alfred 7/2/2011 10:41:22 AM Abcdewer. 321345
Alfred 7/2/2011 11:20:35 AM. Derdfgdsfg.
Alfred 7/2/2011 3:05:22 PM. Fsdcfgvddf
Elsie 7/2/2011. 2:22:12 PM. Gffggffghh. 456321
Elsie 7/2/2011. 5:45:21 PM. Sddcffdfgg.
Blsie 7/2/2011. 2:22:12 PM. Gffggffghh.
Blsie 7/2/2011. 5:45:21 PM. Sddcffdfgg. 456321
;[/pre]
just one step needed with data is such good order need to ensure display provides two blanks before Remarks
Message was edited by: Peter.C