Aptech Systems, Inc. Worldwide Headquarters
Aptech Systems, Inc.
2350 East Germann Road, Suite #21
Chandler, AZ 85286
Ready to Get Started?
Request Quote & Product Information
Training & Events
Step-by-step, informative lessons for those who want to dive into GAUSS and achieve their goals, fast.
Have a Specific Question?
Q&A: Register and Login
Premier Support and Platinum Premier Support are annually renewable membership programs that provide you with important benefits including technical support, product maintenance, and substantial cost-saving features for your GAUSS System or the GAUSS Engine.
Join our community to see why our users are considered some of the most active and helpful in the industry!
Where to Buy
Recent Tagsapplications character vectors CML CMLMT Constrained Optimization datasets dates dlibrary dllcall error error handling errors Excel file i/o floating network GAUSS Engine graphics GUI hotkeys installation Java API license licensing linux loading data loops matrices matrix manipulation Maxlik MaxLikMT Memory multidimensional array optimization Optmum output PQG graphics procs RAM random numbers string functions strings structures threading Time Series writing data
Time Series 2.0 MT
Find out more now
Time Series MT 2.1
Find out more now
loading csv and xls data files
Please let me know how to load the data file named "breaks.csv" in GAUSS.
I tried to load breaks.xlsx following http://www.aptech.com/resources/tutorials/loading-variables-from-excel-into-gauss/
But it is not working.
That tutorial that you reference shows you how to add some files to a GAUSS library and how to write a procedure to load columns of an Excel file into GAUSS with the column headers as variable names.
Basic reading of data from an excel file
Let's suppose that we have a file called breaks.xls. It has 100 rows of data from cell A1:A100. You can load the data from this file into a variable like this:
file_name = "breaks.xls"; cell_range = "A1:A100"; sheet_num = 1; vls = ""; myvar = xlsReadM(file_name, cell_range, sheet_num, vls);
of course you do not have to create variables for the name of each input. Also, if you only specify a starting cell, GAUSS will read in all the data starting from the cell that you specifiy. Therefore, this code below will also read in the 100 rows of data the same as above:
myvar = xlsReadM("breaks.xls", "A1", 1, "");
Reading in data from a CSV file
Now let's suppose that we have a file named breaks.csv. Lets suppose that this file has 120 rows and 2 columns. You can read in the data like this:
load myvar[120, 2] = breaks.csv;