About twildone

twildone · ‎12-12-2018

Hi...I have included a dataset below.... data Have; length StudentUID 8 Major $ 50 TextTerm $ 12; format StudentUID BEST12. Major $CHAR50. TextTerm $CHAR12.; informat StudentUID BEST12. Major $CHAR50. TextTerm $CHAR12.; infile datalines4 dlm='7F'x missover dsd; input StudentUID : BEST32. Major : $CHAR50. TextTerm : $CHAR12.; datalines4; 104 00-01 Trm 1C 104Industrial Maintenance Technician00-01 Trm 2C 104Industrial Maintenance Technician00-01 Trm 3C 105Production Art00-01 Trm 1C 106Cisco Training00-01 Trm 3C 106 00-01 Trm 1C 106 00-01 Trm 2C 106Microcomputer Systems Technician00-01 Trm 2C 107Auto Mechanics00-01 Trm 2C 107 00-01 Trm 3C 108 00-01 Trm 2C 108Microcomputer Systems Technician00-01 Trm 3C 108Cisco Training01-02 Trm 2C 108 01-02 Trm 3C 109Microcomputer Systems Technician00-01 Trm 2C 109 01-02 Trm 1C 109 01-02 Trm 2C 109Cisco Training01-02 Trm 2C ;;;;

twildone · ‎12-12-2018

Hi...I am trying to fill in the Major variable with the first non-missing entry until the next non-missing entry (its possible for the same StudentUID to have more than one major) and I am getting an error message that the variable Major is both character and numeric. Major is character with length 50 and StudentUID is numeric. If I exclude the "not missing(Major or" from the until statement, it executes but I don't get the proper output. Can anyone see why I am getting the error message....Thanks. data StudentDegree1; length a1 $50; do until(not missing(Major) or last.StudentUID); set StudentDegree2; by StudentUID Major notsorted; a1=Major; end; do until(not missing(Major) or last.StudentUID); set StudentDegree2; by StudentUID Major notsorted; Major=a1; output; end; drop a1; run; Log Output: NOTE: There were 153022 observations read from the data set WORK.STUDENTDEGREE2. NOTE: The data set WORK.STUDENTDEGREE2 has 153022 observations and 7 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.32 seconds cpu time 0.51 seconds 319 320 data StudentDegree1; 321 length a1 $50; 322 do until(not missing(Major) or last.StudentUID); 323 set StudentDegree2; ERROR: Variable Major has been defined as both character and numeric. 324 by StudentUID Major notsorted; 325 a1=Major; 326 end; 327 do until(not missing(Major) or last.StudentUID); 328 set StudentDegree2; ERROR: Variable Major has been defined as both character and numeric. 329 by StudentUID Major notsorted; 330 Major=a1; 331 output; 332 end; 333 drop a1; 334 run;

twildone · ‎12-06-2018

Hi....I made the changes to the TermCalendarUID as there were errors. I think I was missing a few statements for TermCalendarUID before the output statement. I included the variables such as Programs to see whether or not they are carrying over as the same in the new records. data Have; length StudentUID 8 Programs $ 22 EnrollmentStatus $ 16 RegisterStatus $ 12 TermCalendarID $ 10 StartDate 8 CompletionDate 8 ; input StudentUID : BEST32. Programs : $CHAR22. EnrollmentStatus : $CHAR16. RegisterStatus : $CHAR12. TermCalendarID : $CHAR15. StartDate :yymmdd10. CompletionDate : yymmdd10. ; format StartDate yymmdd10. CompletionDate yymmdd10. ; datalines; 785 CulinaryArts PostSecondary PostSec 15-16 2015-09-10 2016-06-17 2774 Autobody PostSecondary PostSec 15-16 2015-09-10 2017-06-15 10543 CulinaryArts PostSecondary PostSec 13-14 2013-07-02 2015-06-20 11609 Carpentry PostSecondary PostSec 13-14 2013-07-02 2014-06-20 12064 Hairstyling PostSecondary PostSec 15-16 2016-02-01 2017-06-17 12065 Automotive PostSecondary PostSec 15-16 2016-02-01 2019-06-22 13687 CulinaryArts PostSecondary PostSec 13-14 2013-09-05 2016-06-20 13855 Automotive PostSecondary PostSec 14-15 2015-02-03 2015-06-19 15258 Autobody Secondary PTSD 13-14 2013-07-02 2019-06-20 ; run; data Want; set Have; _CompletionDate=CompletionDate; _k=year(_CompletionDate)-year(startdate); if _k=1 then do; if StartDate<mdy(6,30,year(StartDate)) then do; CompletionDate=mdy(6,30,year(StartDate)); TermCalendarID = catx('-',put(input(substr(TermCalendarID,1,2),8.),2.),put(input(substr(TermCalendarID,4,2),8.),2.)); output; TermCalendarID = catx('-',put(input(substr(TermCalendarID,1,2),8.)+1,2.),put(input(substr(TermCalendarID,4,2),8.)+1,2.)); StartDate=CompletionDate+1; CompletionDate=_CompletionDate; output; end; else output; end; else if _k>1 then do; do n=year(StartDate) to year(_CompletionDate)-1; if n=year(StartDate) then do; if StartDate<mdy(6,30,n) then do; CompletionDate=mdy(6,30,n); TermCalendarID = catx('-',put(input(substr(TermCalendarID,1,2),8.),2.),put(input(substr(TermCalendarID,4,2),8.),2.)); output; StartDate=CompletionDate+1; CompletionDate=mdy(6,30,n+1); TermCalendarID = catx('-',put(input(substr(TermCalendarID,1,2),8.) + 1,2.),put(input(substr(TermCalendarID,4,2),8.) + 1,2.)); output; end; else do; CompletionDate=mdy(6,30,n+1); TermCalendarID = catx('-',put(input(substr(TermCalendarID,1,2),8.),2.),put(input(substr(TermCalendarID,4,2),8.),2.)); output; end; end; else if year(StartDate)<n<year(_CompletionDate)-1 then do; startdate=mdy(7,1,n); CompletionDate=mdy(6,30,n+1); TermCalendarID = catx('-',put(input(substr(TermCalendarID,1,2),8.) + 1,2.),put(input(substr(TermCalendarID,4,2),8.) + 1,2.)); output; end; else if n=year(_CompletionDate)-1 then do; startdate=mdy(7,1,n); CompletionDate=_CompletionDate; TermCalendarID = catx('-',put(input(substr(TermCalendarID,1,2),8.) + 1,2.),put(input(substr(TermCalendarID,4,2),8.) + 1,2.)); output; end; end; end; else output; drop n _:; run;

twildone · ‎12-06-2018

Hi....I am trying to create separate records for each StudentUID based on whether the CompletionDate overlaps consecutive academic years. The new records seem to be created fine but when it comes to changing the TermCalendarID it doesn't seem to work in all cases as for StudentUID=12064. I wonder if anyone can help....Thanks. data Have; length StudentUID 8 Programs $ 22 EnrollmentStatus $ 16 RegisterStatus $ 12 TermCalendarID $ 10 StartDate 8 CompletionDate 8 ; input StudentUID : BEST32. Programs : $CHAR22. EnrollmentStatus : $CHAR16. RegisterStatus : $CHAR12. TermCalendarID : $CHAR15. StartDate :yymmdd10. CompletionDate : yymmdd10. ; format StartDate yymmdd10. CompletionDate yymmdd10. ; datalines; 785 CulinaryArts PostSecondary PostSec 15-16 2015-09-10 2016-06-17 2774 Autobody PostSecondary PostSec 15-16 2015-09-10 2017-06-15 10543 CulinaryArts PostSecondary PostSec 13-14 2013-07-02 2015-06-20 11609 Carpentry PostSecondary PostSec 13-14 2013-07-02 2014-06-20 12064 Hairstyling PostSecondary PostSec 16-17 2016-02-01 2017-06-17 12065 Automotive PostSecondary PostSec 16-17 2016-02-01 2019-06-22 13687 CulinaryArts PostSecondary PostSec 13-14 2013-09-05 2016-06-20 13855 Automotive PostSecondary PostSec 15-16 2015-02-03 2015-06-19 15258 Autobody Secondary PTSD 13-14 2013-07-02 2019-06-20 ; run; data Want; set Have; _CompletionDate=CompletionDate; _k=year(_CompletionDate)-year(startdate); if _k=1 then do; if StartDate<mdy(6,30,year(StartDate)) then do; CompletionDate=mdy(6,30,year(StartDate)); output; StartDate=CompletionDate+1; CompletionDate=_CompletionDate; output; end; else output; end; else if _k>1 then do; do n=year(StartDate) to year(_CompletionDate)-1; if n=year(StartDate) then do; if StartDate<mdy(6,30,n) then do; CompletionDate=mdy(6,30,n); output; TermCalendarID = catx('-',put(input(substr(TermCalendarID,1,2),8.) + 1,2.),put(input(substr(TermCalendarID,4,2),8.) + 1,2.)); StartDate=CompletionDate+1; CompletionDate=mdy(6,30,n+1); output; end; else do; CompletionDate=mdy(6,30,n+1); output; end; end; else if year(StartDate)<n<year(_CompletionDate)-1 then do; startdate=mdy(7,1,n); CompletionDate=mdy(6,30,n+1); TermCalendarID = catx('-',put(input(substr(TermCalendarID,1,2),8.) + 1,2.),put(input(substr(TermCalendarID,4,2),8.) + 1,2.)); output; end; else if n=year(_CompletionDate)-1 then do; startdate=mdy(7,1,n);CompletionDate=_CompletionDate; TermCalendarID = catx('-',put(input(substr(TermCalendarID,1,2),8.) + 1,2.),put(input(substr(TermCalendarID,4,2),8.) + 1,2.)); output; end; end; end; else output; drop n _:; run; Results: StudentUID Programs EnrollmentStatus RegisterStatus TermCalendarID StartDate CompletionDate 785 CulinaryArts PostSecondary PostSec 15-16 2015-09-10 2016-06-17 2774 Autobody PostSecondary PostSec 15-16 2015-09-10 2016-06-30 2774 Autobody PostSecondary PostSec 16-17 2016-07-01 2017-06-15 10543 CulinaryArts PostSecondary PostSec 13-14 2013-07-02 2014-06-30 10543 CulinaryArts PostSecondary PostSec 14-15 2014-07-01 2015-06-20 11609 Carpentry PostSecondary PostSec 13-14 2013-07-02 2014-06-20 12064 Hairstyling PostSecondary PostSec 16-17 2016-02-01 2016-06-30 12064 Hairstyling PostSecondary PostSec 16-17 2016-07-01 2017-06-17 12065 Automotive PostSecondary PostSec 16-17 2016-02-01 2016-06-30 12065 Automotive PostSecondary PostSec 17-18 2016-07-01 2017-06-30 12065 Automotive PostSecondary PostSec 18-19 2017-07-01 2018-06-30 12065 Automotive PostSecondary PostSec 19-20 2018-07-01 2019-06-22 13687 CulinaryArts PostSecondary PostSec 13-14 2013-09-05 2014-06-30 13687 CulinaryArts PostSecondary PostSec 14-15 2014-07-01 2015-06-30 13687 CulinaryArts PostSecondary PostSec 15-16 2015-07-01 2016-06-20 13855 Automotive PostSecondary PostSec 15-16 2015-02-03 2015-06-19 15258 Autobody Secondary PTSD 13-14 2013-07-02 2014-06-30 15258 Autobody Secondary PTSD 14-15 2014-07-01 2015-06-30 15258 Autobody Secondary PTSD 15-16 2015-07-01 2016-06-30 15258 Autobody Secondary PTSD 16-17 2016-07-01 2017-06-30 15258 Autobody Secondary PTSD 17-18 2017-07-01 2018-06-30 15258 Autobody Secondary PTSD 18-19 2018-07-01 2019-06-20

twildone · ‎11-19-2018

Hi....I am trying to correct the entries in Dept for the same ID by changing them to the entry that is entered for Dept when Section = s1 except for when Dept=a4. Any suggestions? Thanks data one; input ID Dept$ Section$ credit; datalines; 1 a1 s1 1 a1 s2 0.5 1 a2 s3 1.0 1 a2 s4 1.0 1 a4 s5 1.0 1 a4 s6 2 a1 s3 1.0 2 a1 s2 0.5 2 a2 s1 2 a3 s4 1.0 2 a4 s5 1.0 2 a1 s5 0.5 2 a1 s5 1.0 2 a1 s6 1.0 2 a3 s6 2 a2 s6 1.0 3 a4 s5 0.5 3 a2 s5 3 a2 s5 1.0 3 a1 s1 3 a1 s2 1.0 3 a1 s3 1.0 ; run; Want: data want; 1 a1 s1 1 a1 s2 0.5 1 a1 s3 1.0 1 a1 s4 1.0 1 a4 s5 1.0 1 a4 s6 2 a2 s3 1.0 2 a2 s2 0.5 2 a2 s1 2 a2 s4 1.0 2 a4 s5 1.0 2 a2 s5 0.5 2 a2 s5 1.0 2 a2 s6 1.0 2 a2 s6 2 a2 s6 1.0 3 a4 s5 0.5 3 a1 s5 3 a1 s5 1.0 3 a1 s1 3 a1 s2 1.0 3 a1 s3 1.0

twildone · ‎10-09-2018

Thanks mkeintz...works perfectly!!

twildone · ‎10-09-2018

Hi....I am trying to expand the record if the EndDate carries over to another Season. The Season are Fall from September 1 thru to the following January 31, Winter from February 1 thru March 31, Spring from April 1 thru June 30 and Summer from July 1 thru August 31. I was able to calculate "EndD" as the last day of the Start of the Season. Not sure how to proceed from here....any suggestions. Thanks. data Have; infile datalines dsd truncover; input STD:yymmdd10. ENDT:yymmdd10. menu:$4.; datalines4; 2016-09-02,2017-06-24,IDEM 2016-10-08,2017-04-26,IDEM 2016-11-15,2017-05-30,IDEM 2016-12-29,2017-01-15,IDEM 2017-01-02,2017-06-27,IDEM 2016-02-08,2016-05-24,IDEM 2016-03-15,2016-10-26,IDEM 2016-04-29,2016-08-29,IDEM 2016-05-02,2016-11-23,IDEM 2016-06-08,2016-07-25,IDEM 2016-07-15,2016-08-27,IDEM 2016-08-29,2016-12-15,IDEM ;;;; data new; length SeasonStart SeasonEnd $6.; format SeasonStart SeasonEnd $6.; set Have; if substr(put(STD,yymmdd10.),6,2) in ('09','10','11','12','01') then do; StartDate = put(STD,yymmdd10.); EndDate = put(ENDT,yymmdd10.); EndD = put(intnx('year.2',STD,0,'e'),yymmdd10.); SeasonStart = 'Fall'; end; if substr(put(STD,yymmdd10.),6,2) in ('02') then do; StartDate = put(STD,yymmdd10.); EndDate = put(ENDT,yymmdd10.); EndD = put(intnx('year.7',STD,0,'e'),yymmdd10.); SeasonStart = 'Winter'; end; if substr(put(STD,yymmdd10.),6,2) in ('03','04','05','06') then do; StartDate = put(STD,yymmdd10.); EndDate = put(ENDT,yymmdd10.); EndD = put(intnx('year.7',STD,0,'e'),yymmdd10.); SeasonStart = 'Spring'; end; if substr(put(STD,yymmdd10.),6,2) in ('07','08') then do; StartDate = put(STD,yymmdd10.); EndDate = put(ENDT,yymmdd10.); EndD = put(intnx('year.9',STD,0,'e'),yymmdd10.); SeasonStart = 'Summer'; end; if substr(put(ENDT,yymmdd10.),6,2) in ('09','10','11','12','01') then do; SeasonEnd = 'Fall'; end; if substr(put(ENDT,yymmdd10.),6,2) in ('02','05','06') then do; SeasonEnd = 'Winter'; end; if substr(put(ENDT,yymmdd10.),6,2) in ('03','04') then do; SeasonEnd = 'Spring'; end; if substr(put(ENDT,yymmdd10.),6,2) in ('07','08') then do; SeasonEnd = 'Summer'; end; run; Want: SeasonStart SeasonEnd STD ENDT menu StartDate EndDate EndD StartDate1 EndDate1 Season Fall Winter 20699 20994 IDEM 2016-09-02 2017-06-24 2017-01-31 2016-09-02 2017-01-31 Fall Fall Winter 20699 20994 IDEM 2016-09-02 2017-06-24 2017-01-31 2017-02-01 2017-03-31 Winter Fall Winter 20699 20994 IDEM 2016-09-02 2017-06-24 2017-01-31 2017-04-01 2017-06-24 Spring Fall Spring 20735 20935 IDEM 2016-10-08 2017-04-26 2017-01-31 2016-10-08 2017-01-31 Fall Fall Spring 20735 20935 IDEM 2016-10-08 2017-04-26 2017-01-31 2017-02-01 2017-03-31 Winter Fall Spring 20735 20935 IDEM 2016-10-08 2017-04-26 2017-01-31 2017-04-01 2017-04-26 Spring Fall Winter 20773 20969 IDEM 2016-11-15 2017-05-30 2017-01-31 2016-11-15 2017-01-31 Fall Fall Winter 20773 20969 IDEM 2016-11-15 2017-05-30 2017-01-31 2017-02-01 2017-03-31 Winter Fall Winter 20773 20969 IDEM 2016-11-15 2017-05-30 2017-01-31 2017-04-01 2017-05-30 Spring Fall Fall 20817 20834 IDEM 2016-12-29 2017-01-15 2017-01-31 2016-12-29 2017-01-15 Fall Fall Winter 20821 20997 IDEM 2017-01-02 2017-06-27 2017-01-31 2017-01-02 2017-01-31 Fall Fall Winter 20821 20997 IDEM 2017-01-02 2017-06-27 2017-01-31 2017-02-01 2017-03-31 Winter Fall Winter 20821 20997 IDEM 2017-01-02 2017-06-27 2017-01-31 2017-04-01 2017-06-27 Spring Winter Winter 20492 20598 IDEM 2016-02-08 2016-05-24 2016-06-30 2016-02-08 2016-03-31 Winter Winter Winter 20492 20598 IDEM 2016-02-08 2016-05-24 2016-06-30 2016-04-01 2016-05-24 Spring Spring Fall 20528 20753 IDEM 2016-03-15 2016-10-26 2016-06-30 2016-03-15 2016-03-31 Winter Spring Fall 20528 20753 IDEM 2016-03-15 2016-10-26 2016-06-30 2016-04-01 2016-06-30 Spring Spring Fall 20528 20753 IDEM 2016-03-15 2016-10-26 2016-06-30 2016-07-01 2016-08-31 Summer Spring Fall 20528 20753 IDEM 2016-03-15 2016-10-26 2016-06-30 2016-09-01 2016-10-26 Fall Spring Summer 20573 20695 IDEM 2016-04-29 2016-08-29 2016-06-30 2016-04-29 2016-06-30 Spring Spring Summer 20573 20695 IDEM 2016-04-29 2016-08-29 2016-06-30 2016-07-01 2016-08-29 Summer Spring Fall 20576 20781 IDEM 2016-05-02 2016-11-23 2016-06-30 2016-05-02 2016-06-30 Spring Spring Fall 20576 20781 IDEM 2016-05-02 2016-11-23 2016-06-30 2016-07-01 2016-08-31 Summer Spring Fall 20576 20781 IDEM 2016-05-02 2016-11-23 2016-06-30 2016-09-01 2016-11-23 Fall Spring Summer 20613 20660 IDEM 2016-06-08 2016-07-25 2016-06-30 2016-06-08 2016-06-30 Spring Spring Summer 20613 20660 IDEM 2016-06-08 2016-07-25 2016-06-30 2016-07-01 2016-07-25 Summer Summer Summer 20650 20693 IDEM 2016-07-15 2016-08-27 2016-08-31 2016-07-15 2016-08-27 Summer Summer Fall 20695 20803 IDEM 2016-08-29 2016-12-15 2016-08-31 2016-08-29 2016-08-31 Summer Summer Fall 20695 20803 IDEM 2016-08-29 2016-12-15 2016-08-31 2016-09-01 2016-12-15 Fall

twildone · ‎10-02-2018

Hi....I was wondering if it is possible to increase the size of the graph that is displayed insider the border especially vertically as some the countries are hard to distinguish or is this fixed since the map is pre-produced. Also, is there a way to suppress the title for this map as if I don't specify a title, a title of World Population appears. Thanks. goptions gunit=pct cback=white htitle=4 htext=3 border reset=all; title Enrolment - Fall 2018; proc sgmap mapdata = maps.world maprespdata = List114 plotdata = List114; choromap IDName / mapid = id id = id; text X = xc Y = yc text = IDName1 / textattrs = (weight = bold size = 1.5pct color = black ); run;

twildone · ‎09-24-2018

Hi....I would like to annotate the names of a country and population size from a list so that the only the names on the country along with their population size appears on the world map. I have found a lot of information that annotates cities but I can't find much on countries. Thanks. proc sgmap mapdata=maps.world maprespdata=sashelp.demographics; choromap id / mapid=id id=id; run;

twildone · ‎09-18-2018

Hi....thanks for the suggestion.....that what was needed.

twildone · ‎09-18-2018

Hi.....I am having trouble to get the following code to work properly. Within each ID, I am trying to replace the missing entries with non-missing entry for that ID. What I am getting is the missing entries are being replaced with the non-missing entry until it reaches a non-missing entry then it continues to replace the following missing entries with that non-missing entry. It seems to ignore the grouping by ID. Am I missing something?...Thanks. data want; set have; by ID notsorted; retain _Program; if not missing(Program) then _Program = Program; else Program = _Program; run;

twildone · ‎09-12-2018

Hi Chris.....yes it makes sense and your right there are duplicates. The data is actually accounting data where the description field may have the same entries such as Tuition Payment where the student may have made tuition payments as installment payment on different dates so there would be multiple records to record each of the payments as Tuition Payment.

twildone · ‎09-12-2018

Hi Chris....thanks for your suggestion. I tried your suggestion and I am getting the following error message: ERROR: For format MAP, this range is repeated, or values overlap: 157796-157796.

twildone · ‎09-11-2018

Hi.....I am trying to replace the entry of "International" in the description field if there is an entry of either 'Intnal - BAA', 'Intnal - CA', 'Intnal - AM' or 'Intnal - MOA' appears for the same ID with either 'Business Administrative Assistant', 'Carpentry', 'Auto Mechanics' or 'Medical Office Assistant'. Any suggestions...thanks in adavance. data have; input id description; cards; 1 International 1 Seat Deposit 1 Intnal - BAA 2 International 2 Admin Fee 2 Seat Deposit 2 Intnal - CA 3 International 3 Intnal – AM 4 International 4 Admin Fee 4 Seat Deposit 4 Lab Fee 4 Text Book 4 Intnal - MAA ; Want; 1 Business Administrative Assistant 1 Seat Deposit 1 Intnal - BAA 2 Carpentry 2 Admin Fee 2 Seat Deposit 2 Intnal - CA 3 Auto Mechanics 3 Intnal – AM 4 Medical Office Assistant 4 Admin Fee 4 Seat Deposit 4 Lab Fee 4 Text Book 4 Intnal - MOA

twildone · ‎08-07-2018

proc report data =summary_dataset list; columns gr dem (("Applied" apply_count),year gap ("Interviewed" interviewed_mean),year gap ("Hired" hired_mean),year); define gr / group ' ' noprint; define dem / group " "; define apply_count / analysis sum " " format = comma8.; define interviewed_mean / analysis sum " " format = percent8.; define hired_mean / analysis sum " " format = percent8.; define year / across ""; define gap / ' ' style={cellwidth=.25in}; break after gr / summarize; compute after gr; dem = 'Total'; line ' '; endcomp; run;

Online Status	Offline
Date Last Visited	‎09-09-2023 12:44 PM

Re: re: Error Message

Re: re: Error Message

Re: re: Error Message

Error: A lock is not available Message

Re: re: Annualizing rates

re: Annualizing rates

Re: re: proc tabulate subtotal & total

re: proc tabulate subtotal & total

Re: re: expanding rows

re: expanding rows

Re: Filling blank cells with data till the next filled cell using do l...

Re: Warning Message

Re: Iterative Loop

Re: re: Bar Label Font Size

Re: re: Bar Label Font Size

re: Assign Numbers

Re: re: Cumulative Sum

Re: re: Cumulative Sum

re: Cumulative Sum

Re: correct entry

Re: RE: Fillining in Missing Entries

RE: Fillining in Missing Entries

Re: Change Incremented Value

Re: Change Incremented Value

re: change entries based on conditions

Re: re: Expand Records

re: Expand Records

re: increase vertical displayed graph

re: annotate country names on world map

Re: re: filling in missing entries

re: filling in missing entries

Re: re Replace value within ID if condition satisfied DESCRIPTION =: '...

Re: re Replace value within ID if condition satisfied

re Replace value within ID if condition satisfied

Re: Add total rows in proc report