topic Reading special characters like > in SAS Studio

Reading special characters like >

ashvene30 — Sat, 07 Dec 2019 15:11:39 GMT

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?

Re: Reading special characters like >

Cynthia_sas — Sat, 07 Dec 2019 17:54:35 GMT

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

Re: Reading special characters like >

ashvene30 — Sun, 08 Dec 2019 03:24:10 GMT

How do I write a standard proc import query?

Re: Reading special characters like >

Kurt_Bremser — Sun, 08 Dec 2019 07:49:26 GMT

Maxim 1: Read the Documentation.

See IMPORT Procedure