topic How to get the delimiter as special character in IMPORT DATA TASK in SAS Enterprise Guide 8.3 ? in SAS Enterprise Guide

How to get the delimiter as special character in IMPORT DATA TASK in SAS Enterprise Guide 8.3 ?

THALLA_REDDY — Thu, 07 Jan 2021 11:53:38 GMT

Hi Team,

I am reading a comma ( , ) delimited file using IMPORT DATA Task in SAS Enterprise guide 8.3. I am getting the data as expected while reading the file but when see the code generated by IMPORT DATA Task the delimiter value is showing in HEX converted value.

Ex: In my file comma is the delimiter and usually I have to see it as DLM=',' In the code but i am seeing as DLM='2c'x .

Can anyone help me if there is any option to see the delimiter as comma ( , ) instead of HEX Value.

thanks in advance,

thalla

Re: How to get the delimiter as special character in IMPORT DATA TASK in SAS Enterprise Guide 8.3 ?

PhilC — Thu, 07 Jan 2021 18:43:16 GMT

I don't know if you need to keep your "Import Data (file.csv)" Task Icon as a Task that remains adjustable by its GUI dialog. If your code is not going to change using the GUI, or if you don't mind adjusting your import parameters using SAS code you may consider this. RIght clicking the Task and using "Extract Code". This produces a program node with the DATA step generated by the Import Data Task for your import. In this program node you should be free to edit the DLM parameter.