Okay, thanks to you all ... View more

Hey, I realise that when I use "ln" in excel (as ghosh sugested) instead of log I get the same results. Should I conclude that log in SAS = ln in excel?   ... View more

Hello all,  thanks for your responses and the ideas. Here are some data samples am using and the corresponding results I got in SAS compared to excel:   TJC28 SJC28 CRP GG SAS: NewVar Excel Results 3 3 0,09 18 0,02136075 0,97489243 0 0 0,7 20 0,03032754 0,17156863 0 0 0,6 30 0,06242206 0,26470588 0 0 1 5 0,07 0,07 0 0 0,02 0 -2,7384161 -1,189279 0 0 0,02 10 -2,5984161 -1,049279 0 0 0,023 5 -2,5705827 -1,0767905 0 0 0,031 5 -2,3616377 -0,9860468   This is the formula: 0,56x√(TJC28)+0,28x√(SJC28)+0,70xlog nat (CRP)+0,014xGG and this was how I interpretted it in SAS NewVar=(0.56*sqrt(TJC28))+(0.28*sqrt(SJC28))+(0.70*log(CRP))+(0.014*GG); You can see that the results I get from SAS is different from what I get from SAS. My caculator gives the same results like excel. Thanks for any solution     ... View more

@Kurt_Bremser: I know I don't have to get negative values for NewVar but I do have negative values. When I do the calculation in excel or with my calculator I get different results ... View more

@ChrisNZ: Yes the values are the same on both sides ... View more

how do you mean, to break the formula components. The given names are the variable names ... View more

@ballardw @Tom @PaigeMiller  Thanks to you all for the help. I have finally imported the data into to SAS correctly using datastep. This previously did not work because the DB wasn't clean. For example numeric fields had also text values.    I also realised that the main problem, was the order of the variables in the datastep. It didn't match the order of the variables in the csv file, so this seemed to have confused SAS, that was why the output wasn't correct.   There were some other small issues but I have been able to resolve them.  This was very time consuming due to the large number of variables in the file but am happy, my work wasn't in vain ... View more

Yes, you are right but in my case the data step does work properly because of the problem with the variables. I cannot connect directly to postgresql because the data is from an external body who works with postgresql. I receive just the delimited file from them ... View more

The data comes from Postgresql and contains 1634 variables and 1985 observations. The variable names are very long and have special characters. I have tried all means to use sas to import but no way.  I ended up using stattransfer to import this to sas. I realise that, all my num vars are converted to char. Dates to chars. For the issue with the dates I have been able to solve it. some decimal values like 4.2 are converted to 4.Feb It isn't easy to edit this file, even though it's a delimited file (semicolon seperated)   the most tedious part are the long varnames ... View more

I need to test the methods patiently to see which works for me. I will let you know then when am done. Thankyou both for the help. ... View more

I get the following errors on running the code:   ERROR: Open code statement recursion detected. 1775 1776 data _null_; 1777 row+1; --- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 1778 length c n r $32000; ------ 180 ERROR 180-322: Statement is not valid or it is used out of proper order.     ... View more