topic Re: Convert SAS Character Date(06NOV2019) to 20191106 format in SAS DI studio in SAS Studio

Convert SAS Character Date(06NOV2019) to 20191106 format in SAS DI studio

kk21 — Wed, 06 Nov 2019 06:57:02 GMT

Hi ,

I have a date stored in a macro variable (RUN_DATE) which is resolving to 06NOV2019.

I want to store this value in a oracle table with number format like 20191106.

In SAS DI studio I tried using input(&RUN_DATE,DATE9.) in the expression column and in format I selected yymmdd10.

But its giving error ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, , =, , =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. Line 3,986: ERROR 76-322: Syntax error, statement will be ignored.

Please help.

Re: Convert SAS Character Date(06NOV2019) to 20191106 format in SAS DI studio

Astounding — Wed, 06 Nov 2019 11:35:52 GMT

I'm not a DI user, so this answer relies on you knowing the correct steps to use.

Try adding double quotes:

input("&RUN_DATE", date9.)

Re: Convert SAS Character Date(06NOV2019) to 20191106 format in SAS DI studio

kk21 — Wed, 06 Nov 2019 15:52:32 GMT

Double quotes also not working

Re: Convert SAS Character Date(06NOV2019) to 20191106 format in SAS DI studio

PaigeMiller — Wed, 06 Nov 2019 15:56:24 GMT

Show us the LOG, so we can see the code you are using and also the error messages.

Please copy the log AS TEXT, then here in the SAS Communities, click on the {i} icon and paste the log AS TEXT into the window that appears. Do not skip this step.

Re: Convert SAS Character Date(06NOV2019) to 20191106 format in SAS DI studio

ballardw — Wed, 06 Nov 2019 18:48:08 GMT

@kk21 wrote:

Hi ,

I have a date stored in a macro variable (RUN_DATE) which is resolving to 06NOV2019.

I want to store this value in a oracle table with number format like 20191106.

In SAS DI studio I tried using input(&RUN_DATE,DATE9.) in the expression column and in format I selected yymmdd10.

But its giving error ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, , =, , =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. Line 3,986: ERROR 76-322: Syntax error, statement will be ignored.

Please help.

An error message without code is like calling a mechanic over the phone and asking why is my car not running.

Re: Convert SAS Character Date(06NOV2019) to 20191106 format in SAS DI studio

kk21 — Thu, 07 Nov 2019 06:26:10 GMT

Boss code is that much only INPUT("&RUN_DATE.",DATE9.) as RUN_DATE format yymmdd10.

Re: Convert SAS Character Date(06NOV2019) to 20191106 format in SAS DI studio

kk21 — Thu, 07 Nov 2019 06:31:37 GMT

Now I used two transformations ,first is Extract in that did the same thing (INPUT("&RUN_DATE.",DATE9.)) as RUN_DATE but format I used now is yymmddn10(before it was yymmdd10.)

Next I used table loader transformation in that I used (input(put(RUN_DATE,yymmddn8.),best12.)) as RUN_DATE.

And it worked fine for me.

Thanks all for your valuable suggestions.