SAS

Proc SQL 'Or' statement use
Have Table 1: Index NCP1 rx1 NCP2 rx2 NCP3 rx3 aaaaa 5465 1111 5465 1222 5465 1223 bbbbb 8889 1225 8889 1555 8889 1545 Table2: NCP RX OTHERINFO 5465 1111 red 5465 1222 yellow 5465 3333 blue 8889 1225 red 8889 1555 yellow 8889 3323 green ... 26 Jan 2010 20:05

duplicate records data into single row
Hi , I have a dataset with records like ID VI Var1 Var2 Var3 1 1 . 23 . 1 1 21 . . 1 1 . . 24 I want this to be in one row something like ID VI Var1 Var2 Var3 1 1 21 23 24 Any suggestion on how to make this possible? Appreciate your time and he... 27 Jan 2010 00:29

Partial Nesting in Proc Mixed - Follow Up
For those interested: I found an article that describes how to account for partial nesting in linear mixed models. Bauer, D. J., Sterba, S. K., & Halfors, D. D. (2008). Evaluating group based interventions when control participants are ungrouped. Multivariate Behavioral Research, 43, 210–236. The authors we... 26 Jan 2010 10:55

Use of the SYSINP= System option on z/OS
Does anyone have any information on how to use the SYSINP= system option? Although this option is documented all the way up to SAS 9.2, the actual interfacing between SAS itself and the program specified with the SYSINP= option appears not to be documented. Does anyone have a code sample they would be willing ... 26 Jan 2010 05:27

A odd result about indexw function.
Dear SAS-Lers, I find some interesting thing about indexw function. why I get the odd result. data a; length string $20; string='BBSI_EXT_0_COMMENT'; pos=indexw(upcase(string),'COMMENT','_'); put pos=; run; I got "pos=0". if i use string='BBSI_EXT_0_COMMENT_'; it's ok. ... 25 Jan 2010 20:44

ODS HTML output from multiple input locations
Hello, I am sort of overhauling a program that creates multiple html output files using ODS statements. These files are the result of several different SAS programs that are run by another SAS program via a series of macro include statements. What I would like to accomplish is a single piece of html output tha... 25 Jan 2010 16:13

Access to OLEDB Question
I'm using the following libname to access a Foxpro database: libname dmsysdb oledb init_string='Provider=VFPOLEDB.1;Data Source=H:\DB\DATAMST\3\DATA\data.DBC'; When I do this, variables that have missing values are coming back as zero. This causes and issue since we can't distinguish between missing and an actual... 25 Jan 2010 16:13

grouping medical procedure codes using ranges of codes
hi ... instead of merging files, how about using the grouping file to make a format ... I'm assuming your 3rd line is incorrect and data file always is the start then end of a group (if not, then you could modify the following to check for that condition and reverse the start/end of the groups) data fmt; retain... 25 Jan 2010 16:13

need info regarding forecasting presentation
Hi All, This is Anusha, working as Programmer Analyst. Actually i have to give one presentation on SAS Forcasting in Retail domain. Can you suggest me how to do this one (i have to highlight technically ) -- Thanks & Regards, Anusha.A ... 25 Jan 2010 13:56

Proc SQL help needed please.
I am attempting to create a new table using proc sql that takes all the records from test_table and inner join it with items table on cust_id. What I want to end up with with is a table that contains 1 record for each cust_id, and the flag_id associated with the min(order_date) returned after the order_date of... 25 Jan 2010 12:47