Reading special characters like >

[ashvene30]

Under the HamiltonRatingScaleforDepression, No of Facebook Posts, No of Twitter Posts and Number of Clicks on Anti-Depression items columns in my file, there are special characters such as >. How do I write a code to read these characters?

[Cynthia_sas]

Hi:

  If you examine your file with NOTEPAD, you'll see that the field with the > and < characters is quoted:

So a standard PROC IMPORT should read the value as character. Or, you could write a DATA Step program and explicitly read the field as character. In a character variable value, any alpha characters, including punctuation are allowed.

Cynthia

[ashvene30]

How do I write a standard proc import query?

[Kurt_Bremser]

Maxim 1: Read the Documentation.

See IMPORT Procedure