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

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1536

---

What is the difference between reading data from an external file and reading data from an existing data set?

1174

---

How can you limit the variables written to output dataset in data step?

1315

---

How is character variable converted into numeric variable and vice versa?

1171

---

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1043

---

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1036

---

What is PROC in SAS?

1053

---

How you can read the variables that you need?

1123

---

What are the five ways to do a table lookup in sas? : sas-grid-administration

1059

---

Explain append procedure?

1081

---

How to limit decimal places for variable using proc means?

1110

---

how to remove duplicates using proc sql?

1146

---

explain the key concept of sas? : Sas-administrator

992

---

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

2715

---

how many types of prompts are there? : Sas-bi

1077

---