ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
   
 
Categories  >>  Software  >>  Data Warehouse  >>  SAS
 
 


  

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
How to convert .xls file into CSV format?
 Question Submitted By :: Pankaj
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to convert .xls file into CSV format?
Answer
# 1		 It is very simple.
1. Click on "FILE" menu of the MS Excel file
2. Select "Save As" Option and click on that
3. Now you can see a dialog box "Save As", type the file
name select location to save
4. Select the option CSV(comma delimited)option from Save as
Type drop down box and click Save button.

Its Done!

Note: Only active worksheet can be saved if you are saving
your file in CSV format 
Is This Answer Correct ?    11 Yes 5 No
Manjunath Wadi
 
  Re: How to convert .xls file into CSV format?
Answer
# 2		 step#1:Import excel file into SAS
proc import datafile='file location/filename.xls'
out=datasetname dbms=excel replace;
sheet='sheetname$';
getnames=yes;
run;
step#2: Export file to csv file.
data _null_;
set datasetname;
file 'location/file1.csv';
put <var list> ;
run; 
Is This Answer Correct ?    6 Yes 3 No
Paul
 
 
 
  Re: How to convert .xls file into CSV format?
Answer
# 3		 proc import datafile=file.xls out=<datasetname> dbms=excel
replace;
sheet='sheetno$';
run;

proc export outfile=filepath data=<datasetname> dbms=csv
replace;
run; 
Is This Answer Correct ?    2 Yes 0 No
Krishna
 
  Re: How to convert .xls file into CSV format?
Answer
# 4		 in excel just go on file then press save as and then click
on save type there you will find out csv comma delimiter, 
Is This Answer Correct ?    0 Yes 0 No
Naveen
 
  Re: How to convert .xls file into CSV format?
Answer
# 5		 proc import out=<datasetname>
datafile="path\file.xls"
dbms=excel replace;
sheet='sheetno$';
run;

proc export outfile=filepath data=<datasetname> dbms=csv
replace;
run; 
Is This Answer Correct ?    0 Yes 0 No
Khaja
 
  Re: How to convert .xls file into CSV format?
Answer
# 6		 %macro imp (datasetname=,path=,fname=)
proc import out=&datasetname
datafile = "&path"
dbms = "&fname" replace;
getnames=yes;
run;
%mend;
%imp(datasetname=xyz,path="D:\docs...",fname=csv)

if you want to convert into txt,xls,mdb then simply you use

%imp(datasetname=xyz,path="D:\docs...",fname=mdb)
%imp(datasetname=xyz,path="D:\docs...",fname=txt)
%imp(datasetname=xyz,path="D:\docs...",fname=.xls) 
Is This Answer Correct ?    0 Yes 0 No
Khaja
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
What is proc sql pass through facility? L&T4
How would you remove a format that has been permanently associated with a variables?  3
i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one. CTS6
what kind of variables are collected in AE dataset? Accenture3
How would you keep from overlaying the a SAS set with its sorted version?  4
What r all the reporting procedures...?  3
how can u convert this 25-jul-2010 from numeric to charcter?  3
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?  1
what is in stream data in SAS?  1
sas implimented companies in hyderabad CTS11
How would you delete observations with duplicate keys? Accenture12
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE? HCL1
 
For more SAS Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com