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
- 9993 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 can be the size of largest dataset in SAS?
what is null hypothesis? why do you consider that?
Do you need to know if there are any missing values?
What are the difference between sas functions and procedures?
How to create a permanent sas data set?
What is the order of application for output data set options, input data set options and SAS statements?
what are informats in sas? : Sas-administrator
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
Differentiate between format and informat? : sas-grid-administration
What is the difference between match merge and one to one merge?
How will you generate test data with no input data?
List down the reasons for choosing sas over other data analytics tools.
Explain append procedure?
Explain the difference between using drop = data set option in set and data statement?
Enlist the syntax rules followed in sas statements.
