Answer / chandrakanth

proc sql;
create table dataset-name as select distinct(variable-name),list-all-the-variables-you-want from dataset-name;
quit;

please let me know if you have any questions

Answer / naveen

data aaa;
input P_Id LastName $ FirstName $ City $;
cards;
1 Hansen Ola Sandnes
2 Svendson Tove Sandnes
3 Pettersen Kari Stavanger
;
run;
proc sql;
select distnict(city)
from aaa;
quit;

what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.

1 Answers   TCS,

---

explain about various caches available in data integrator? : Sas-di

0 Answers  

---

What data sets do you need to produce the report?

2 Answers   Novartis,

---

Explain the difference between nodup and nodupkey options?

0 Answers  

---

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

0 Answers  

---

In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;

1 Answers  

---

What is PROC in SAS?

0 Answers  

---

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

0 Answers  

---

What is by-group processing?

0 Answers  

---

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

0 Answers  

---

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

0 Answers  

---

How to Rename Library?

3 Answers  

---