SAS to excel
Hello, I used ODS to output data as an excel file. In the file there
is a field with numbers like '95-1234',
'03-2345', etc. However, when I opened the file in excel, it displays
a date for these numbers. What do I need
to do to keep numbers the way they should be? TIA
Here is the code to output the data:
ods html file='/projects/example.xls' style=minimal;
proc print data=test;
ods html close ;
With this kind of transfer sometimes it is necessary to send Excel
formatting a particular item....
Try something like this in your proc print.....User Entered Data(Read Only Data) to Excel
I am new to Ruby, new task has been given to me by the company and they
asked me to use ruby for it
1. Capture the User Entered data's in a webpage which is Readonly
( Data's can be in Text, List, Radio button, Check box)
i need to capture the datas present in above fields and export to Excel
with column heading.
People please help me to solve this problem
i dont know how and where to start
Posted via http://www.ruby-forum.com/.
...the data that is in the table is from excel, so the data to be read can changed?
for example the data before is EXEC 1,how if i'll changed the value to
1 how can i read those data if he changed the EXEC 1 to 1. that's why
i said the data is changeable.
can you give me a simple example about this?
thank you for your help, but how if EXEC 1 can
be EXECUTE 1 of EXE 1. I use the scan from string and it only reads
EXEC, EXECUTE and EXE not 1 and space. Either EXECUTE 1, EXEC 1, EXE 1
and 1 can be the value that can get from excel.
The string parse example is working at LV 7.0, I'm using LV 6.1.
...read data from 2 excel sheets and write both into 1 excel sheet
Greetings. Let me explain this a bit. I am wondering what would be the best way to go about this.
I have 2 small Excel spreadsheets. I want to be able to read the first 5 cells in the first row from each spreadsheet.
I then want to write the data from those 2 sheets into a third different spreadsheet starting in different columns.
I do not have the Excel Report set. I was hoping to do this with active X, but I'm not sure if this can be done.
Hi RLemo, yes it is possible. See this thread for more informatio...Problem in reading excel sheet data from sheet .How to usw this data for further for identification of model
1)I have CSTR data for Two In put Two Out put System(Temp, Flow).
Data is in Excel sheet format(stored in PC desk top).
I have use xlsread function (by giving correct path ) to read data .It gives me error.
what should I do now to read my excel sheet data.
2) After getting the data from excel sheet .I want to find the model of this process. So is " iduidemo " will be helpful for me. In iduidemo file type is .sid how to create .sid file from excel sheet. data.
3) Is there any other way to find first order plus delay time model using process react...How to Read data from excel file without converting a excel file into .csv or any other format
Can somebody suggest me how to read from an excel file (consisting of 10 work sheets) to an array?
it's right that you can use activeX. (For example with rhe report generation toolbox from ni) But there are some problems:
1. You have to have excel installed on the targed PC. (to get the ActiveX interface)
2. There exists different "Microsoft Excel x.x Object Library Version x.x" which have different methods and properties. If a costumer has an other version, it could be that it doesn't work.
3....how to read data from EXCEL
I need to read data from EXCEL worksheets in this way:
The script perl asks me to write a number .
I type a Number f.e. 1000 , the script should look for the number 1000
excel worksheet file and if it find it, should capture all the other
numbers reported in the raw where there is the number 1000.
the mother number (1000) is always in the first colomn of excel sheet.
col1 col2 col3 col4 col5
raw1 900 002 004 006
raw2 1000 345 445 888 777
once the script had found the wanted number (1000) in the raw2 col1 ,
it giv...Reading excel data
I have generated a "dat" file from a mathematica simulation. I then
brought the data back into Mathematica to graph using the code below.
All of this worked fine. Then, when I did a few manipulations in excel
on the "dat" file (adding a column of data) and resaved the file as a
tab delimited file as it was before my manipulations, the code below
does not work. I get the following error messages.
Transpose::nmtx: The first two levels of the one-dimensional list
cannot be transposed
Part::partw: Part All of the Transpose... does not exist.
I did not manipulate at...READ DATA IN EXCEL
I made a SAS code to read some data in an excel file. It works fine.
However, I have data in the excel spreadsheet up to line 61. However,
SAS reads data until line 147 (it reads until line 147 but considers
for analysis only the first 60 data, which is correct). Dou you know
how I can teel SAS to read only the first 60 data? Please, see my code
below. Thanks in advance for any help (sorry if it is a simple
question, but I am new to SAS).
PROC IMPORT DBMS=3DEXCEL OUT=3DWORK.FABIO REPLACE