About Lordy

Lordy · ‎03-29-2019

Worked as magic 🙂 Thank you

Lordy · ‎03-29-2019

First two rows will have flag=1

Lordy · ‎03-29-2019

flag=1 for all addresses that has the same date flag=0 otherwise

Lordy · ‎03-29-2019

Did not run

Lordy · ‎03-29-2019

I have a data that looks like the table below. I want to flag the same addresses occurring on the same date as an event. This is the code I used but SAS is treating address as numeric and character at the same time. Any help will be appreciated. Store ID Address Date Customer Name 1 T6H 4M5 1-Jan-19 John 1 T6H 4M5 1-Jan-19 Mary 1 T6H 1R1 3-Mar-18 Ami 1 T6H 3M1 3-Mar-18 Emi 1 T6H 1A2 2-Feb-17 Dan 1 T6H 1A2 2-Feb-18 Trish 1 T6K 1G2 1-Jan-19 Ivy 1 T6H 1N2 4-Jan-19 Dex 1 T6H 1N2 3-Dec-18 May 1 T6H 4M5 2-Mar-17 Nate : : : : 1 T6H 4M5 5-Mar-19 Hans proc sort data=have; by address date; run; data want; do until (last.date); set have; by address date; if address then has_address=1; if date then has_date=1; end; flag=0; do until (last.date); set want; by address and date; if has_address and has_date the output; end; drop has_: run;

Lordy · ‎10-22-2018

Worked! Thanks a lot

Lordy · ‎10-18-2018

Did not work - code still flagging sunday

Lordy · ‎10-18-2018

I have a data containing names, SSN, date of service, and oranges as column names. Each person is to receive one orange within a week, i.e. any day from sunday to saturday. I need help with a sas code to flag all SSN that received more than one orange within the specified one week period. The code below is flagging those who received oranges on sunday as well, however, any sunday is the first day of the week. Thanks! data mydata; by SSN date; days_passed=dif(date); if SSN=0 and days_passed in (1,2,3,4,5,6) then event=1; drop days_passed; run;

Lordy · ‎06-09-2017

Sure thx

Lordy · ‎06-08-2017

How do we factor in the SSN and the date for each person

Lordy · ‎06-08-2017

I have a dataset with Excercise (options - C1, C2), Dates, SSN, drinks (options - coke, sprite). I want to flag a client who on the same day he excercises also buys either coke, sprite or both drinks. Any help with sas codes please

Lordy · ‎01-24-2017

Thanks - I will use this approach.

Lordy · ‎01-23-2017

I have a dataset with the following columns: dates, client name, jail record, jail facility name I need to query the data in base sas as follow: If a client has a jail record and there is a previous jail record within 30 days where the jail facility was different then i want to code it as an event for each client. Any ideas how to do that please!

Lordy · ‎02-05-2016

Rick: It does not produce the proc print for my data. I will past the log message below too. Thanks! proc surveyfreq data=data6; table AH_LOCAL_CODE*AHS_Edu_level*CHAS_SEX/ CL chisq CV nowt; weight AH_weight; ods output CrossTabs=PTable; run; proc print data=PTable; where F_AHS_Edu_level="Total"; run; Output Added: ------------- Name: CrossTabs Label: CrossTabulation Table Template: Stat.SurveyFreq.CrossTabFreqs Path: Surveyfreq.Table132of1.CrossTabs ------------- NOTE: The data set WORK.PTABLE has 1980 observations and 13 variables. NOTE: PROCEDURE SURVEYFREQ used (Total process time): real time 1.17 seconds cpu time 1.20 seconds 　 1136 1137 proc print data=PTable; 1138 where F_AHS_Edu_level="Total"; 1139 run; NOTE: No observations were selected from data set WORK.PTABLE. NOTE: There were 0 observations read from the data set WORK.PTABLE. WHERE F_AHS_Edu_level='Total'; NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 　

Lordy · ‎02-05-2016

The freq seems to be same for all categories which is weird. Any reason why the previous code works perfectly with the sas dataset but not mine?

Online Status	Offline
Date Last Visited	‎03-29-2019 08:06 PM

Re: How to flag same addresses occurring on the same date

Re: How to flag same addresses occurring on the same date

Re: How to flag same addresses occurring on the same date

Re: How to flag same addresses occurring on the same date

How to flag same addresses occurring on the same date

Re: sas code

Re: sas code

sas code

Re: Coding

Re: Coding

Re: Tip for sas code

Re: Proc Surveyfreq

Re: Decreasing decimal places in proc surveyfreq output

Re: Decreasing decimal places in proc surveyfreq output

Re: Proc Surveyfreq

Re: How to flag same addresses occurring on the same date

Re: How to flag same addresses occurring on the same date

Re: How to flag same addresses occurring on the same date

Re: How to flag same addresses occurring on the same date

How to flag same addresses occurring on the same date

Re: sas code

Re: sas code

sas code

Re: Coding

Re: Coding

Coding

Re: Tip for sas code

Tip for sas code

Re: Proc Surveyfreq

Re: Proc Surveyfreq