I have a spreadsheet where one column has character lengths ranging from 0 to 1000 or even more. Importing them has never been much of a problem with this code:
PROC IMPORT DATAFILE=”F:\path\to\file.xls”OUT=work.aDBMS=excel2002 REPLACE;SHEET=”Sheet1″;…
Here is another new format which is available with SAS 9 version called MMDDYY+ . (MMDDYY+ format can insert colons /slash or periods etc between date, month and year values); This new date format developed by SAS works for many other formats, for ex…
Whenever you try to open a SAS data set which has permanent formats, you will get the error message in the log file saying
“ERROR: The format XXXX was not found or could not be loaded.”
This happens generally when you don’t have the format …
I am finally ready with my SAS dataset reader/writer for .NET. It is written in 100% managed code using .NET 3.5. The dlls can be foundhere.A sample .NET console application can be found in the program file entries after the installation.Update 2/13/20…
You can do this manually or programmatically.
Manual Approach: Right click on the data set in the explorer and go to properties, then go to the details tab and see the sorted by values (Works only if you use Windows operating system) Programmatic …
Kernel method is a very useful technique in data mining that is applicable to any algorithms relying on inner product [1]. The key is applying appropriate kernel function to the inner product of original data space.
I show here SAS/STAT+BASE ex…