About Statsconsultancy

Statsconsultancy · ‎09-27-2011

I have a data set like as follows PatientID year adherence 1 1 0 1 2 1 1 3 1 2 1 1 2 2 1 3 1 1 3 2 1 3 3 0 3 4 1 What i want is to create a new variable that will give cumulative adherence at year "i". Thus the data with a new variable will look like PatientID year adherence cumulativeAdherence 1 1 0 0 1 2 1 1 1 3 1 2 2 1 1 1 2 2 1 2 3 1 1 1 3 2 1 2 3 3 0 2 3 4 1 3

Statsconsultancy · ‎01-26-2011

I HAVE A DATASET IN EXCEL. I HAVE 3 VARIABLES. ALL ARE IN DATE FORMAT. I USED PROC IMPORT TO READ THE FILE INTO SAS. ONE OF THE COLUMNS COMES UP BLANK IN SAS, WHILST IN EXCEL THE CELLS ARE NOT EMPTY. I TRIED TO USE FORMAT mmddyy10. AND I GOT A MESSAGE SAYING VARIABLE HAS BEEN DEFINED AS BOTH CHARACTER AND NUMERIC. HOW CAN I RECTIFY ALL THESE.

Statsconsultancy · ‎01-07-2011

I will like to select disease with codes beginning with B2 or C2. Is it possible to use logical operations here. I tried the following, but it did not work data new; set lib.data; where disease like 'B2%' or where disease like 'C2%'; run; I want to select patients with disease codes B2*** or C2***. Can anyone help.

Statsconsultancy · ‎01-06-2011

I have a variable by the name DiseaseCode. How can I select any code that begins with B2. That is I want to select anything of the form B2**. It can be B23, B2K, B2SKH. Can someone help.

Statsconsultancy · ‎12-15-2010

I have a lists of patients each with prescription dates. I would like to look at the prescription dates of each patient and see which patient has skipped medication say for 2months (60days). as an example, suppose patient A has prescription on the following dates, 01/Jan/2001, 01/Feb/2001,01/March/2001, 01/Jan/2002, 01/Feb/2002, 01/March/2002. Because the number of days between the third and the fourth prescription is greater than 60 days, i would like the program to tell me that this patient has skipped medication. Am I making sense?? Can someone help.

Statsconsultancy · ‎07-12-2010

I have the following data data no_of_alerts; Input doctor alerts error; cards; 1 1 1 2 1 0 3 1 1 4 1 1 5 1 1 1 2 1 2 2 1 3 2 1 4 2 0 5 2 1 1 3 1 2 3 0 3 3 1 4 3 0 5 3 1 1 4 1 2 4 0 3 4 1 4 4 0 5 4 0 ; Suppose I want to run linear regression model alerts = mean_error, where now Mean_error is the mean error of the alerts. As an example ,for alerts = 1 the mean is 0.8 (1+0+1+1+1)/5). Thus my points will be (1,0.8), (2, 0.8), (3, 0.6) and (4,0.4). Can someone help. If I use proc reg; Model = alerts = error; run. I get the wrong results.

Statsconsultancy · ‎06-17-2010

I Have the following data set; Data daset1; Input location height; cards; A 0.2 A 0.8 B 0.1 ..... run; I then use the following command to create a new column. Data daset2; set Dataset1; locheight = location || height; run; The output is displayed below location height locheight A 0.2 A 0.2 A 0.8 A 0.8 B 0.1 B 0.1 Does anyone know how to remove the interior blanks on elements of locheight. That the output appears as folows: location height locheight A 0.2 A0.2 A 0.8 A0.8 B 0.1 B0.1

Statsconsultancy · ‎06-14-2010

I have data in the following format: It consists of patients and the numbers of diseases each patient experienced. patient disease1 disease2 disease3; 1 I21 E102 C80 2 B20 C77 G81 3 B20 K27 G450 run; I then assign weight to each disease using the following codes; The intention is to come up with total burden of the diseases. For example in patient1 I will add the weights of I21, E102 and C80. In partient2 I will add the weights of B20 C77 G81, and etc. I used the following codes to create the three columns and then add across the new three columns. If disease1 = 'I21' then do; weight1 = 1; end; else if disease1 = 'B20' then do; weight1 = 6; end; else if disease2 = 'I71' then do; weight2 = 1; end; else if disease2 = 'E102' then do; weight2 = 2; end; else if disease2 = 'C77' then do; weight2 = 3; end; else if disease2 = 'K27' then do; weight2 = 1; end; else if disease3 = 'C80' then do; weight3 = 3; end; else if disease3 = 'G81' then do; weight3 = 2; end; else if disease3 = 'G450' then do; weight3 = 1; end; RUN; WEIGHT = weight1 + weight + weight3; run; Finally the data will be of the following format Patient Disease1 disease2 disease3 weight1 weight2 weight3 weight 1 I21 E102 C80 1 2 3 6 2 B20 C77 G81 6 3 2 11 3 B20 K27 G450 6 1 1 8 run; I was wondering if there is any other way of creating the new columns beside using the procedure that I have used. The problem with the procedure that I have used is that it can be a lot of work if patients have many diseases involved. Can someone help me.

Statsconsultancy · ‎05-24-2010

I have a data where patients were prescribed medication. I have four columns labelled ID (for a patient), prescibeddate (date of prescription), drug ( name of the treatment) and quantity ( number of pills). In some patients I have the quantity missing. What I will like to do is to replace the missing quantity with the immediate previous quantity if the previous drug is the same in that patient. OR replace the missing quantity with the next if the next drug is the same. Otherwise the missing quantity is replaced by the standard quantity which is 28 for both treatment A and treatment B. I am working on a large data set. But as an example the original data is of the following format; ID prescribeddate drug quantity 1 08/jan/2008 A 28 1 08/feb/2008 A 14 1 08/Mar/2008 A 1 08/Apr/2008 B 56 1 08/May/2008 B 2 08/Jan/2008 A 30 2 08/Mar/2009 B 2 28/Mar/2008 A 30 2 08/Mar/2008 B 14 3 08/Jan/2008 B 3 08/Mar/2009 B 56 3 08/Mar/2008 A 4 08/jan/2008 A 4 08/feb/2008 A 4 08/Mar/2008 A 14 4 08/Apr/2008 B 4 08/May/2008 B I want the new data to look as follows: ID prescribeddate drug quantity 1 08/jan/2008 A 28 1 08/feb/2008 A 14 1 08/Mar/2008 A 14 1 08/Apr/2008 B 56 1 08/May/2008 B 56 2 08/Jan/2008 A 30 2 08/Mar/2009 B 28 2 28/Mar/2008 A 30 2 08/Mar/2008 B 14 3 08/Jan/2008 B 56 3 08/Mar/2009 B 56 3 08/Mar/2008 A 28 4 08/jan/2008 A 14 4 08/feb/2008 A 14 4 08/Mar/2008 A 14 4 08/Apr/2008 B 28 4 08/May/2008 B 28 I believe i have made myself clear. Can anyone help. Thank you.

Statsconsultancy · ‎05-03-2010

I am trying to draw a square with coordinates (-1,-1), (1,-1), (-1,-1) and (1,1). I thought i can use VREF = -1 1 and HREF= -1 1. But these give me extra lines that I do not need. Basically, i will like to know how to draw a horizontal line passing through Y=1, beggining at X=-1 and ending at X=1. Or how can I draw a verical line passing through X=1, beggining at Y=-1 and ending at Y=1.

Statsconsultancy · ‎02-16-2010

I have the following data: Data mydata; Date Time Sales ID 03/01/2008 08:39:18 22.99 0 03/01/2008 08:41:21 12.99 0 03/01/2008 08:42:13 12.99 0 03/02/2008 08:07:19 22.99 0 03/02/2008 09:06:20 22.99 0 02/03/2008 11:51:18 12.99 0 02/01/2008 14:31:42 22.99 1 02/07/2008 12:17:27 22.99 1 02/07/2008 13:42:27 22.99 1 02/07/2008 13:58:37 12.99 1 02/07/2008 15:03:23 12.99 1 I will like to compute sales by time Vi(A) the agent (ID) accrued at time say ti(A). That is I will to have something that looks like this Date Time Sales ID totalsales 03/01/2008 08:39:18 22.99 0 22.99 03/01/2008 08:41:21 12.99 0 35.98 03/01/2008 08:42:13 12.99 0 48.97 03/02/2008 08:07:19 22.99 0 22.99 03/02/2008 09:06:20 22.99 0 45.98 02/03/2008 11:51:18 12.99 0 12.99 02/01/2008 14:31:42 22.99 1 22.99 02/07/2008 12:17:27 22.99 1 22.99 02/07/2008 13:42:27 22.99 1 45.98 02/07/2008 13:58:37 12.99 1 68.97 02/07/2008 15:03:23 12.99 1 91.96 I will appreciate it if you can help.

Statsconsultancy · ‎02-15-2010

I need compute the time elapsed since the previous sale made by the same agent, whenever the previous sale was made on the same day. If Ithere is no previous sale on the same day, I need to compute the time since the start of work. The work begins at 9:00am. My data looks like as follows ID DATE SALES 1 03Jan2008:10:50:30 40 1 03Jan2008:10:59:01 30 1 03Jan2008:11:04:02 40 1 03Jan2008 :11:20:04 30 1 03Feb2008 :09:05:40 30 1 03Feb2008:11:06:05 30 1 04Feb2008 :10:05:40 30 1 05Feb2008:11:06:05 30 2 03Jan2008 :09:04:06 40 2 03Jan2008:10:05:08 30 2 03Jan2008 :11:09:09 40 2 03Jan2008:11:40:09 30 2 03Jan2008 :12:45:09 40 2 03Jan2008 :12:50:08 30 2 03Feb2008:09:04:09 30 2 03Feb2008 :09:56:08 30 2 03Feb2008 :10:08:03 40 2 04Feb2008 :11:08:09 30 I need to have something like this. ID DATE SALES inter_sales_time (minutes) 1 03Jan2008:10:50:30 40 . 1 03Jan2008:10:59:01 30 9 1 03Jan2008:11:04:02 40 5 1 03Jan2008 :11:20:04 30 16 1 03Feb2008 :09:05:40 30 . 1 03Feb2008:11:06:05 30 121 1 04Feb2008 :10:05:40 30 65 1 05Feb2008:11:06:05 30 126 2 03Jan2008 :09:04:06 40 . 2 03Jan2008:10:05:08 30 61 2 03Feb2008 :10:08:03 40 68 2 04Feb2008 :11:08:09 30 128 I tried to create a variable say DATE1 = lag(DATE), and the substraye DATE1 from DATE, but it did not work. Please rescue me.

Statsconsultancy · ‎09-15-2009

I have tried, but still i can't solve the problem. Please, can you have a look at me data steps and kindly advise me on that. What is the mistake on my program? PROC IMPORT datafile="Z:\prescription.mdb" out=mymdb dbms=ACCESS replace; run;

Statsconsultancy · ‎09-14-2009

I will to open the access(mdb) file. Its name is prescription.mdb and is stored in the "Z" drive. I want to use proc import. I am getting a message saying "FILE= or TABLE= is required and must be specified". Please can someone help me. PROC IMPORT datafile="Z:\prescription.mdb" out=prescription dbms=ACCESS replace; run; proc print;run;

Statsconsultancy · ‎08-17-2009

I want to do something similar to proc freq, I have the following data set that shows the type of treatment the patient was prescribed and the date of prescription. I managed to sort by prescription: subject treatment prescribed_date 1 A 08/08/1997 1 B 07/09/2000 1 A 05/06/2002 2 A 08/03/1996 2 B 12/01/1999 2 A 05/06/2002 2 B 09/11/2003 3 B 02/05/1992 4 B 02/08/1998 5 A 05 /09/1999 6 A 06 /06/2000 7 A 08/08/1997 7 B 07/09/2000 7 A 05/06/2002 Is it possible to request SAS to perform the following: Tell me how many patients the received the treatments in the order ABA, ABAB, etc. That is I will like SAS to tell me or produce a table showing me that there are 2 patients who received the treatments in the order ABA, 1 patient in the order ABAB, 2 patients in the order B only. 2 patients in order A Please help

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Summing over the column

PROC IMPORT

DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

difference between consecutive dates

PROC REG (Getting the right results)

REmoving interior Blanks

Creating new columns(Alternatives)

Replacing missing values by previous observation

VREF and HREF

IMPORT ACCESS(mdb) files

Replacing missing values by previous observation

Summing over the column

PROC IMPORT

DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

difference between consecutive dates

PROC REG (Getting the right results)

REmoving interior Blanks

Creating new columns(Alternatives)

Replacing missing values by previous observation

VREF and HREF

Summing over the column

PLease help( inter sales times)

Re: IMPORT ACCESS(mdb) files

IMPORT ACCESS(mdb) files

something similar to PROC FREQ???