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.
Answer Posted / 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 |
Post New Answer View All Answers
How are numeric and character missing values represented internally?
Explain what is the use of proc gplot?
What are the 3 components in sas programming?
what is ae onset date n what is RDS
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
For clinical entire study how many tables will create approx?
How do you debug and test your SAS programs?
is data integration and etl programming is same? : Sas-di
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
what is the function of catx syntax? : Sas-administrator
explain about various caches available in data integrator? : Sas-di
Which command is used to perform sorting in sas program?
What is the purpose of trailing @ and @@? How do you use them?
What are the ways to do a “table lookup” in sas?
In proc transpose and data step with arrays which one you pick?