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.
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 |
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Explain bmdp procedure?
what is pdv? how it is related to input buffer in sas?
. Which date advances a date, time or date/time value by a given interval?
how do you test for missing values? : Sas programming
Differentiate between ceil and floor functions.
One way of creating a new variable in Macros is by % Let....What is the other way..?
wat is sas? is a package or programming language?
Explain the difference between informat and format with an example.
: and & modifiers.
How many ways to overcome a missing values???
Describe what are the different levels of administrative users in sas? : sas-grid-administration