Sorry, i have no idea what could cause the error message. But if a migration is planed later this year waiting for M9 could be an option. It should be released mid year. ... View more

@acordes wrote: Can I use the these lines within an array loop???   batch_id_dt1=strip(batch_id_dt); drop batch_id_dt; rename batch_id_dt1=batch_id_dt; No, you can't. The variable names can't be inserted by using vname[x]. ... View more

@PaigeMiller wrote: @andreas_lds  Why is a macro needed? Why not just an array to do the looping? For moving the values from char to varchar an array is sufficient, but imho not to drop the char-variables and rename the varchar-vars. With more spare-time i would have suggested a data-null-step writing the code transforming-step without any macro statements. ... View more

Sorting the rooms by descending capacity helped to get the expected result. proc sort data= have; by course descending room_capacity; run; data want; num_students = 0; do _n_ = 1 by 1 until(last.course); set have; by course; num_students = num_students + room_load; end; do _n_ = 1 by 1 until(last.course); set have; by course; new_room_load = min(room_capacity, num_students); num_students = num_students - new_room_load; output; end; drop num_students; run; ... View more

As far as is know, you need - at least - EG 8.4 to connect it to viya. ... View more

imho noduprec should not be used at all - see https://support.sas.com/kb/1/566.html for details. ... View more

Strange. Looks as if TESTUSER7 is not the exact string in the name filed of a person-object. ... View more

Interesting, omsobj-query should work, but this was a rather long day for me, so maybe this hides the error. Some ideas to debug: num_users = metadata_getnobj("omsobj:Login?Login[AssociatedIdentity/Person[@Name = '&name']]", 1, uri); Returns the number of login-objects for the person. Using your screenshot, should be 3 in your case. You should check the number of logins in the auth-domain, too: logins_in_domain = metadata_getnobj("omsobj:Login?Login[Domain/AuthenticationDomain[@Name = '&auth']]", 1, uri);       ... View more

Why are Score1-Score3 alphanumeric vars? Instead of using if-else-statement, i would use a self-defined format to translate/recode scores to grades. data have ; input id score1 - score3; cards; 1 25 50 75 2 100 90 80 3 17 33 72 4 55 43 95 5 76 85 39 ; proc format; value ScoreToGrade . = "-" 0 - 25 = "D" 26 - 50 = "C" 51 - 75 = "B" 76 - 100 = "A" ; run; data want; set have; array scores[3] score1 - score3; array grades[3] $ 1 grade1 - grade3; do i=1 to dim(scores); grades[i]=put(scores[i], ScoreToGrade.); end; drop i; run; If "want" is used in a report afterwards, you could skip creating it and use the format directly: proc print data= have; format Score1-Score3 ScoreToGrade.; run; ... View more

Another question: Another obs for experience C 2018 2022 1  and in work C 2024 What is the expected result? ... View more

Please post data in usable form, making it easier to understand the problem and giving us something to work with. The output statement can be used to create additional obs. ... View more

The data step creating have has errors: unclosed quotes and a run in the middle of the step. The format statement is missing, too.   Saving the first values of police_effective_date and police_end_date in retained variables and using them to set flag when the data step reached to last obs for police seem to create what you want: data want; set have; by police; length flag $ 10 first_eff_date first_end_date 8 ; retain first_:; if first.police then do; first_eff_date = police_effective_date; first_end_date = police_end_date; end; if last.police then do; if police_end_date > first_end_date then do; if police_effective_date = first_eff_date then flag = "EXTENDED"; if police_effective_date > first_eff_date then flag = "SHIFTED"; end; end; drop first_:; run; Assuming the data is sorted by police and end. ... View more