About nikhilbajaj

Tom · ‎10-04-2014

So when you convert INSD_N from numeric to character it is still not matching the character strings in the other table? If the numbers require less than the full 8 characters when converted from number to character with the PUT() function then they will be RIGHT aligned with the PUT() function result. Usually character variables are LEFT align. Try wrapping the PUT() function inside of a LEFT() function and see if it helps. N=5.3 put(N,8.1) -> ' 5.3'

nikhilbajaj · ‎09-26-2014

So this is my final query- rsubmit; proc sql; create table TEST_RESULT as select put(CAL_D,date9.) from EDT01371_DATE where CAL_Y > 2007 and CAL_Y < 2016 except all select put(CAL_D,dtdate9.) from CSTDM011_DATE where D_DIM_ID_N not in (0,1,2); select count(*) from TEST_RESULT; Thank you all for the efforts

Ksharp · ‎09-10-2014

Maybe you should uniform these variables name . These two set of variables should be the same name . Just Guest. Xia Keshan

Ksharp · ‎08-09-2014

Try : case when CATS(A.OFFRG_N, A.CRT_TS) in (select CATS(OFFRG_N, CRT_TS) from CSTST231_PMRINSD where BUSN_TY_SEG_C = 'New' or BURN_TY_SEG_C = 'Renl')

nikhilbajaj · ‎08-08-2014

Thank you so much, It worked for me. And now I am on the second challenge.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

Re: conversion from decimal to characters

Re: conversion from decimal to characters

Re: conversion from decimal to characters

conversion from decimal to characters

Re: SAS problem with Oracle dates

Re: SAS problem with Oracle dates

SAS problem with Oracle dates

Re: weired output with except all command

Re: weired output with except all command

weired output with except all command

Re: conversion from decimal to characters

Re: SAS problem with Oracle dates

Re: weired output with except all command

Re: error on comparing two columns together

Re: not able to resolve conversion errors