how to sort a huge file Hi, I have file of 1000000000 records with 2 variables. One of the variables is random number between 0 to 1. I would like to sort this file. Proc sort cannot do it (there is not enough place on the disk). Is there another way to sort this "monster"? Thanks a lot, Alex ... 25 May 2010 03:43
dlm= ? HI everyone, I have the following eg of raw file: 1102ÿÿ1ÿÿå¯ä¹Ã¿Ã¿ColaÿÿYÿÿ In unix, the delimiter seems to be ÿÿ and when I read the whole line in sas the delimiter seems to turn into ÿÿ. I need to read this file in and I am not sure what to put for the dlm option. Please help, Thank you, ... 24 May 2010 07:56
Extended deadline (15 July 2010): CACS Singapore [EI Compendex,ISTP,IEEE Xplore] [ Please forward to those who may be interested. Thanks. ] ================================================================== 2010 International Congress on Computer Applications and Computational Science CACS 2010 http://irast.org/conferences/CACS/2010 4-6 December 2010, Singapore ==============================... 23 May 2010 23:23
PROC REPORT or PROC PRINT with variables > 256 characters Hello, In the process of generating a series of tables with PROC REPORT and ODS RTF, I'd like to create a large text field containing some standard text interspersed with some values from datasets. The resulting single-cell table would look something like this: "First, I went to the VARIABLE1, and afterwards,... 23 May 2010 13:33
3 for 6? I heard a discussion which I think is a little interesting. A multinomial logistic reg has values of 1, 2, and 3 in its dependant target. Initially upon business users' request that value 3 should be default and they wanted to see 'incremental' of 1 and 2 on tope of 3, the modeler, fully aware of pros and cons of... 23 May 2010 07:03
Proc logistic: how to add constraints on variables? Hi all, I would like to add constraints in a proc logistic. Example: proc logistic data=myfile descending ; model y= x1 x2 x3 x3 x4 x5 x6 x7 x8 x9 x10 /selection=stepwise; run; and I would like to add a condition saying that in the final model, only parameters having a positive estimate would be inclu... 22 May 2010 05:09
SAS program to read text and output database I have a long text file where each line represents one of 10 different text or date variables. Each variable line starts with its own identifier (like Recnum: or Start_Date:). The variable RECNUM indicates the start of a new 10-line record; the variable Final is the last one in the record. At each encounter of RECN... 24 May 2010 16:48
Finding the variables with all missing values Hi, all I have a dataset with over 100 variables and about 20-30 variables with all values as "missing" and defined as numberic vars. Now I would like to find these variables out and then translate all the "DOT" to the "BLANK", in other words, turning them from numberic variables to character variables. Any sugg... 24 May 2010 00:28
siebel Product Confirgurator -- Atlanta GA -- 10+ Months (Please note: If you are interested in this position and you have all skills experience which mentioned in requirement, so please update your resume as per the requirement and reply me at matt(a)netprologic.com / matt at netprologic dot com) Hi, Hope you are doing well, Please find this Requirement of our D... 21 May 2010 15:00
XPT to SAS datasets HI All: I have all the datasets stored in .XPT format in a library .. how can I convert them to SAS Datasets .. I know how to do it when single dataset is present .. On my machine I have SAS Base product , SAS/Stat and SAS/Access interface to ODBC Any suggestions Thanks in advance ... 23 May 2010 14:39 |