@TB10 wrote: I have the following type of code in sql: TRANSFORM Max(ConfigValue) SELECT Config_ID FROM TABLE_01 GROUP BY Config_ID PIVOT ConfigField how do i convert it in sas to get the same result ?   What does that gibberish code do?  Show an example input.  Describe the change you want to make.  Show the resulting output for that input.   If you want to calculate some type of maximum value then I you might want to start with PROC SUMMARY. ... View more

@TB10 wrote: @PaigeMiller @Quentin  i tried this but i am unable to check the values of a and b when i write put a; put b; out side of the loop. Anyway to check the values. As mentioned i am unable to access the variable values outside the loop. Perhaps you intended the values of A and B to be retained across iterations (in a simple data step that is the same as across observations) of the data step.  Add a RETAIN statement. retain A B ; You also need to have a FORMAT statement so the date values will print in a human recognizable style. format A B yymmdd10.;   ... View more

Last try! 🙂   Have you had a look at https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acpcref/n0msy4hy1so0ren1acm90iijxn8j.htm#n1t07gqiy7mbf4n10pykf2o5457z ? It seems, that there are two options, SCANTIME and USEDATE that influence the format that is applied to date/time data ... I guess (!) USEDATE=NO and SCANTIME = NO does the trick.  Not sure (and entirely untested) ... I'd try all four possibilities.    Please report any progress ... in case you are successful   --fja ... View more