topic Re: how can we assign vales 15 for un and 07 for unk plss give a solution anyone in SAS Programming

how can we assign vales 15 for un and 07 for unk plss give a solution anyone

yogeswar_123 — Thu, 21 Jul 2022 02:00:13 GMT

data datechar;

input subid char $9.;
cards;
1 04jan2015
2 06feb2019
3 08nov2022
4 undec2016
5 ununk2017
6 15jul2013
run;

Re: how can we assign vales 15 for un and 07 for unk plss give a solution anyone

andreas_lds — Fri, 22 Jul 2022 09:35:48 GMT

Please rephrase your question without using abbreviations.

Re: how can we assign vales 15 for un and 07 for unk plss give a solution anyone

s_lassen — Fri, 22 Jul 2022 11:15:24 GMT

I assume you want to correct the input CHAR to a valid date, using averages. Something like this, maybe?

data datechar;
  input subid char $9.;
  if substr(char,1,2)='un' then
    substr(char,1,2)='15';
  if substr(char,3,3)='unk' then 
    substr(char,3,3)='JUL';
  date=input(char,date9.);
  format date date9.;
  drop char;
drop char;
cards;
1 04jan2015
2 06feb2019
3 08nov2022
4 undec2016
5 ununk2017
6 15jul2013
;run;

(apart from adding the calculation of the substrings, I also added a semicolon before the "run;")

Re: how can we assign vales 15 for un and 07 for unk plss give a solution anyone

Kurt_Bremser — Fri, 22 Jul 2022 13:03:01 GMT

And then somebody will start to investigate why the majority of accidents happen in July.