Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

if reading an external file to produce an external file, what
is the shortcut to write that record without coding every
single variable on the record

Question Posted / srinu

Answers were Sorted based on User's Feedback



if reading an external file to produce an external file, what is the shortcut to write that record..

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;

Is This Answer Correct ?    7 Yes 0 No

if reading an external file to produce an external file, what is the shortcut to write that record..

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;

Is This Answer Correct ?    4 Yes 0 No

if reading an external file to produce an external file, what is the shortcut to write that record..

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;

Is This Answer Correct ?    1 Yes 0 No

if reading an external file to produce an external file, what is the shortcut to write that record..

Answer / harshit

use proc export

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More SAS Interview Questions

How do you debug macros?

3 Answers   Accenture,

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

0 Answers  

What system options would you use to help debug a macro? : sas-macro

0 Answers  

what has been your most common programming mistake? : Sas programming

0 Answers  

How to display duplicate observations in data?

1 Answers  

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

0 Answers  

Do you need to know if there are any missing values?

0 Answers  

What is the difference between proportion and average?

0 Answers   KPMG,

What do the SAS log messages "numeric values have been converted to character" mean?

0 Answers   Quintiles,

how many types of prompts are there? : Sas-bi

0 Answers  

What are the rows present in protocol Violation table?

2 Answers   Accenture, Quintiles,

what are all the reports you generated in your recent project?

0 Answers   Accenture, Quintiles,

For more SAS Interview Questions Click Here
Categories