About user1

user1 · ‎03-28-2018

sorry, it is not -N+1, it should be integer -N+1, for example if N is 10.2, then the term before the last one should be A*(B) -9 , not 9.2.

user1 · ‎03-28-2018

Thanks very much, PG! the term before the last is: A*(B) -N+1 For example, Y 1 =A*(B) -1 + A*(B) -2 + A*(B) -3 + A*(B) -4 +……+ A*(B) -9 +A*(B) -10.2 When I run the above sas code, the decimal 0.2 from the last term is missing.

user1 · ‎03-28-2018

In the equation, everything is the same, only if N is not an integer, the example is below and I need to calculate for each record (Y 1 ........Y N ) Y 1 =A*(B) -1 + A*(B) -2 + A*(B) -3 + A*(B) -4 +……+ A*(B) -10.2 Y 2 =A*(B) -1 + A*(B) -2 + A*(B) -3 + A*(B) -4 +……+ A*(B) -20.3 ……. Y N =A*(B)-1+ A*(B)-2 + A*(B)-3 + A*(B)-4 +……+ A*(B) -N.5

user1 · ‎03-27-2018

Thanks! How about if N has one decimal place, e.g. 14.1?

user1 · ‎03-27-2018

Thanks again, PG Stats!!

user1 · ‎03-26-2018

Thanks for you both for providing the answer, much appreciated! PG Stats, since the power is negative, should the sas code be revised? as u = 0; v = 1/b; do k = -1 to -n; u = (1 + u) * v; end; y = a*u; Thanks and regards.

user1 · ‎03-24-2018

Hi, Can anyone help the calculation of Y below using SAS code? Y=A*(B) -1 + A*(B) -2 + A*(B) -3 + A*(B) -4 +……+ A*(B) -N Thanks a lot!

user1 · ‎07-23-2016

Hello, In my survey dataset, I only have replicate weights (repwtp1-repwtp80), since it is a public use data file. I would like to ask if the following sas code is correct to run a logistic regression with survey weights. Thanks a lot! PROC SURVEYLOGISTIC data=dataset VARMETHOD=jackknife; MODEL dependent_variable=independent_variable(s); REPWEIGHTS repwtp1-repwtp80 /JKCOEFS=0.05; run;

user1 · ‎07-23-2016

Hello, In my survey dataset, I only have replicate weights (repwtp1-repwtp80), since it is a public use data file. I would like to ask if the following sas code is correct to run a logistic regression with survey weights. Thanks a lot! PROC SURVEYLOGISTIC data=dataset VARMETHOD=jackknife; MODEL dependent_variable=independent_variable(s); REPWEIGHTS repwtp1-repwtp80 /JKCOEFS=0.05; run;

user1 · ‎11-13-2012

Thanks so much! I've got the right table I wanted. Best regards.

user1 · ‎11-13-2012

Thanks very much for your prompt reply! I run the code, but the results for person 1 and 3 did not look correct. For example, person 3 should have 0 visit, but the result showed 1 visit for this person.

user1 · ‎11-13-2012

Hi all, I’d like to ask if you can help on this. I would like to know the numbers of visits one year before the date of ‘time_threshold’in table one, but not including the visit on the date of time_threshold. For example, the first person’s time_threshold is 20050917, then the number of visits 12 months before this date is 2 times (not including the 'time_threshold' visit). Table two includes all records in terms of visit time by each person. The table that I am looking for is as follows: Id Counts 1 2 2 1 3 0 4 1 data one; input id time_threshold yymmdd10.; format time_threshold yymmdd10.; datalines; 1 20050917 2 20071005 3 20050606 4 20090116 ; run; data two; input id visit_time yymmdd10.; format visit_time yymmdd10.; datalines; 1 20041212 1 20031105 1 20050917 1 20050407 1 20050112 2 20071005 2 20090301 2 20061215 2 20110915 3 20050606 3 20050918 4 20101112 4 20090116 4 20080909 ; run; Thanks a lot for your help!

user1 · ‎10-04-2012

Thanks very much for your help! Best regards.

user1 · ‎10-04-2012

Hi All, I'd like to ask if you can help about this. Thanks a lot!!! data new; input ID store_number visit_date yymmdd10.; format visit_date yymmdd10.; datalines; 1 21 20050615 1 21 20050708 1 21 20051023 1 28 20041203 2 10 20060123 2 60 20050709 2 19 20060825 3 25 20041010 3 91 20051201 3 64 20040609 4 13 20050606 5 26 20040809 5 26 20030911 ; run; I’d like to get a new dataset to show that if a consumer has regular store to visit. That is, if he/she visited the same store(store number only between 10-29)more than 50% of his/her total store visits within 2 years of period, then he/she had regular store to visit. (But no including the person who only had one store to visit during the period, such as consumer #4). The new dataset should be like the following table. Id Regular_store_to_visit (yes=1, no=0) 1 1 2 0 3 0 4 . 5 1

user1 · ‎08-15-2012

Hi, thanks very much, Arthur, Patrick and Mkeintz, for your prompt response and help! Regards.

Online Status	Offline
Date Last Visited	‎03-28-2018 11:05 PM

Re: Formula calculation

Re: Formula calculation

Re: Formula calculation

Re: Formula calculation

Re: Formula calculation

Re: Formula calculation

Formula calculation

survey logistic

PROC SURVEYLOGISTIC

Re: code help

Re: Formula calculation

Re: Formula calculation

Re: Formula calculation

Re: Formula calculation

Re: Formula calculation

Re: Formula calculation

Formula calculation

survey logistic

PROC SURVEYLOGISTIC

Re: code help

Re: code help

code help

Re: code issue

code issue

Re: question about specific selection