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 |
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
which date function advances a date, time or datetime value by a given interval? : Sas programming
What are the default statistics that proc means produce?
What will calendar procedure do?
Explain the special input delimiters used in sas programming.
do you prefer proc report or proc tabulate? Why? : Sas programming
Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.
What is PDV?
What is a pdv and what are its functions?
How to convert a given date value into SAS date
9 Answers CitiGroup, Quintiles,
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.