Answer / pratik

proc import
datafile='D:\Dropbox\SAS\testfile1.txt'
out=data_imported dbms=dlm replace;
getnames=NO;
run;

proc export
data=data_imported
outfile='D:\Dropbox\SAS\testfile2.txt' replace;
run;

Answer / learning sas

FILENAME EXTERNAL1 'PATH';
FILENAME EXTERNAL2 'PATH';
Proc import DATAFILE=EXTERNAL1
OUT=XYZ REPLACE;
GETNAMES=YES;
RUN;
DATA _NULL_;
FILE EXTERNAL2;
SET XYZ;
PUT _ALL_;
RUN;

Answer / sas developer

DATA _NULL_; 
INFILE 'C:FILESINPUT.TXT' MISSOVER TRUNCOVER; 
INPUT BLOCK $100.; /* This is length of the record. Change to suit your file*/
FILE 'C:FILESOUTPUT.TXT';
PUT BLOCK;
RUN;

Answer / harshit

use proc export

Mention the validation tools used in SAS?

0 Answers  

---

How can sas program be validated?

0 Answers  

---

What is the difference between an informat and a format? Name three informats or formats.

13 Answers   Accenture, IBM,

---

What is the basic structure of a sas program?

0 Answers  

---

Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   Oracle,

---

How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values?

2 Answers   BoA,

---

whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?

1 Answers   Accenture,

---

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?

6 Answers   Accenture,

---

How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?

1 Answers   Student,

---

What are the advantages of using sas?

0 Answers  

---

what is Enterprise Guide?what is the use of it?

2 Answers   CitiGroup, Oracle,

---

How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

2 Answers  

---