topic Re: Need help with code of seperate variables with delimiter in New SAS User

Need help with code of seperate variables with delimiter

manilara44 — Sat, 18 Jul 2020 10:48:32 GMT

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

Re: Need help with code of seperate variables with delimiter

PaigeMiller — Sat, 18 Jul 2020 11:32:43 GMT

Here's an example:

https://documentation.sas.com/?docsetId=proc&docsetTarget=n03ji3gyt52p10n1mma27gr6rdxg.htm&docsetVersion=9.4&locale=en

Re: Need help with code of seperate variables with delimiter

manilara44 — Sat, 18 Jul 2020 11:50:26 GMT

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

Re: Need help with code of seperate variables with delimiter

Reeza — Sat, 18 Jul 2020 14:27:57 GMT

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/

Re: Need help with code of seperate variables with delimiter

PaigeMiller — Sat, 18 Jul 2020 14:35:47 GMT

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