topic Re: duplicate date into single record in SAS Programming

duplicate date into single record

radha009 — Tue, 17 Apr 2018 16:18:22 GMT

please help me how to display one record per name as data below

name chg1 chg2 chg3 ID

abc 12 12

xyz 33 33 33

xyz 33 33

expecting:

name chg1 chg2 chg3 ID

abc 12 12 12

xyz 33 33 33

Thank you

Re: duplicate date into single record

SuryaKiran — Tue, 17 Apr 2018 16:27:13 GMT

Use update statement:

DATA WANT;
UPDATE HAVE(obs=0) Have;
by Name;
run;

Re: duplicate date into single record

radha009 — Tue, 17 Apr 2018 16:46:58 GMT

i got 0 observations.

Re: duplicate date into single record

novinosrin — Tue, 17 Apr 2018 16:51:40 GMT

@radha009 , The code given by @SuryaKiran is correct. Post your log please

data have;
input name  $  chg1     chg2            chg3              ID;
datalines;
abc         12              .   .                           12
abc            .             12                .                  12
abc            .             12                 .                  12
 xyz          33              .                  33               33
 xyz            .             .                      33               33
 ;

DATA WANT;
UPDATE HAVE(obs=0) Have;
by Name;
run;


99   DATA WANT;
100  UPDATE HAVE(obs=0) Have;
101  by Name;
102  run;

NOTE: There were 0 observations read from the data set WORK.HAVE.
NOTE: There were 5 observations read from the data set WORK.HAVE.
NOTE: The data set WORK.WANT has 2 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds

BTW did you sort your dataset?

Re: duplicate date into single record

radha009 — Tue, 17 Apr 2018 17:04:01 GMT

Thank you all.