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 are the difference between the sas data step and sas procs?
what is program data vector? : Sas-administrator
If you could design your ideal job, what would it look like?
One way of creating a new variable in Macros is by % Let....What is the other way..?
what are the sites did u refer for enquiries and doubts for SAS
Under what circumstances would you code a SELECT construct instead of IF statements?
you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.
Describe what are the different levels of administrative users in sas? : sas-grid-administration
How would you combine 3 or more tables with different structures?
What is the function of output statement in a SAS Program?
what is the difference between informat$8. $char8.
describe the interaction table in sas di? : Sas-di