topic Re: How to assing into a macro varibale in SAS Programming

How to assing into a macro varibale

vThanu — Thu, 04 Apr 2019 12:12:21 GMT

Hi All

I have 10 data sets and it is save in my library as

dt_city_01; (data sets name)

dt_city_02;

dt_city_03; ............. so on to

dt_city_10.

I want to assign city into 1 macro variable and 01,02,03(so on to 10) into other macro variable.....

can any 1 help me out..

thanks in advance.

Re: How to assing into a macro varibale

PaigeMiller — Thu, 04 Apr 2019 12:15:47 GMT

@vThanu wrote:

Hi All

I have 10 data sets and it is save in my library as

dt_city_01; (data sets name)

dt_city_02;

dt_city_03; ............. so on to

dt_city_10.

I want to assign city into 1 macro variable and 01,02,03(so on to 10) into other macro variable.....

Show us the results that you want. I'm afraid I don't find your explanation clear.

Also, where are these 10 data set names located? Are they in a text file, or an Excel file, or a SAS data set, or did you type them into your SAS program, or somewhere else?

Re: How to assing into a macro varibale

Kurt_Bremser — Thu, 04 Apr 2019 13:26:40 GMT

This creates your dataset names:

%macro mymac(dspart=,number=);
%do i = 1 %to &number.;
  %let dsnum=%sysfunc(putn(&i.,z2.));
  %let dsname=dt_&dspart._&dsnum.;
  %put dsname=&dsname.;
%end;
%mend;
%mymac(dspart=city,number=10)

Re: How to assing into a macro varibale

vThanu — Mon, 08 Apr 2019 07:31:31 GMT

SAS data sets (data set name itself saved as dt_city_01..... dt_city_10)....

Re: How to assing into a macro varibale

vThanu — Mon, 08 Apr 2019 07:45:05 GMT

Please find the attached document for your reference....

As per the attached document, I want to create Two macro variables - 1 for City and other for 01

Re: How to assing into a macro varibale

andreas_lds — Mon, 08 Apr 2019 08:16:03 GMT

Please post relevant information as text, many won't open office documents.

Re: How to assing into a macro varibale

Kurt_Bremser — Mon, 08 Apr 2019 09:15:18 GMT

If you want to set a macro variable from the names of datasets, use a "select into" from dictionary.tables in proc sql.

Re: How to assing into a macro varibale

Patrick — Mon, 08 Apr 2019 10:28:20 GMT

@vThanu

I believe most people will understand what you have but it's a bit hard to understand what you want. What's normally really helpful is to get a desired result - like you giving us the name and content of the macro variables you're after in detail.

Below a code sample which hopefully will provide you the hints you need to make things working for you. Run the code and inspect the SAS log.

data work.dt_city_01 work.dt_city_02 work.dt_city_03;
  set sashelp.class;
run;
    
proc sql noprint;
  select 
    memname, memname 
      into :ds_name_mvar1-:ds_name_mvar99, :ds_name_list separated by ' '
  from dictionary.tables
  where libname='WORK' and memname like 'DT^_CITY^_%' escape '^'
  ;
quit;
%put &=sqlobs;
%put &=ds_name_list;

%macro PutCreatedMVars();
%put &=sqlobs;
  %do i=1 %to &sqlobs;
    %put ds_name_mvar&i: &&ds_name_mvar&i;
  %end;
%mend;
%PutCreatedMVars()