Hi All, I need your help to resolve this issue which i am having regarding base SAS. I have two dataset named 1)totalmergenodup_addmcap_3 and 2) fo_new. The totalmergenodup_addmcap_3 is having variable Unadjprice with below details, # Variable Type Len Format Informat Label Value ============================================================================== 30 UNADJPRICE Char 21 $21. $21. Unadjprice 57.83 in second dataset, i have variable Networth with below details, # Variable Type Len Format Informat Label Value =============================================================================== 21 NETWORTH Num 8 BEST12. Networth 69.15 now i want to calculate PbyB (a new variable), so i want something like that PbyB=Unadjprice/Networth. i want this new variable added in totalmergenodup_addmcap_3 dataset with calculated value, how can i do that? i know maybe its having very simple logic but below things which i have tried and i didn't get value, i am getting only missing value for new variable PbyB. since i want to calculate pbyb i tried to use put and input function to convert either of the variable in Char or in Numeric and calculated, but i got missing second i have a tried to use Divide function hoping something i am doing wrong with put and input, it still didn't work. then i thought maybe its regarding to formating so i used proc dataset with format statement to remove format and create new, still didn't work. Please give me explanation with the code if anyone able to do that, i know it's must be having some easy way but just want to figure out what i am doing wrong. Thanks a Lot Guys in advanced for your unending Support. Regards, Tushar Jagtap.
... View more