About div44

div44 · ‎02-07-2018

proc report; column pct_x; define pct_x / computed width=6 ' % of X'; compute pct_x / length = 5; pct_x = (num_x/denom_x)*100; endcomp; run; Whenever I try to assign format statement in either define row or compute row I get 0% as result instead of the actual value. WIth this code I am getting the right percentages but they do not seem to be formatted (eg 27.53, 4.567). I want to keep only two digits after the decimal point and insert a % sign as well if possible (eg 27.53%, 4.56%) Thank you for your help.

div44 · ‎02-06-2018

Hello, I have a variable x which is a binary variable (may have missing values). A sum function in proc means would give me value of 60. (yes=60, no or missing=40). When I use the sum function in proc tabulate with a class statement, I get the number of obs (n=100) instead of the sum (60). Here is the code I am using: proc tabulate data = have; var x; class y; table x*sum, y; run; Any help would be appreciated. Thanks

div44 · ‎08-28-2017

Hello Reeza, I am manily concerned with the non-linear association between my dependent variable and independent variable. The independent variable shows an inverted - U shaped distribution when plotted against the dependent variable. As for data which is right-skewed (cost data in general), log transformation are used to model costs as independent variables, however I am unaware of any such transformations whih are used to model data which is U-shaped or inverted-U shaped. A classic example I can think of is that of a disease affecting middle aged population the most, then elderly population and young population the least. If age was my independent variable, it would have led to an inverted - U shaped distribution. I hope this is clear. Than you

div44 · ‎08-28-2017

Hello, I am performing logistic regression using binary dependent variable. However, one of my independent variable is continuous in nature and has an inverted-U shaped distribution with my dependent variable. Since the association is not linear, I am unable to figure out how do I incorporate the desired independent variable in the model. One option is to categorize the continuous variable, but I want to avoid that. Thank you.

div44 · ‎08-28-2017

The table of OR estimates

div44 · ‎08-28-2017

Hello, I am having difficulty to retain the labels for the respective variables while generating the output for regression using proc logistic. Though the dataset has the labels retained, I am unable to see them in the output. Any suggestions? proc logistic data = have; class x (ref = "0") y (ref = "0")/ param=ref; model z (ref="0") = x y; label x = 'drug use binary' y = 'travel binary'; run; Thank you

div44 · ‎08-01-2017

Hello, I want to keep only those observations that have no overlapping start_date and end_date time window. Thank you ID start_date end_date keep 1 2-Jul-17 5-Jul-17 1 1 4-Jul-17 15-Jul-17 0 1 11-Jul-17 20-Jul-17 1 1 17-Jul-17 22-Jul-17 0 1 19-Jul-17 24-Jul-17 0 1 21-Jul-17 23-Jul-17 1

div44 · ‎07-12-2017

A dataset "want" has 4 variables car1, car2, car3, car4. I want to see if any of the 4 variables have values 5,6,7,8 in them. data need; set want; if car: in (5,6,7,8) then output; run; Error at car: ERROR 22-322: Syntax error, expecting one of the following: <, <=, =, >, >=, EQ, GE, GT, LE, LT, NE, NG, NL, ^=, ~=. How do I use all four variables without writing each one of them in the code Thank you

div44 · ‎01-24-2017

The finished date for Twix is what I was looking for which is 18May, and it is here that the code collapses

div44 · ‎01-24-2017

Yes, it should have been the finished date for Twix. Thanks for pointing that out.

div44 · ‎01-24-2017

Person Chocolate Date Received Date Finished No chocolate Actual No chocolate 1 Snickers 7-May-15 11-May-15 0 0 1 MM 8-May-15 13-May-15 0 0 1 Twix 10-May-15 18-May-15 0 0 1 Bounty 12-May-15 16-May-15 0 0 1 Hersheys 17-Jun-15 21-Jun-15 1 0 I need to find when there were at least 30 days without a chocolate for person 1. My current code sorts the data by date received, and gets me the solution to "No chocolate". This is wrong, as it marks the last row as 1, suggesting a difference between (date finsihed - date received for the next chocolate) is 16May15 - 17jun15 = 31 days, however the code does not account for the Bounty choclate date finished which is 18May15, and hence the difference should have been 18May15 - 17Jun15 = 29days and hence does not meet the criteria of at least 30 days as suggested by the Actual No Chocolate column. Sorting the data by date finshed descending does not help either Any help would be appreciated thanks Code data want; set have by person date_received; gap=date_received-lag(date_finished); if first.person=1 then no_chocolate=1; else if gap>=30 then no_chocolate+1; run;

div44 · ‎10-27-2016

I have not used it. Does it reduce the background memory usage ?

div44 · ‎10-27-2016

Hello, Thanks for the suggestion. The dataset which I am using is compressed already. ##- Please type your reply above this line. Simple formatting, no attachments. -##

div44 · ‎10-27-2016

Hello everyone, I have been trying to sort a large dataset on 4 variables. The dataset is 100GB and it is using up the entire work space in the background and is unable to complete the process. Is there any efficient way other than the traditional proc sort or proc sql. I have tried both. PROC SORT DATA = xyz; BY a b c d; RUN; PROC SQL; CREATE TABLE xyz1 SELECT * FROM XYZ ORDER BY a,b,c,d; QUIT; Thank you for your time

div44 · ‎10-25-2016

Thank you so much for your help

Online Status	Offline
Date Last Visited	‎03-28-2019 05:21 PM

How to assign a percent format to a computed variable in proc report

Summing values of a variable in proc tabulate

Re: Logistic regression

Logistic regression

Re: proc logistic labels

proc logistic labels

Dealing with date overlaps

Use of colon (:) in editor window

Re: Gap of at least 30 days

Re: Gap of at least 30 days

Re: Logistic regression

How to assign a percent format to a computed variable in proc report

Summing values of a variable in proc tabulate

Re: Logistic regression

Logistic regression

Re: proc logistic labels

proc logistic labels

Dealing with date overlaps

Use of colon (:) in editor window

Re: Gap of at least 30 days

Re: Gap of at least 30 days

Gap of at least 30 days

Re: Sorting large datasets on multiple variables

Re: Sorting large datasets on multiple variables

Sorting large datasets on multiple variables

Re: do within do loop