Hi I need help in converting this formula to sas iin excel I have formula EOMONTH(AD$2,-1)-EOMONTH(AD$2,-2) that means here AD is 3/31/2015 so the difference I shd use in my formula ccan anyone help ... View more

HHi , i have a formula in excel = (50/-10000) *30.4/(Z2-Y2) when eh we work on dec data Z2-Y2 shd be nov - sep sso the result shd be 30 days can anyone help ... View more

HHi , i have a coloumn product whuch has vslues 1 YEAR TERM 10 YEAR TERM 15 YEAR TERM UNKNOWN hiw to extract the last letter M in 1,10,15 YEAR TERM and how to extract N from unknown can anyone help ... View more

I wrote a case statement case when else 'priya & insurance ' But where & sql is asking for substitute any idea ? how to solve . instead of using priya and insurance . I want priya& insurance in code ... View more

hI i HAVE An EXCEL FORMULA WHICH I NEED TO BUILD UP IN SAS CAN U PLS LET M EKNOW THE CODING IF (FL2=0,0 ,VLOOKUP(V2,'XY SPLIT' !$A$4:$F$11,6,FALSE)) ... View more

I Have a dataset x y and I have to create z x     y CA 02 PA  MX GA  FL BM HI i have to create Z variable in dataset and x and y has state codes when y in 02 then we assign SC some state code but when not numberic then Y as it is but when missing then shd do x=y and. Now Z. Z SC MX FL BM HI          CAn anyone pls help ... View more

hi I hav a dataset which has both numericals and character . When numeric ala I want to change to character but when character leave as it is . When 1 I want to be replaced with FL when it is AZ leave as it is in STate variable ssample dataset ddata test1; input code zipcode; 1 78240 2 23239 3 45670 AL 34567 AZ 43678 ; run; proc sql; create te table xy as select code , pincode, case code when 1 then 'FL' when 2 then 'CA' when 3 then 'SC' else code end as State; from test1; quit; but but this syntax is error ... View more