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
Explain what is data step?
what versions of sas have you used (on which platforms)? : Sas programming
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
how do you want missing values handled? : Sas programming
Give some ways by which you can define the variables to produce the summary report (using proc report)?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
what is SAS OPTIMIZATION?
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.
How would you define the end of a macro?
Why double trailing @@ is used in input statement?
Approximately what date is represented by the SAS date value of 730?
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?
What are the difference between sas functions and procedures?
for whom is sas data integration studio designed? : Sas-di
What Proc glm does?