topic Re: Character variable to character date variable in SAS Programming

Character variable to character date variable

bharath86 — Fri, 21 Jan 2022 15:51:12 GMT

Hi,

Below is an example of the data I have.

Both A and B must be character types.

I just want to assign a date format to column A so that I get output as column B.

how can I do this efficiently without any warnings? Please advise.

Tom — Fri, 21 Jan 2022 16:06:47 GMT

Is this what you want?

If the string in A can be interpretted as YYYYMMDD then make B have the same date printed with slash delimiters. Otherwise just copy A to B.

data want;
  set have;
  date = input(a,??yymmdd8.);
  if not missing(date) then b=put(date,yymmdds10.);
  else b=a;
  drop date;
run;

bharath86 — Fri, 21 Jan 2022 16:22:14 GMT

Thank you sir.