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 |
what is SAS ACCESS AND SAS CONNECT ? Give an example and data statements used.
What is factor analysis?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
Mention what is the difference between nodupkey and nodup options?
how do u test a pros sql(works or not) without executing it?
What is the use of function Proc summary?
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
how can get the first and last observations in a dataset using Proc SQl?
Under what circumstances would you code a SELECT construct instead of IF statements?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
how to generate report for 0 observation dataset?
how do u identify a macro variable