SAS
in [Software]
|
Variable length when using Proc Import Jue - try this - PROC IMPORT OUT= WORK.A DATAFILE= "c:\data.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; GUESSINGROWS=3276; RUN; hth Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV... 22 Sep 2006 18:35
Normalization in SAS Is there a convenient way to normalize a set of variables, such as command "prestd" of matlab? I know that we can track the mean and standard deviation of each variable, and calculate the normalized values by subtract mean and divide standard deviation, however, this method is not concise, especially when there are... 23 Sep 2006 17:31
Converting Cobol PIC to SAS informats How do I convert the following : PICTURE S9(05)V99 COMP-3 PICTURE S9(11)V99 COMP-3. PICTURE S9(11) COMP-3. PICTURE S9(13) COMP-3. PICTURE S9(05) COMP-3. PICTURE S9(03) COMP-3. PICTURE S9(15) COMP-3. PICTURE S9(04) COMP. PICTURE S9(18) COMP. ... 14 Sep 2006 14:41
How to get Individual Region value from the macro list ??????? SAS-Learner, If you must do this drop the macro and SWL and just use a Data _Null_ step with call execute. Data _Null_ ; Set Derive.AE ; Call Execute( 'Data ' || Compress( Region ) || ' ;' ) ; Call Execute( 'Set AE( Where = ( Region = '" || Strip( Region ) || "' ) ;" ) ; Call Execute( 'Run ;' ) ; R... 14 Sep 2006 04:42
proc sql & left join & where statement I have a table tblCustomers_new and transactions tblTrans_all What I want to do is pull out all my new customers (tblCustomers_New) trans.... but only where trans_date > '15JUN2006' If I do: proc sql; select a.customer_number, b.tran_amt, b.tran_date, b.tran_c... 14 Sep 2006 05:47
SAS-to-Excel Oddity II Dimitri, I think you have to blame Microsoft for this one. I don't believe Excel can interpret a date earlier than January 1, 1900. However, as long as you don't have to manipulate the field as a date in Excel, you can get around it by sending the date as a string. For example: data test (drop=dob); inp... 10 Sep 2006 15:37
closing excel file opened with dde I have a situation where I need to use DDE to open excel files prior to running proc import to read data because the first line of data for the 8th column begins after line 800 (if the files are closed then column 8 is ignored). I can open the excel files and read the data now using DDE, but I cannot figure-out ... 7 Sep 2006 11:32
input statement with header and trailer Deb , This should give you a starting place: ata Need ; Infile Cards DLM = '~,' ; Input MBR_ID $ @ ; If MBR_ID = 'HEADER' Then Do ; Input Records Text $ ; End ; Else If MBR_ID = 'TRAILER' Then Do ; Input Records Date mmddyy10. ; End ; Else Do ; Input SRVC_DT : mmd... 6 Sep 2006 15:50
Check if macro parameter is empty Hi Yom, Your code is all right, but the contents of ¯olist are being resolved at this time and made active, leading to an illegal %IF statement. You should let the variable resolve one only and not be processed further by quoting. See also my example code to you from yesterday, then I used % QSCAN, but if yo... 5 Sep 2006 14:46
Accessing SAS ODBC DSN - Urgent Hi All, I have created one DSN for SAS (dsnsas) and one DSN for MS Access database (dsnaccess) on my machine. when I try to access sas dsn (dsnsas) from sas base I am getting followinfg error ERROR: CLI error trying to establish connection: [SAS][SAS ODBC Driver][SAS Server]178 - TCP method failed rc = ... 5 Sep 2006 09:54 |