topic Re: Convert a string into a dataset name in SAS Programming

Convert a string into a dataset name

rhapsody — Tue, 13 Aug 2019 08:50:07 GMT

I have a string called number_name='1','18','19';. What I want in the end is for that number variable to end up in the name of my final dataset (prediction_&number_name_conv.) . All of this is summarized in the example below.

%let number_name='1','18','19';



data _null_;
call symput('number_name_conv', trim(left(input("&number_name.", comma10.))));
run;



data prediction_&number_name_conv.;

set raw_data;

run;

Re: Convert a string into a dataset name

PeterClemmensen — Tue, 13 Aug 2019 08:59:19 GMT

What do you want the data set name to be in the end?

Re: Convert a string into a dataset name

SwissC — Tue, 13 Aug 2019 09:26:40 GMT

using

call symput('number_name_conv', compress("&number_name", "kn"));

could than give you a dataset called prediction_11819

data _null_;
  a="number_name";
  b=tranwrd(a, "'", "");
  c=tranwrd(b, ",", "_");
  call symput('number_name_conv', compress(c));
run;

would give a final dataset name of prediction_1_18_19

Re: Convert a string into a dataset name

rhapsody — Tue, 13 Aug 2019 10:44:28 GMT

data prediction_&number_name_conv.;

set raw_data;

run;