Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9982 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 |
how to handle in stream data containing semicolon in it?
how many data types in sas? : Sas-administrator
what is the difference between informat$8. $char8.
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
explain the function of substr in sas? : Sas-administrator
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.
How would you keep from overlaying the a SAS set with its sorted version?
How to display duplicate observations in data?
how many display types available in sas bi dashboard? : Sas-bi
what is washout period?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
what is the usage for assigning error=1 in a dataset ?
Teradata 
