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 |
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What can you learn from the SAS log when debugging?
What are the differences between sum function and using “+” operator?
How is character variable converted into numeric variable and vice versa?
what are different analysis datasets you created and what are the new variables created
How sas treats the dsd delimiters?
what is the SAS/ACCESS and SAS/CONNECT?
9 Answers Accenture, iFlex, TCS,
If you could design your ideal job, what would it look like?
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm