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 / 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
Can you explain the process of calendar?
How are numeric and character missing values represented internally?
What is the difference between reading data from an external file and reading data from an existing data set?
how will you locate the sas platform applications? : Sas-bi
What is SAS? What are the functions does it performs?
what r the job openings SAS for fresher graduates !
How would you determine the number of missing or nonmissing values in computations?
What are the different versions of sas that you have used until now? : sas-grid-administration
what is snowflake schema? : Sas-di
What are the parameters of scan function?
Give some ways by which you can define the variables to produce the summary report (using proc report)?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
What is the difference between proportion and average?
how many display types available in sas bi dashboard? : Sas-bi
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?