iebupdte's articles:

Items(1613) /162 Next >> Last >|

Re: how to automatically remove the first two rows in the excel 0 46 (3/9/2010 9:54:16 PM) comp.soft-sys.sas Don't know if you call it automatic or not... title; On 3/9/10, wlv@air.org wrote: > Hello there, > > I used the "View in Excel" a lot when I need to read the table in > Excel. (The detail steps are: highl... iebupdte

Re: Command that runs at DOS prompt does not run when using X #2 0 35 (3/9/2010 5:26:13 PM) comp.soft-sys.sas How about using SAS and the CLIPBRD access method. Syntax FILENAME fileref CLIPBRD ; Arguments fileref is a valid fileref. CLIPBRD specifies the access method that enables you to read data from or write dat... iebupdte

Re: I didn't know format and labels could be used with 'proc 0 24 (3/5/2010 3:32:35 PM) comp.soft-sys.sas I too enjoy those moments when I say, "Wow! I didn't know that." And I�ve said that a lot since I became an active participant in SAS-L. Or when I write some program I think is "so special" and someone says "... iebupdte

Re: check for variable existence, if not there put variable in. #2 0 26 (3/3/2010 9:43:34 PM) comp.soft-sys.sas You could do it this way. Variable will default to Numeric. If it exists the type does not matter. data have; input _20093 _20094 rate $; cards; 3 1 staffing 5 2 staffing 7 3 staffing 9 4 staf... iebupdte

Re: Bug? #3 0 24 (3/3/2010 6:31:31 PM) comp.soft-sys.sas No BUG. Search as support.sas.com for "numeric precison 101" 2259 data a; 2260 a=1.11; 2261 b=a-1; 2262 d = .11; 2263 if b=.11 then c=1; 2264 put (b d)(=hex16./); 2265 run; b=3FBC28F5C28F5C30 d=3... iebupdte

Re: MACRO VARIABLE IN PROC SURVEYSELECT #3 0 25 (3/3/2010 4:22:42 PM) comp.soft-sys.sas Try REP with no double quotes.... REP=nrep specifies the number of sample replicates. If you specify the REP= option, PROC SURVEYSELECT selects nrep independent samples, each with the same specified sample siz... iebupdte

Re: Proc Export - all character variables #2 0 64 (3/1/2010 7:37:11 PM) comp.soft-sys.sas If as Art suggests you are using PROC IMPORT to import a CSV file you could automate the process of adding the extra record as you are doing now. The row of variable names should suffice for that purpose. You... iebupdte

Re: Char() vs substr() (was Re: How to - Hex IP address to dotted #5 0 18 (2/26/2010 10:49:40 PM) comp.soft-sys.sas That Y was supposed to be Z to go with zL. I was not paying proper attention to the code. Sorry about that. 1 data _null_; 2 y = 'This is a string'; 3 x = char(y,4); 4 xL = vlength(x); 5... iebupdte

Re: Char() vs substr() (was Re: How to - Hex IP address to dotted #3 0 24 (2/26/2010 8:23:01 PM) comp.soft-sys.sas 25220 data _null_; 25221 y = 'This is a string'; 25222 x = char(y,4); 25223 xL = vlength(x); 25224 y = substr(y,4,1); 25225 zL = vLength(y); 25226 put (_all_)(=/); 25227 run; y=s ... iebupdte

Re: Basic Bootstrap Macro #3 0 38 (2/26/2010 6:49:03 PM) comp.soft-sys.sas On 2/26/10, Rick Francis wrote: > Any thoughts? Ditch the macro and use the SURVEYSELECT method mentiond by "oloolo". ... iebupdte

iebupdte's replies:

Items(104) /11 Next >> Last >|

standardize data 5 23 (1/18/2012 6:59:06 PM) comp.soft-sys.sas Hello, I have a dataset which looks like date a b c d e f g I want to standardize each column so that the mean = 0 and std dev = 1. . How do i do this without having to specify each of the column names T... heenagd (155)

rename question #2 2 40 (1/20/2012 7:37:24 PM) comp.soft-sys.sas Hi, I have a question on renaming labels. If suppose I have a correlation matrix stored in dataset Corr _type_ _name_ b f n l CORR b CORR f CORR n CORR l I have another dataset ... heenagd (155)

avoiding variables in loop 2 22 (1/24/2012 10:11:22 AM) comp.soft-sys.sas Hello, here is my problem. i have a loop in my program which put a '.' everywhere datas are missing. But i don't want to apply this loop on some variables but i don't know how to do to avoid those variables. ... pierre.coste (14)

Dynamic variable reference 3 25 (1/25/2012 10:20:38 AM) comp.soft-sys.sas Hi. I think CALL SYMGET or something similar might be the answer to this, but I'm not sure how it might work. data input; input oc_1 oc_2 oc_3 oc_4 choice want 8.; datalines; .. 1 . . 3 . .. . 1 1 3 1 .... guya.carpenter (43)

proc print #7 2 52 (1/30/2012 8:44:08 PM) comp.soft-sys.sas hello sas-users, why the code below doesn t display the 0. Thanks. ash007. PROC FORMAT; PICTURE COMMAFR OTHER=3D'000 000 000 000'; RUN; DATA TABLE_BIDON; INPUT X1 X2 X3 X4 X5 $; CARDS; 0 5 5 1161 AB=C9LI... ramsamyashley (267)

Columns with Variable names to Manipulate 5 25 (2/1/2012 4:31:51 PM) comp.soft-sys.sas Here is a simple example of a table I'm working with. ColA ColB ColC MoveFrom MoveTo Amount 10 10 10 ColA ColB 5 15 20 5 ColB ColC 10 The output I ... jared.endymion.porter (7)

Generate increasing consecutive reference numbers 2 25 (2/2/2012 5:58:15 PM) comp.soft-sys.sas At the moment i have an automated job which exports data to an excel file, when this file is generated it is given today=92s date to include in the file name. As follows proc export data=3D rwork.Final outfile... bob164 (35)

ID statement in Proc summary #2 2 28 (2/3/2012 4:31:56 PM) comp.soft-sys.sas If I were to do a proc summary and use an ID statement above my class and var. What exactly would that Id statment do for my summary? Say my ID was YEAR. proc summary data= set1 nway; id year; class acct; var... chadmcrawford (26)

Alternative to CASE statement 12 25 (2/9/2012 1:24:35 AM) comp.soft-sys.sas I have been using the following case statement in this proc sql code: proc sql; create table master as select serv_month, sum(case when note_status in ('O','X',' ') and state in ('MA','RI','CT','NH','VT') the... gregtlaughlin (26)

To import a one row .txt data into hundred of rows 5 26 (7/12/2012 1:30:42 AM) comp.soft-sys.sas Hi SAS gurus, Here I have a txt file data, only one row in it. The length is very long, more than 100,000. Goal is to break it into multiple rows. It it possible to make it when I read it into SAS. ... trust10211 (8)