What is proc sql pass through facility?

Question Posted / gnb.sas

4 Answers
9914 Views
L&T, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is proc sql pass through facility?..

Answer / chandu

Performing "database related queries" directly through the Proc sql is called passthrough facility.

Is This Answer Correct ?

10 Yes

0 No

What is proc sql pass through facility?..

Answer / narendra

pass through is used for accessing the table from databases.

Is This Answer Correct ?

1 Yes

0 No

What is proc sql pass through facility?..

Answer / k.padmaja

To manage external databases from sas for running
applications, in this we can use connect and disconnect
statement

Is This Answer Correct ?

0 Yes

0 No

What is proc sql pass through facility?..

Answer / xxx

PTF is used for connect to External or internal databases
like oracle, EXCEL,ACCESS.advantage of PTF is directly
connected to database means we can directly create,
delete,manipulate modify the tables in the database.

proc sql;
connect to engine_name user_name= password=**** path=' ';
disconnect from Engine_name;
quit;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SAS Interview Questions

what is validvarname and varnum? why we are using this options; explain with a syntax for this options?

1 Answers Max India,

At compile time when a SAS data set is read, what items are created?

14 Answers Accenture,

What do you feel about hardcoding?

1 Answers

libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak

7 Answers

What is the basic structure of the SAS base program?

0 Answers

Are you involved in writing the inferential analysis plan? Tables specfications?

0 Answers Wipro,

In which case u go for libname and in which case u go for proc sql pass thru facilit diff?

1 Answers

Describe how you would pass data to macro.

3 Answers

How would you define the end of a macro?

0 Answers

Code the MEANS to produce output to be used later.