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 |
Differentiate between ceil and floor functions.
How to limit decimal places for the variable using proc means?
Explain the difference between informat and format with an example.
what are different type of sas servers ? On which server does the sas code execute ?
how to read raw data in sas. Do it manually and throw the programming.
What is the difference between input and infile statement?
How would you identify a macro variable? : sas-macro
why a stop statement is needed for the point= option on a set statement?
What does proc print, and proc contents are used for?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
What other SAS features do you use for error trapping and data validation?
Explain the use of proc print and proc contents?