Answer / rg

proc sql;
select name, count(*)
from data
group by name
having count(*) > 1;
quit;

Answer / naveen

proc sql;
select name count
from
group by name;
quit;

What makes sas stand out to be the best over other data analytics tools?

0 Answers  

---

How do you add a prefix to some or all variables in a dataset using a SAS macro?

2 Answers  

---

proc means? proc sort? proc append? proc freq? proc print? proc content?

4 Answers   Oracle,

---

Can anyone help me about SAS Realtime scenarios in Clinical field

0 Answers  

---

How to convert a numeric variable to a character variable?

0 Answers  

---

what is the effect of the options statement errors=1? : Sas programming

0 Answers  

---

How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;

2 Answers   HSBC,

---

What are the data types in sas?

0 Answers  

---

What system options would you use to help debug a macro? : sas-macro

0 Answers  

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

0 Answers  

---

What are the Aggregate functions in SQL ?

2 Answers   AON,

---

Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.

1 Answers  

---