topic Re: Date converting in New SAS User

Date converting

Lightyears — Sat, 23 Jan 2021 21:33:50 GMT

Hi new to SAS. I have a date in a table that comes back in the format of character

Dateto
20200214

How in my project can I get it to display as a date in UK format.

Dateto
14/02/2020

Any help grateful. Thank you.

Re: Date converting

PaigeMiller — Sat, 23 Jan 2021 21:44:25 GMT

data want;
     chardate='20200214';
     numdate=input(chardate,yymmdd8.);
     format numdate yymmdds10.;
run;

Re: Date converting

Lightyears — Sat, 23 Jan 2021 22:05:30 GMT

Thanks. When adding it to my select statement in my program, do I replace where you put the actual date entered in the field with the field name ‘dateto’?

Re: Date converting

SASKiwi — Sat, 23 Jan 2021 22:14:49 GMT

To answer your question we need to see your actual code.

Re: Date converting

Lightyears — Sat, 23 Jan 2021 22:53:45 GMT

as SELECT DISTINCT

t2.ac,

t1.ext_ui

t1.vkonto,

t1.vkbez as sap_name,

t1.einzdat as dateto,

t1.auszdat as datefrom

FROM analytics_temp_user.List t2 inner join analytics_pm6.ALLSAPDATA t1

Re: Date converting

PaigeMiller — Sat, 23 Jan 2021 23:12:20 GMT

input(t1.einzdat,yyddmm8.) as dateto format=yymmdds10.,

Re: Date converting

Tom — Sat, 23 Jan 2021 23:12:04 GMT

You can replace the reference to the existing variable with the function call. Attach the format to control how the resulting date values are displayed.

SELECT DISTINCT
 t2.ac
,t1.ext_ui
,t1.vkonto
,t1.vkbez as sap_name
,input(t1.einzdat,yymmdd8.) as dateto format=ddmmyy10.
,input(t1.auszdat,yymmdd8.) as datefrom format=ddmmyy10.
FROM analytics_temp_user.List t2
  inner join analytics_pm6.ALLSAPDATA t1

Re: Date converting

Lightyears — Sun, 24 Jan 2021 11:38:51 GMT

Thanks all. I put it in as below but get this error.

ERROR: Execute error: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line
1:522 cannot recognize input near 'yymmdd8' '.' ')' in select expression

as SELECT DISTINCT
t2.ac,
t1.ext_ui,
t1.vkonto,
t1.vkbez as sap_name,
input(t1.einzdat,yymmdd8.) as dateto format=ddmmyy10.,
input(t1.auszdat,yymmdd8.) as datefrom format=ddmmyy10.

FROM analytics_temp_user.List t2
inner join analytics_pm6.ALLSAPDATA t1

Re: Date converting

PaigeMiller — Sun, 24 Jan 2021 14:41:55 GMT

Please do not show us the errors separated from the code. Please do show us the entire LOG for your PROC SQL step, with nothing chopped out, in the order that it appears in the LOG.

Please also help us out by formatting the log properly by copying it as text and pasting it into the window that appears when you click on the </> icon. PLEASE DO NOT SKIP THIS STEP. I no longer try to read logs that are not formatted properly.