Interested to Buy Any Domain ? << Click Here >> for more details...
how do u test a pros sql(works or not) without executing it?
- 1 Answers
- 11189 Views
- DELL, HSBC, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 29 Yes | 0 No |
Mention what is PROC in SAS?
data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat
In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)
8 Answers GSK GlaxoSmithKline,
how many types of prompts are there? : Sas-bi
What is the difference between SAS Data step and SAS PROC SQL, and which is better?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
What are common programming errors committed in sas
how to perform paired t-test using Base/SAS & SAS/Stat?
What are the prime responsibilities of data integration administrator? : Sas-di
IS SAS COMPILER OR INTERPRETER? EXPLAIN?
3 Answers Aon Hewitt, HSBC, SCL, TCS,
Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.
Teradata 
