how to display duplicated observations in a data using base
sas.
- 13 Answers
- 28718 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / prakash hullathi
use frequency procedure with single column
data dups;
input var1;
datalines;
1
2
3
4
4
3
5
6
;
run;
proc freq data=dups;
tables var1/norow nocol nopercent;
run;
The output will be like this
var1 frequency cumulative frequency
1 1 1
2 1 2
3 2 4
4 2 6
5 1 7
6 1 8
here the observations for the variable var1 3 and 4 are
appered 2 times and remaining appeared for 1 time by
seeing the frequency of corresponding variable and
observation
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is snowflake schema? : Sas-di
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
What is the role of sas grid administrator? : sas-grid-administration
for what purpose would you use the retain statement? : Sas programming
How will you generate test data with no input data?
what has been your most common programming mistake? : Sas programming
Explain how you can debug and test your SAS program?
If money were no object, what would you like to do?
Explain data step in SAS
Describe the function and untility of the most difficult SAS macro that you have written.
explain the main difference between the nodup and nodupkey options? : Sas-administrator
This entry was posted in General. Bookmark the permalink. Post a comment or leave
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
What are the functions which are used for character handling functions?
