Search results for query: *

Hi, Kindly provide me with some definition and one example for the following: 1. %str() 2. %nrstr() 3. %quote() 4. %nrquote() 5. %bquote() 6. %nrbquote() Thanks for any response in advance! Wouter Hupkes Business / Risk Analyst wphupkes@gmail.com

I hope someone can help me with the following: I like to eliminate the obs when they are greater than age>=ag1 by id. See below for the input set. id age ag1 1 1 . 1 2 2 1 3 . 2 1 1 2 2 . 2 3 . 3 1 . 3 2 . 3 3 3 3 4 . I've used the following code already: data test1; set test; by id; if...

Hi, I was wondering if anyone could help me out with the following question. I've written a program in Base 9, with multiple data steps (and proc prints / reports). The outcome is based on the input variables, as stated at the beginning of the program (the &LET statements). Maybe useful to...

Hi all, From Base 9.X, I didn't had any problem sending an e-mail (with attached PDF for example, created by ODS PDF). Now I'm using the program session from SAS Enterprise Guide, and I'll get the following error statement by executing the program as presented below: NOTE: The file MAILBOX...

Hi, I hope anyone could help me out with the following. I want to read multiple files (from 1 till 30), placed in 1 dir, with the use of macro's (best way to do this I think). But... my version of the program only generates errors (by the way; I haven't looked yet for a solution to go over the...

Hi, I've created a (SAS) SQL query, but this generate a warning ("Function LEFT requires at most 1 argument(s). The extra one(s) will be ignored."). In Management Studio the query (this part) works great, but not in SAS. Can anyone see the problem? The 'faulty' part: WHEN...

Hi all! Should be a simple task, but I don't get the code right... I want to know (and FLAG) if a record contains a 1 time number or if there are other records with the same number. So I've got a dataset like: 1 text 2 text 2 text 3 text 4 text 4 text 4 text I want to create a 'FLAG', so I...

All, I've got a datastep in which I extract a number from a string. But... The strings are changing from time to time, but only the first part before the word "Incident" (sometime there appear some numbers, but I don't need those). So what I can do, is make 2 datasteps with the statements...

Hello, I've got a dataset in which I want to remain everything after a particular word, like "debtor". Like: ID | Variable_1 1 xxx debtor profile 7 2 x debtor profile 3 to 1 3 xx debtor profiles 133 to 155 4 xxxx debtor profile 3 So the final result would be: ID | Variable_1 1...

All, I've got a table with multiple variables, an incident date and id's which can occur more than once. The incident date changes every time an incident occur. Like: ID | Incident txt || Incident Date 1 A 01-01-2008 1 A 05-03-2008 1 B...

Hi all, I've got the following problem: My customers can be provided with serveral profiles. These profiles, ofcourse, can change in time per customer. In my database this is stored as "Customer has changed from 'Profile 21' to 'Profile 2'". These changes are recorded with a date on the same...

Hello all, I'm a newbee at SAS, and I'm struggling with the following problem. I've created 1 table with dates, like 2008-01-01 2008-01-02 2008-01-03 etc. And I've got another table with customer id's, incident dates and incident id's, like Customer_id | Incident dates 123 |...