Answer Posted / arish kumar

e.g the date is '05/09/2007'

we can use the input function to convert this string into SAS date i.e.
date='05/09/2007'
sasdate=input(date,mmddyy10.);

Also, we can use mdy function.For this first use substr function.

m=substr(date,4,2);
d=substr(date,1,2);
y=substr(date,7,4);
sasdate=mdy(m,d,y);

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

1088

---

What is the difference between one to one merge and match merge? Give an example.

1057

---

How do you control the number of observations and/or variables read or written?

1245

---

What are the statements in proc sql?

1096

---

Give e an example of..

2091

---

what are the considerations when picking a SAS/STAT procedure?

3365

---

what is sas metadata repository? : Sas-bi

1110

---

where are dashboard components are created and maintained? : Sas-bi

1008

---

How are numeric and character missing values represented internally?

1652

---

How does proc sql work?

1070

---

What are the new features included in the new version of SAS Programming Language?

1202

---

What is the difference between input and infile statement?

1162

---

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

1007

---

how to read the variables in sas? : Sas-administrator

1012

---

How do you connect the desktop application to metadata server? : sas-grid-administration

1083

---