About Pooja2

Pooja2 · ‎07-01-2019

exact 10.

Pooja2 · ‎07-01-2019

Hi All, I have a data set containing distinct patients in each row and how many times they have seen a doctor in the last 6 months. Date Patient visit 28Jul2018 AA 2 27Nov2018 BB 1 19Aug2018 BB 4 28Jul2018 AA 2 27Nov2018 GG 4 19Aug2018 CC 2 I HAVE TO randomly select N number of patients until visits counts reach 10. Please help. Thank you!

Pooja2 · ‎08-28-2018

I want one row for one ID and what that ID bought in separate columns. Also, there are only one option for cloth in tshirt data and three options for cloth in others dataset. if possible, something like this: ID date cloth1 cloth2 cloth3 12345 08/23/2018 tshirt perfume 12347 09/25/2018 tshirt perfume cologne

Pooja2 · ‎08-28-2018

data tshirt; input @1 id $5. @7 cloth $6. @14 receipt_number $3. @18 date mmddyy10.; format date mmddyy10. ; datalines; 12345 tshirt 22x 08/23/2018 12345 tshirt 23x 08/23/2018 12345 tshirt 24x 09/24/2018 12345 tshirt 25x 09/24/2018 12346 tshirt 22y 08/23/2018 12346 tshirt 23y 08/24/2018 12347 tshirt 25z 09/25/2018 ; run; data others; input @1 id $5. @7 cloth $6. @14 receipt_number $3. @18 date mmddyy10.; format date mmddyy10. ; datalines; 12345 perfum 23x 08/23/2018 12345 perfum 24x 08/23/2018 12347 perfum 25z 09/25/2018 12347 cologn 26z 09/25/2018 ; run; *Question: who bought shirts and other stuff from 'others' data set on the same date?; proc sql; create table common as select A.*, B.* from tshirt A, others B where A.ID = B.ID and A.date=B.date; quit; I am not getting what I want. Please help.

Pooja2 · ‎04-27-2018

This should be working. I will update in a day or two. thanks!

Pooja2 · ‎04-26-2018

also it is any 60 day period.

Pooja2 · ‎04-26-2018

my dataset has almost 36k obs and it would be helpful if you could give me the logic in he form of code so that I can test first before running my original data. thanks.

Pooja2 · ‎04-26-2018

it doesn't have to be sql. it could be datastep. So far none of the solutions suggested worked.

Pooja2 · ‎04-25-2018

I m gonna try out the solutions mentioned here and would post whether i got the results or not. I do have 36000 obs. thanks!

Pooja2 · ‎04-24-2018

I have this data and i have to find out which customer purchased more than 40 items during any 60 day. I am unable to find the logic.. please help. Thanks in advance! customer ID date no of items purchased 2333A 24-May-07 3 2333A 27-Jun-07 5 2333A 8-Jul-07 3 2333A 9-Jul-07 8 2333A 20-Jul-07 9 2333A 25-Jun-07 9 2333A 30-Jun-07 7 2333A 5-Jul-07 6 2333A 7-Jul-07 1 5643D 24-May-07 5 5643D 27-Jun-07 5 5643D 8-Jul-07 5 5643D 9-Jul-07 5 5643D 20-Jul-07 5 5643D 25-Jun-07 6 5643D 30-Jun-07 7 5643D 5-Jul-07 5 5643D 7-Jul-07 1 5643D 18-May-07 2 5643D 20-Jun-07 2 2287C 25-Jun-07 4 2287C 30-Jun-07 2 2287C 5-Jul-07 3

Pooja2 · ‎11-22-2017

Thanks a lot!

Pooja2 · ‎11-22-2017

Okay. For example if I have following dataset. I want to create a data set where I have all the cells where these columns have values in 1 to 4. Hope that is clear. Data have; infile datalines; input lifestyle_a lifestyle_f lifestyle_g lifestyle_h lifestyle_i lifestyle_j lifestyle_k lifestyle_l; datalines; 1 2 3 4 1 2 3 4 3 4 5 6 7 1 3 5 2 3 4 2 4 5 6 7 1 2 3 3 9 8 8 8 ; run;

Pooja2 · ‎11-22-2017

Hi Surya, I run this command but by doing this I am losing 1 from second row for lifestyle_j variable. When I printed need dataset it gave me just one row. It should have given me that value for lifestyle_j variable.

Pooja2 · ‎11-22-2017

I run this command but by doing this I am losing 1 from second row for lifestyle_j variable. When I printed need dataset it gave me just one row. It should have given me that value for lifestyle_j variable.

Pooja2 · ‎11-22-2017

And I format them by following value proc format; Value NegFeel 0 = 'Never' 1 = 'Less than Monthly' 2 = 'Monthly' 3 = 'Weekly' 4 = 'Daily or almost daily' ; run;

Online Status	Offline
Date Last Visited	‎04-23-2020 03:39 PM

sas import an image from a website and export that to an excel sheet

Re: sas 9.4 data step

Re: sas 9.4 data step

Re: sas 9.4 data step

sas 9.4 data step

Re: proc sql

proc sql

Re: SAS: create a string to use as a macro

Re: SAS: create a string to use as a macro

Re: SAS: create a string to use as a macro

Re: sas 9.4 data step

Re: sas 9.4 data step

Re: proc survey select with conditions

proc survey select with conditions

Re: proc sql

proc sql

Re: Proc sql: conditional programming

Re: Proc sql: conditional programming

Re: Proc sql: conditional programming

Re: Proc sql: conditional programming

Re: Proc sql: conditional programming

Proc sql: conditional programming

Re: proc sql: WHERE statement multiple columns

Re: proc sql: WHERE statement multiple columns

Re: proc sql: WHERE statement multiple columns

Re: proc sql: WHERE statement multiple columns

Re: proc sql: WHERE statement multiple columns