SAS

please help
Hi all=2C I need some help How can I automatically generate a count for the visits of patients coming = to the clinic where every visit per patient will have visit number. If my data looks like this=3B current data pid date 1 1/1/2009 1 2/1/2009 1 4/2/2009 1 28/3/2009 2 ... 7 Sep 2009 11:06

datepart function
Whay am I getting this error message? Order_date is a daytime variable 56 proc sql; 57 create table sasdata.june_pre_period as 58 select a.oid_customer, 59 a.total_order_amount, 60 a.order_date, 61 a.store_id, 62 b... 6 Sep 2009 23:05

Keeping trailing zeros in SAS Results viewer,
A few questions. All of them pretty simple and stupid, I guess. It's tough being the only SAS programmer in a company of three hundred, though. I have a field with a a value: 0.570 Using PC SAS, when printed to the output window it's 0.570. When output to a pdf file it's 0.570 However, viewing the SAS dat... 3 Sep 2009 07:37

For Proc report, how to make split='~' work in PDF?
Lily, Split character only works in header and not in data. '~n' in the data will split the data , first define '~' as escapechar like below ods escapechar = '~'; Data ToPrint; Length TEXT $ 32000; Input Ids= TEXT=; Cards; Ids=1 TEXT=1:RED~nx2:BLUE~nx3:BLACK ; Run; ods pdf file='test.pdf' ; proc ... 3 Sep 2009 07:37

drop many variables
data clear; set barcode193; drop commodiy_:; run; * Drop AFTER set statement declares the variables * COLON is the wildcard, not asterisk -Joe On Wed, Sep 2, 2009 at 3:37 PM, Elmaache, Hamani < Hamani.Elmaache1(a)cra-arc.gc.ca> wrote: Hi there. I want to drop many variables from my data set. Thes... 3 Sep 2009 07:37

Need help with %qscan and %scan
Hi All, I had the following codes and there were running errors. The macro variables GRP1 and GRP2 were correctly resolved. However, I got this error 200 from the proc sql statement. After I change the %qscan to %scan, it worked! I thought I should use %qscan to mask the "-" in the macro variable OABYGROUP. How ... 25 Dec 2008 23:00

How to save the slope of a regression model to a dataset?
See http://www.sascommunity.org/wiki/Rolling_Calculations On Wed, 24 Dec 2008 13:11:16 -0600, ST <sheepsas(a)GMAIL.COM> wrote: Hi there, I have a dataset which has 10000 observations. For each obs, I want to create a regression model (based on variable x and y in the dataset) using previous 20 observation... 25 Dec 2008 14:09

Lab Tables
Hi all, I am working on lab data ..and trying to create two macros one for change from baseline to end of visit and the other for shift in lab test values i have no clue where to start from , so can anyone direct me to link where i can find these macros so that i can use those ideas in my macro programs ... 16 Dec 2008 03:18

PROC LOGISTIC options
paul wilson <paulwilsn(a)YAHOO.COM> wrote I recently saw people use this code in their PROC LOGISTIC: ctable pprob=.4 I tried including it in my syntax just to see what it does and if I really need it ,so the new code looks like this: proc logistic data = penalty outest=scoring_coeff; mo... 15 Dec 2008 07:18

NEW: Power User's Guide to SAS Programming by Philip R Holland (published Dec2008)
"Power User's Guide to SAS Programming" brings together a wealth of ideas about strategic and tactical solutions to everyday situations experienced when transferring, extracting, processing and reporting data. Most of the solutions can be achieved using the SAS components you already license, so you won't need to t... 11 Dec 2008 17:19