Answer / amit gupta

you have 2 different ways for that.
1. using Noexec option
2 using Validate option

Noexec option checks the all queries written in proc sql
step while Validate checks only single query.

syntex:
Proc sql noexec;
create table stu as
select name from student;

create table emp as
select empname from employee;
quit;

In this example noexec will check the syntex of both query.

proc sql;
validate
select * from emp;
validate
select * from stu;
quit;

In this validate will check each query individually.

what is TAB delimiter? explain about it? what will you do to get TAB delimiter?

3 Answers   Cap Gemini,

---

i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?

6 Answers   GSK,

---

What is the one statement to set the criteria of data that can be coded in any step?

4 Answers   Accenture,

---

Briefly describe 5 ways to do a "table lookup" in sas.

4 Answers   Quintiles,

---

wt is a-z and a--z?

3 Answers   Accenture,

---

what is chi-square test? have you used that?

1 Answers   Accenture, Quintiles,

---

Explain proc univariate?

0 Answers  

---

how can you import .csv file in to sas? : Sas programming

0 Answers  

---

/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;

1 Answers   Emerio,

---

what is sas data set?

0 Answers  

---

how to debug and test the sas program? : Sas-administrator

0 Answers  

---

How experienced are you with customized reporting and use of Data _Null_ features?

4 Answers   Oracle,

---