I want to retain a date from the line above.    I have this:   ID   Date1                  Date2 1     2022-04-01         2022-05-31 1     2021-07-20         2021-08-20 2     2021-07-28         2021-08-23 2     2021-08-21         2021-09-30   I want this:   ID   Date1                  Date2              Newdate (date 1 from the line above) 1     2022-04-01         2022-05-31      . 1     2021-07-20         2021-08-20     2022-04-01 2     2021-07-28         2021-08-23      . 2     2021-08-21         2021-09-30     2021-07-28     Why isnt this working   data want; set have; format newdate yymmdd10.; by ID; retain newdate 0; if first.ID then newdate = .; else newdate = date1; run; ... View more

I download data through an api (GET method). I receive data in json. How do I decode åäö correctly in the column "member_title"? (Encoding=wlatin1).    My code: filename test "C:\Users\......json"; proc http method="GET" url="http://api.kolada.se/v2/kpi_groups?title=agenda 2030" out=test; run;   libname x json fileref=test; proc copy in=x out=work ; run;   The result: ordinal_values ordinal_members member_id member_title 1 1 N00209 Heltidsarbetande mÃ¥nadsavlönade, kommun, andel (%) 1 2 N00401 Utsläpp till luft av växthusgaser totalt, ton CO2-ekv/inv. ... View more