Interested to Buy Any Domain ? << Click Here >> for more details...
How to convert .xls file into CSV format?
- 6 Answers
- 22870 Views
- Quintiles, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manjunath wadi
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 ? | 16 Yes | 5 No |
Answer / krishna
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 ? | 6 Yes | 0 No |
Answer / paul
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 ? | 7 Yes | 3 No |
Answer / khaja
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 ? | 3 Yes | 0 No |
Answer / khaja
%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 |
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
how to delete the duplicate columns permanently in SQL
how does sas handle missing values in functions? : Sas programming
Give some examples where proc report’s defaults are same as proc print’s defaults?
Please write codes to merge two datasets and keep every record in the first dataset.
what are the best practices to process the large data sets in sas programming? : Sas-administrator
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
How do dates work in sas?
What is Linear Regression?
Why and when do you use proc sql?
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
wat has been most common programming mistake?
Teradata 
