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
- 9970 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
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
Enlist the functions performed by sas.
What is the command used to find missing values?
Mention what are the data types does SAS contain?
what versions of sas have you used (on which platforms)? : Sas programming
Explain input and put function?
What do you understand by the term Normal Distribution?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
Tell e how how dealt with..
what does the run statement do? : Sas programming
Mention common programming errors committed in sas ?
What are the features of SAS?
How would you define the end of a macro? : sas-macro
How do you define proc in sas? : sas-grid-administration
What is proc sort?
