BookmarkSubscribeRSS Feed
dennis_oz
Quartz | Level 8

 

Hi is there any way we can read a field using infile or proc import for csv file removing the below ascii character 

dennis_oz_0-1590556721708.png

 

1 REPLY 1
Kurt_Bremser
Super User

This symbol is shown in word processors (when showing special characters is activated) to make end-of-lines visible. The line endings are necessary for the RECFM=V in SAS (used when reading CSV files) to work. You do not need to remove them, as the termination strings are automatically used to identify the text lines.

 

BIG HINT:

do NOT use word processors or spreadsheet calculators to view CSV files you want to import into SAS. Always use a proper text editor suited for programming, like Notepad++.

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1450 views
  • 1 like
  • 2 in conversation