How the Excel file enter into the SAS environment without
Code of Infile & Import procs,if i have no file Conversion?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is data step?

940


what versions of sas have you used (on which platforms)? : Sas programming

824


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3276


how do you want missing values handled? : Sas programming

735


Give some ways by which you can define the variables to produce the summary report (using proc report)?

848


what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4161


what is SAS OPTIMIZATION?

2049


I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

1933


How would you define the end of a macro?

896


Why double trailing @@ is used in input statement?

941


Approximately what date is represented by the SAS date value of 730?

994


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

925


What are the difference between sas functions and procedures?

866


for whom is sas data integration studio designed? : Sas-di

755


What Proc glm does?

856