how to display duplicated observations in a data using base
sas.
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
Can you execute macro within another macro? : sas-macro
what is the use of proc contents and proc print in sas? : Sas-administrator
What is substr function?
How to specify variables to be processed by the freq procedure?
What is the role of sas grid administrator? : sas-grid-administration
Describe the ways in which you can create macro variables?
what do the pad and dim functions do? : Sas programming
What are the differences between proc means and proc summary?
Mention the validation tools used in SAS?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
How are numeric and character missing values represented internally?
How necessary is it to be creative in your work?
Mention sas system options to debug sas macros.
Explain proc univariate?
Describe a time when you were really stuck on a problem and how you solved it?