Need help with code of seperate variables with delimiter

[manilara44]

i have data set in note pad like that i want import into sas 

Car Make Model Type Origin Seat MRP Show Room Price Rate Star
Acura|MDX|SUV|Asia|All|$36,945|$33,337|3.5|
Acura|RSX Type S 2dr|Sedan|Asia|Front|$23,820|$21,761|2|

Those data have delimiter value of |

Expected result as

Result
Car Make  Model    Type   Origin  Seat      MRP      Show Room Price Rate Star
Acura        MDX      SUV    Asia    All         $36,945  $33,337                  3.5
Acura        RSK      Sedan   Asia  Front      $23,820 $21,761                    2

[PaigeMiller]

Here's an example:

https://documentation.sas.com/?docsetId=proc&docsetTarget=n03ji3gyt52p10n1mma27gr6rdxg.htm&docsetVer...

[manilara44]

Can u help me with code of real data of mine? i want code for import and input file statement too?

[Reeza]

Save your data to a text file. 

Use PROC IMPORT on that text file. 

The code you need will be in the log and you can customize it as needed.

Otherwise, follow the instructions here, example 5 specifically.

https://stats.idre.ucla.edu/sas/modules/inputting-data-into-sas/

[PaigeMiller]

All you have to do in the example is change the & to |