Answer Posted / shruthi

data DatasetName(drop = If any);
infile 'Path\CSVFileName.csv' delimiter = ',' ;
informat Var1 $2.;
informat Var2 anydtdte21.;

format Var1 $2.;
format Var2 anydtdte21.;

Input
Var1 $
Var2 $;

run;

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1167

---

Explain what Proc glm does?

633

---

for whom is sas data integration studio designed? : Sas-di

556

---

Difference between sum function and using “+” operator?

602

---

What are the applications primarily used by business analyst? : Sas-bi

552

---

---

What are symget and symput? : sas-macro

731

---

Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1205

---

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

552

---

how do you test for missing values? : Sas programming

579

---

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

581

---

what are 5 ways to perform a table lookup in sas? : Sas-administrator

763

---

What is the difference between where and if statement?

619

---

What are the features of SAS?

576

---

How long can a macro variable be? A token? : sas-macro

715

---

explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

542

---