topic Proc Import delimiters using SAS Prompts in SAS Programming

Proc Import delimiters using SAS Prompts

simmwa — Mon, 19 Jun 2023 03:52:46 GMT

I wish to use the below code to import txt files with one of the following delimiters : '09'x '7E'x '2C'x

This works fine if I use e.g. %let mydelim='09'x; directly in my code.

But I want to assign one of the delimiters using SAS Prompts and it wont work with hex values.

Any suggestions?

proc import	
	datafile=&in_file. 
	out=outfile 
	dbms=dlm 
	replace; 
	delimiter=&mydelim.; 
run;

simmwa — Mon, 19 Jun 2023 04:32:40 GMT

Below seems to work with double quotes (not sure why single quotes fails) with the Prompt setting mydelim to either 09, 7E or 2C

proc import	
	datafile=&in_file. 
	out=outfile 
	dbms=dlm 
	replace; 
	delimiter="&mydelim."x; 
run;

SASKiwi — Mon, 19 Jun 2023 05:26:08 GMT

Macro variables don't resolve inside single quotes, but do inside double quotes.