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

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

1 Answers   L&T,


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

1 Answers   Accenture,


What can you learn from the SAS log when debugging?

1 Answers   Quintiles,


What are the differences between sum function and using “+” operator?

1 Answers  


How is character variable converted into numeric variable and vice versa?

1 Answers  


what are different analysis datasets you created and what are the new variables created

2 Answers   Sciformix,


How sas treats the dsd delimiters?

1 Answers  


what is the SAS/ACCESS and SAS/CONNECT?

9 Answers   Accenture, iFlex, TCS,


If you could design your ideal job, what would it look like?

1 Answers   Oracle,


i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

5 Answers   L&T,


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1 Answers  


i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

1 Answers   SAS,


Categories