Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Can you execute macro within another macro? : sas-macro

996


what is the use of proc contents and proc print in sas? : Sas-administrator

1062


What is substr function?

1190


How to specify variables to be processed by the freq procedure?

1075


What is the role of sas grid administrator? : sas-grid-administration

1289


Describe the ways in which you can create macro variables?

1194


what do the pad and dim functions do? : Sas programming

1024


What are the differences between proc means and proc summary?

1143


Mention the validation tools used in SAS?

1181


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1151


How are numeric and character missing values represented internally?

1659


How necessary is it to be creative in your work?

2476


Mention sas system options to debug sas macros.

1177


Explain proc univariate?

1031


Describe a time when you were really stuck on a problem and how you solved it?

2550