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 a put statement?
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
what is AE onset date and what is RDS?
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
Are you involved in writing the inferential analysis plan? Tables specifications?
Which is the best training institute for SAS in Delhi. Please reply
which date function advances a date, time or datetime value by a given interval? : Sas programming
How can I remove header from output data set?
· What are some good SAS programming practices for processing very large data sets?
What do the PUT and INPUT functions do?