How the Excel file enter into the SAS environment without
Code of Infile & Import procs,if i have no file Conversion?

Answers were Sorted based on User's Feedback



How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i h..

Answer / raghava pamulapati

by using pass through facility in sql we can read directly
with out conversion

Is This Answer Correct ?    11 Yes 0 No

How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i h..

Answer / ram

libname libref path='ram.xls';

Is This Answer Correct ?    2 Yes 0 No

How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i h..

Answer / ram

proc Import datafile='file path\ram.xls out=output
dbms=excel replace;
sheet='sheet$4;
run;

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More SAS Interview Questions

differnce between 8.2 and 9.1.3

1 Answers  


in data set200 observation how to take 110,150,170 using sql procedure?

7 Answers   Accenture,


What are the default statistics that proc means produce?

0 Answers  


how would you create multiple observations from a single observation? : Sas programming

0 Answers  


Have you been involved in editing the data or writing data queries?

1 Answers   BioServe, Oracle, Sasken,






how to remove the duplicates by proc sql?

2 Answers   Genpact,


what is intially documentation for a sas programmer?

2 Answers   Accenture,


name several ways to achieve efficiency in your program? : Sas programming

0 Answers  


Name and describe few sas character functions that are used for data cleaning in brief.

0 Answers  


What are the advantages of using sas?

0 Answers  


What do you know about sas and what we do? : sas-grid-administration

0 Answers  


In proc transpose and data step with arrays which one you pick?

0 Answers   Accenture, Quintiles,


Categories