I am trying to create and use a user-defined format to convert a numeric value to a character value.    Here is my test code:     data format_in; input begin $ 1-3 end $ 5-8 amount $ 10-12; datalines; 1 1 RG 2 2 RG 3 3 RB 4 4 RB 5 5 RS ; data ctrl; length label $ 11; set format_in(rename=(begin=start amount=label)) end=last; retain fmtname 'test_format' type 'C'; output; if last then do; hlo='O'; label='***ERROR***'; output; end; run; proc format library=work cntlin=ctrl; run; proc sql; create table test (Tier num(1)); insert into test values(1) values(2) values(3) values(4) values(5); run; data test2; set test; Util=put(tier,$test_format.); run; However, this returns the following errors:   70 data test2; 71 set test; 72 Util=put(tier,$test_format.); _____________ 484 WARNING: Variable Tier has already been defined as numeric. NOTE 484-185: Format TEST_FORMAT was not found or could not be loaded. Does anyone know what is going on? I am not sure why the format can't be loaded or found when I just created it.   ... View more

I'm sure this is an easy one and I'm doing something dumb, but for some reason I can only get the first line into the work.have dataset. What am I doing wrong?    data WORK.have; infile datalines dsd truncover; input Name:$20. Car:$30. Date_of_Service: mmddyy10.; format Date_of_service mmddyy10.; datalines; Henry O'Toole, '86 Chevy Celebrity, 01052018 Henry O'Toole, '86 Chevy Celebrity, 04092018 Henry O'Toole, '86 Chevy Celebrity, 07122018 Henry O'Toole, '86 Chevy Celebrity, 10142018 Henry O'Toole, '07 Toyota Prius, 01162018 Henry O'Toole, '07 Toyota Prius, 04202018 Henry O'Toole, '07 Toyota Prius, 07232018 Henry O'Toole, '07 Toyota Prius, 10252018 Kathleen Boberts, '96 Honda Accord, 01272018 Kathleen Boberts, '96 Honda Accord, 05012018 Kathleen Boberts, '96 Honda Accord, 08032018 Kathleen Boberts, '96 Honda Accord, 11052018 ; run; ... View more

I am trying to figure out how much business I would have if all of my customers received oil changes at 90 day intervals. I have a data set that shows me when they have changed their oil in the past, but am having a hard time figuring out how to extrapolate future oil changes from the first oil change.      Does anyone know how to do this? I am guessing it is something like this:   proc sort data=have; by Name Car Date_of_Service; quit; data have2; set have; by Name Car Date_of_Service; if first.Car=1 then output; run; data want; set have2; by name car; do while (date_of_service lt '01Jan2019'd); if first.car=1 then output want; date_of_service = date_of_service + 90; output want; end; run; To be clear, I want the code to look at the first observation and output it to "want". Then, I want it to change the date_of_service to 90 days in the future and output that observation. Then, I want it to look at the observation it just output - if that date_of_service is in the same year, then I want it to change the date_of_service to 90 days in the future. If the new date_of_service is in the same year, the new observation should be output, and the loop will continue. If not, the loop will move on to the first record of the next name/car combination.  ... View more