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;
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;
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;
Macro variables don't resolve inside single quotes, but do inside double quotes.
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
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.
Ready to level-up your skills? Choose your own adventure.