you have a data set like this.
data qqq;
input name $ total;
cards;
qq 22
ww 33
qq 22
ee 44
rr 33
ww 44
;
run;
and you want output like this.........
name total
qq 22
ww 44
Do it by data set step.
- 6 Answers
- 8231 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bharath
data abc1;
set qqq end=a;
if _n_=1 or a=1;
proc print data=abc1;
run;
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / vishal
proc sort data=qqq;
by name;
run;
data f;
set qqq;
by name;
if first.name=0;
run;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / alok karan
data qq;
do i=1 to n by n-1;
set qqq point=i nobs=n ;
output;
end;
stop;
proc print data=qq;
run;
/*Above is more efficient program to know the first and last observation */
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ashish
data op;
set qqq end=last;
if _n_=1 or last=1 then output;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bharath
data qqq;
input name $ total;
cards;
qq 22
ww 33
qq 22
ee 44
rr 33
ww 44
;
run;
data abc;
set qqq;
if total in (22,44) and name in ('qq', 'ww');
proc print;
run;
data abc1;
set abc;
by name;
if first.name;
run;
proc print;
run;
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / singh.naveen409
proc sort data=qqq;
by name;
run;
options mlogic;
data www;
set qqq;
by name;
if first.name then serial=1
run;
data wwq (drop=serial);
set www;
if serial ne '1';
run;
| Is This Answer Correct ? | 0 Yes | 5 No |
wat is sas? is a package or programming language?
how do you read binary data in sas?
What is the Program Data Vector (PDV)? What are its functions?
Can anyone help me about SAS Realtime scenarios in Clinical field
what is Enterprise Guide?what is the use of it?
How can you limit the variables written to output dataset in data step?
what is Difference between PROC SQL JOINS and MERGE?
Difference between nodup and nodupkey options?
what is conditional processing?
How would you identify a macro variable?
What statement do you code to write the record to the file?
how do we get duplicate observations in a separate dataset?
Teradata 
