cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
iced_tea
‎10-06-2021
  • 24 Posts
  • 8 Likes Given
  • 0 Solutions
  • 5 Likes Received

Re: Macro variables for iterative process

by Obsidian | Level 7 in New SAS User
‎10-06-2021 11:52 AM
‎10-06-2021 11:52 AM
Thank you Kurt. Very helpful. I ended up using a different method, but your method works, I checked. Only one thing, you mentioned the wrong key variable in your hash object. We should call "agegrp" not "agegroup" in the following section of your code: length agegrp $8; declare hash ref(dataset:"reference"); ref.definekey("agegrp"); ref.definedata("low_height_ref","high_height_ref","low_weight_ref","high_weight_ref","low_bmi_ref","high_bmi_ref"); ref.definedone(); call missing(low_height_ref,high_height_ref,low_weight_ref,high_weight_ref,low_bmi_ref,high_bmi_ref); end; agegrp = put(age,agegroup.); Thank you.  ... View more

Re: creating a frequency table

by Super User in New SAS User
‎06-23-2021 07:45 AM
‎06-23-2021 07:45 AM
OK . Need some more code. proc sql; select number_movie,count(*) as number_customer from ( select customer_id,count(distinct movie ) as number_movie from have group by customer_id ) group by number_movie; quit; ... View more

Re: How to shift rows up

by PROC Star in New SAS User
‎04-07-2021 04:32 PM
‎04-07-2021 04:32 PM
If (1) you are ok with re-ordered the data by employee_id/date, and (2) you want to keep the latest non-missing values for each employee_id/date, then UPDATE does what you want:   data example; input employee_id $ date :DATE8. AdvancedCourse IntermediaryCourse BeginnerCourse 8.; format date DATE9.; format AdvancedCourse IntermediaryCourse BeginnerCourse 8.; datalines; 9781 29MAR20 1 . . 9781 09APR20 . . 1 9781 21JUN20 1 . . 9781 21JUN20 . . 1 9781 26JUN20 . . 1 1234 12MAR19 . . 1 1234 12MAR19 . 1 . 1234 15MAR19 1 . . ; run; proc sort data=example out=need equals; by employee_id date; run; data want; update need (obs=0) need; by employee_id date; run; The "equals" keeps all ties in the sort keys in original order, although that shouldn't be a problem here.   Think of the UPDATE statement as updating a masterfile with transactions - except the only transactions that are recorded are the non-missing values - no transaction can modify a variable from non-missing to missing.  I use the "obs=0" in the left side of the update statement, because the initial "master" file (the first NEED in the update statement has multiple records per byvars, but we only want one such record in the result.   Unlike the above, UPDATE was originally intended for such separate master and transaction data sets, as in: data newmaster; update master transgrp1 ; by unique_id; urn; ... View more

Re: Keep observations with the longest date range

by Obsidian | Level 7 in New SAS User
‎02-25-2021 01:03 PM
‎02-25-2021 01:03 PM
Thank you Lapis. Actually, I made a mistake in my initial question where I should have said that I want to drop the observation for employee_id 97531 where startdate=01MAY17 as opposed to when it =30APR17. I want to keep the longest observation. So, really the desired output looks like the following: The code you suggested works with a minor modification to do this: proc sort data=example out=example_sorted; by employee_id enddate descending startdate; run; data want; set example_sorted; by employee_id enddate; format final_startdate final_enddate date8. drop $8.; if last.enddate then do; final_startdate = startdate; final_enddate = enddate; drop = "no"; end; else do; final_startdate = .; final_enddate = .; drop = "yes"; end; run; I simply replaced "first" with "last".  Thank you! ... View more

Re: How to drop subsumed observations

by Obsidian | Level 7 in SAS Programming
‎02-25-2021 08:12 AM
‎02-25-2021 08:12 AM
Wow brilliant! Thank you so much Ksharp! Totally works and I even understand the method you used. Thank you. ... View more

Re: PROC SQL, Recursive Common Table Expression, dealing with consecut...

by Opal | Level 21 in New SAS User
‎02-24-2021 01:39 PM
‎02-24-2021 01:39 PM
For up to 5 chained periods per sequence, in SAS/SQL you could do (example data from Stackoverflow reference):   data have; infile datalines dsd; input id (dStart dEnd) (:yymmdd10.); format dStart dEnd yymmdd10.; datalines; 5, 2007-12-03, 2011-08-26 5, 2013-05-02, . 30, 2006-10-02, 2011-01-16 30, 2011-01-17, 2012-08-12 30, 2012-08-13, . 66, 2007-09-24, . ; proc sql; select a.id, a.dStart, case when e.id then e.dEnd when d.id then d.dEnd when c.id then c.dEnd when b.id then b.dEnd else a.dEnd end as dEnd format=yymmdd10. from have as a left join have as b on a.id=b.id and a.dEnd+1=b.dStart left join have as c on a.id=c.id and b.dEnd+1=c.dStart left join have as d on a.id=d.id and c.dEnd+1=d.dStart left join have as e on a.id=e.id and d.dEnd+1=e.dStart group by a.id, calculated dEnd having a.dStart = min(a.dStart) ; quit;   ... View more

Re: Creating a new field using dates

by Obsidian | Level 7 in SAS Programming
‎10-13-2020 02:23 PM
‎10-13-2020 02:23 PM
Is this helpful?    PatID index_ART Final_Class FILL_DATE SUPPLY_DAYS BrandName Brand1 Brand2 Brand3 Brand4 Brand5 Brand6 index_Brand_List Switch_Status 19737 2013-03-13 Combinations 13Mar2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 13Mar2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 08Apr2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 08Apr2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04May2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04May2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 01Jun2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 01Jun2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 08Jul2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 08Jul2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 03Aug2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 03Aug2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04Sep2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04Sep2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 01Oct2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 01Oct2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 27Oct2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 27Oct2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 24Nov2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 24Nov2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 20Dec2013 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 20Dec2013 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 15Jan2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 15Jan2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 10Feb2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 10Feb2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 10Mar2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 10Mar2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 21Apr2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 21Apr2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 17May2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 22May2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 14Jun2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 17Jun2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 10Jul2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 13Jul2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 16Aug2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 16Aug2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 11Sep2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 11Sep2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 20Oct2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 20Oct2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 15Nov2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 15Nov2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 11Dec2014 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 11Dec2014 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 06Jan2015 30 Levoxyl Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 06Jan2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 11Feb2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin yes 19737 2013-03-13 Combinations 11Feb2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 16Mar2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 16Mar2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 13Apr2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 22Apr2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 11May2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 18May2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 06Jun2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 13Jun2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04Jul2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 09Jul2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 30Jul2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 05Aug2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 25Aug2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 01Sep2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 24Sep2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 27Sep2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 23Oct2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 23Oct2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 20Nov2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 20Nov2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 16Dec2015 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 16Dec2015 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 16Jan2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 16Jan2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 11Feb2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 11Feb2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 08Mar2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 08Mar2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04Apr2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04Apr2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 30Apr2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 01May2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 27May2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 27May2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 22Jun2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 22Jun2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 18Jul2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 18Jul2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 13Aug2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 13Aug2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 08Sep2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 08Sep2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04Oct2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04Oct2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 02Nov2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 02Nov2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 01Dec2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 01Dec2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 27Dec2016 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 27Dec2016 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 12Sep2018 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 12Sep2018 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 18Sep2018 30 Zestril Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 12Oct2018 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 12Oct2018 30 Zestril Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 05Nov2018 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 17Nov2018 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 03Dec2018 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 02Jan2019 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 02Jan2019 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 26Jan2019 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 30Jan2019 30 Neurontin Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04Mar2019 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 11Mar2019 30 Zestril Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 10Apr2019 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 10Apr2019 30 Zestril Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 04May2019 30 Zestril Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 09May2019 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 31May2019 30 Zestril Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 02Jun2019 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 24Jun2019 30 Zestril Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 26Jun2019 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 25Jul2019 30 Lipitor Levoxyl Neurontin         Levoxyl,Neurontin   19737 2013-03-13 Combinations 25Jul2019 30 Zestril Levoxyl Neurontin         Levoxyl,Neurontin   31598612 2013-01-28 Combinations 28Jan2013 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Jan2013 30 Amoxil Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Jan2013 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 01Mar2013 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 01Mar2013 30 Amoxil Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 01Mar2013 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 01Apr2013 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 01Apr2013 30 Amoxil Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 01Apr2013 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29Apr2013 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29Apr2013 30 Amoxil Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29Apr2013 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 30Jul2013 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 30Jul2013 30 Amoxil Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 30Jul2013 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 27Aug2013 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 27Aug2013 30 Amoxil Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 27Aug2013 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 24Sep2013 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 24Sep2013 30 Amoxil Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 24Sep2013 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 25Oct2013 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 25Oct2013 30 Amoxil Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 25Oct2013 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 20Nov2013 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 20Nov2013 30 Amoxil Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 20Nov2013 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 30Dec2013 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 30Dec2013 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 31Jan2014 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 31Jan2014 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 20Feb2014 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 20Feb2014 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 18Mar2014 30 Levoxyl Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 18Mar2014 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 21May2014 30 Lipitor Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin yes 31598612 2013-01-28 Combinations 21May2014 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 18Jun2014 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 18Jun2014 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 19Jun2014 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29Jul2014 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29Jul2014 30 Lipitor Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29Jul2014 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29Jul2014 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Aug2014 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Aug2014 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Aug2014 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 25Sep2014 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 25Sep2014 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 25Sep2014 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 23Oct2014 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 23Oct2014 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 23Oct2014 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 06Jan2015 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 06Jan2015 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Jan2015 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Jan2015 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Jan2015 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Apr2015 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Apr2015 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Apr2015 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28May2015 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29May2015 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29May2015 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Jun2015 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Jun2015 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Jun2015 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 21Jul2015 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 21Jul2015 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 10Aug2015 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 10Aug2015 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 10Aug2015 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 01Oct2015 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 01Oct2015 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 01Oct2015 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29Oct2015 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29Oct2015 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 29Oct2015 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 16Dec2015 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 16Dec2015 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 16Dec2015 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 11Jan2016 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 11Jan2016 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Jan2016 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Jan2016 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Jan2016 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 26Feb2016 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 26Feb2016 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 27Feb2016 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 04Apr2016 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 04Apr2016 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 04Apr2016 30 Neurontin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 23May2016 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 23May2016 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 23May2016 30 Zestril Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Jun2016 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Jun2016 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Jun2016 30 Zestril Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Aug2016 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Aug2016 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Aug2016 30 Zestril Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Oct2016 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Oct2016 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 02Nov2016 30 Zestril Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Nov2016 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 22Nov2016 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 28Nov2016 30 Zestril Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 15Dec2016 30 Zestril Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 19Dec2016 30 Zofran Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31598612 2013-01-28 Combinations 19Dec2016 30 Motrin Levoxyl Amoxil Neurontin       Levoxyl,Amoxil,Neurontin 31599752 2013-02-20 Combinations 20Feb2013 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 23Apr2013 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 10Jun2013 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 13Jul2013 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 06Aug2013 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 03Sep2013 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 30Sep2013 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 28Oct2013 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 03Dec2013 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 18Feb2014 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 14Mar2014 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 14Apr2014 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 15May2014 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 12Jun2014 30 Tylenol Tylenol           Tylenol   31599752 2013-02-20 Combinations 29Nov2016 30 Tylenol Tylenol           Tylenol no   The first two PatIDs are a "yes" for Switch_Status. The last PatID is a "no" for Switch_Status. ... View more

Re: Assigning a value to a new column

by Tourmaline | Level 20 in SAS Programming
‎10-08-2020 10:32 PM
3 Likes
‎10-08-2020 10:32 PM
3 Likes
data have; input Customer Rental_Date :date9. MovieTitle $25.; format Rental_Date date9.; cards; 12345 10-Aug-14 Pitch Perfect 12345 8-Sep-14 Yesterday 12345 17-Oct-14 Hunger Games 12345 29-Nov-14 Booksmart 12345 31-Dec-14 iRobot 67890 10-Jan-15 Gone Girl 67890 10-Jan-15 Titanic 67890 8-Apr-15 The Imitation Game ; data want; set have; by customer rental_date; length class $15; if first.customer then if first.Rental_Date and last.Rental_Date then Class=MovieTitle; else if first.Rental_Date then class='Combo'; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-06-2021 11:53 AM
Likes given to
Likes from
View All
Quick links