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
- 10437 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you know about symput and symget?
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
What is SAS? What are the functions does it performs?
What is the role of administrative users? : sas-grid-administration
Explain bmdp procedure?
what are some differences between proc summary and proc means? : Sas programming
What is the difference between where and if statement?
What system options would you use to help debug a macro? : sas-macro
Mention what is SAS data set?
What are the statements in proc sql?
Explain by-group processing?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
What are types of transport files?
