hi, below are my codes of importing a text files. One of the value from the name variabes consists of " " quotation mark which i need to output it. But i cant seems to get that output using the ~ function. As the example below, my name variables must read the quotation mark --> Brown, Mrs James Joseph (Margaret "Molly" Tobin) . example this row : "37","1st",1,"Brown, Mrs James Joseph (Margaret "Molly" Tobin)",44.0000,"Cherbourg","Denver, CO","","17610 L27 15s 5d","6","female" ------------------------------------------------------------------------------------------------------ length row_names 3 pclass $3 survived 3 name $82 _age $3 age 3 embarked $3 home_dest $70 room $5 ticket $20 boat $3 sex $10; infile '/home/yewkeong0/assignemnt/titanic.txt' dsd dlm=',' missover; input row_names pclass $ survived name ~ $82. _age embarked $ home_dest $ room $ ticket $ boat $ sex $; if _age = 'NA' then age = . ; else age = input(_age , 3.); drop _age; run; any suggestion guys??? =/
... View more