magnus.mengelbier's articles:

Items(24) /3 Next >> Last >|

Re: search string #2 0 27 (4/15/2004 1:43:26 PM) comp.soft-sys.sas Hello M M Scanning a string for a character ... I would use substr() function ... the rest depends on your desired output. Two different out-s below.. HTH Magnus --------------- begin code --------------- ... magnus

Re: DO Loop query? Visit number #5 0 22 (4/7/2004 8:29:51 AM) comp.soft-sys.sas Hello Throwing in my 2 cents ... the following code lets you add a lot more logic if you wish ... as from experience it is usually not as straightforward to assign visit IDs. As it sounds like you do not have... magnus

Re: Creating macro variables from a dataset #2 0 34 (4/1/2004 12:53:37 PM) comp.soft-sys.sas Hello Renee I have been following this thread loosely ... and I do not think I have seen the array approach ... so here it is. Magnus ---- begin code ---- data _null_; /* -- begin :: data -- */ thi... magnus

Re: Saving window layout 0 26 (11/12/2003 11:05:35 AM) comp.soft-sys.sas Hello Ben The usefullness is (on Windows) under Tools -> Options -> Preferences ... under the General tab there is a check box option "Save settings on exit". HTH Magnus On Wed, 12 Nov 2003 05:35:43 -0500,... magnus

Re: [Help] Macro logic problem 0 41 (11/11/2003 4:45:14 PM) comp.soft-sys.sas Hello Ben A brief note... help is very generic ... so I changed the subject to "macro logic problem." Onto your problem ... If you are using the macro I saw posted earlier today ... which was %macro exists... magnus

Re: how to catch the .html files from the Favorotes folder into a file? #2 0 41 (11/11/2003 9:10:32 AM) comp.soft-sys.sas Hello Zibao The *.url file is a regular text file (on windows) ... so you can probably pick the url from the contents. I have not looked at this extensively but here is some very quickly tested code. HTH Mag... magnus

Re: SAS time problem and formula problem 0 27 (11/3/2003 1:09:04 PM) comp.soft-sys.sas Hello Vijay I can only answer your first question since the formula was not readable for me. (SAS-L removes attachments, incl the picture showing your formula) Consider this data step ... data in; format h... magnus

Re: Reconfigure batch submit in SAS/W2K? #2 0 30 (10/16/2003 9:31:18 AM) comp.soft-sys.sas Hello Ya You have a great idea from Wei Chang ... but if you are not interested in changing the windows "batch submit" association for your SAS programs in (1) you could try just handling the "exception" when ... magnus

Re: Read a distant MySQL database using SAS 0 39 (10/16/2003 9:17:41 AM) comp.soft-sys.sas Hello Franck A quick response after a hastened test is to use ODBC. Requirements on the SAS side is SAS/Access to ODBC and for MySQL the Connector/ODBC driver for Windows. Good luck HTH Magnus On Wed, 15 ... magnus

Re: How to transfer .net dataset to sas dataset #3 1 64 (10/15/2003 7:51:10 AM) comp.soft-sys.sas Hello I believe you have a few things to consider ... performance and simplicity. From my experience, XML is a great format but the overhead you wish to impose with the tag structure for 30 000 - 90 000 record... magnus

magnus.mengelbier's replies:

Items(13) /2 Next >> Last >|

read file 2 33 (9/4/2003 2:58:16 AM) comp.soft-sys.sas I am new to SAS and I got some simple question If I got a file: On 3 Sep 2003 at 19:12 "Name", "Year", "SocialSN" "sam", "1979", "123456789" "John" , "1989" , "123456773" I wanna ignore the 1st line I wa... lwongzlwongz (8)

Merging variables to create a rate Variable 4 39 (10/3/2003 9:07:52 PM) comp.soft-sys.sas Hi, I have a dataset that contains information on 87,471 reported burglaries. Among my variables are: REPORT # (range =1 to 87,471): Each burglary report has a distinct number - even if the same place was burg... dave.sorensen (24)

Read a distant MySQL database using SAS 2 56 (10/15/2003 12:20:09 PM) comp.soft-sys.sas Hi SAS users, Does anyone has experience in reading a MySQL database on a server using SAS on a client PC ? Thanks for your help. Franck ... franck.golliot (1)

Reconfigure batch submit in SAS/W2K? 4 33 (10/15/2003 6:00:05 PM) comp.soft-sys.sas Hi there, I'm pretty much a batch (or noninteractive) running SAS guy. I'm currently use SAS/W2K, I have three ways to batch run a SAS program: 1. Submit a program by right clicking the file name in window... yhuang (489)

SAS time problem and formula problem 2 36 (11/3/2003 11:51:14 AM) comp.soft-sys.sas Hi All, I have two problems, and I really hope you can help me. The first problem is that I want to take the Log of a time variable (format is hhmm6.), but the answer returned is wrong. I have used the follow... Vijay.Reddi (1)

A Macro Problem (ref.: SUGI Paper 100-27) 4 39 (11/11/2003 9:14:39 AM) comp.soft-sys.sas Hi out there! I found this little Macro in SUGI Paper 100-27 (Carpenter). %macro exists(dsn); %sysfunc(exist(&dsn)); %mend exists; As one can see it is very simple and it's task is easy to understand. I'm ... antoniamarija (3)

Saving window layout 4 74 (11/12/2003 10:35:43 AM) comp.soft-sys.sas Dear Sas-L, Recently I saw an option that would enable you to save the layout of your editor and output windows so that each time you open SAS they come back exactly so. How so? I can no longer find this usefu... ben.powell1 (971)

Chat to Date conversion 2 36 (11/22/2003 12:45:01 PM) comp.soft-sys.sas Hi all I'm very beginner with SAS and I have a big problem. I get data from plain-text file wich has something like: |--Col1--|-Col2-| |01052000|062000| 0105200 represent a Date in ddmmyyyy format 062000 repre... shadman (73)

DO Loop query? Visit number 4 44 (4/7/2004 4:59:51 AM) comp.soft-sys.sas Hi all, This must be so easy, but... I have a dataset with 2 variables, Patient ID number and Date of visit, sorted by ID and Date. eg ID Date of visit 1 1/1/04 1 3/1/04 1 27/1/04 2 ... laughing_beggar (62)

search string 4 31 (4/14/2004 7:47:40 PM) comp.soft-sys.sas Hi group, I need some help on finding the positions of a certain string. Suppose for variable X, I have a value '---+---+-+'. I want to find the positions of string '+' (that is 4,8,10). It is easy to use index... laihere (1)