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
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 |
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 |
Mention sas system options to debug sas macros.
What are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
Do you know the features of sas?
What is program data vector (pdv)?
What are the main differences between sas versions 8.2, 9.0, 9.1?
Explain data_null_?
Name statements that function at both compile and execution time?
What is the use of PROC gplot?
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
What are the functions which are used for character handling functions?
How we can create SAS USER DEFINED CODE?
How would you create multiple observations from a single observation?