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
- 10439 Views
- I also Faced
- E-Mail Answers
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 many types of prompts are there? : Sas-bi
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What is the difference between match merge and one to one merge?
How would you identify a macro variable? : sas-macro
What is the purpose of _character_ and _numeric_?
What are the 3 components in sas programming?
how can you put a "trace" in your program? : Sas programming
Explain data_null_?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What are the data types that sas contain?
What do you know about sas data set?
what are input dataset and output dataset options? : Sas programming
what is ae onset date n what is RDS
