topic Re: Macro : Read values from a macro variable in SAS Programming

Macro : Read values from a macro variable

Stephenjohn — Wed, 18 Aug 2021 15:05:12 GMT

Hello,

Below is the macro variable list , how can we read these values one at a time from this macro variable..

%put &list;
AE AE AEMDSAML AEMDSAML AEMDSAML AEMDSAML AEPNEU AEPNEU AEPNEU AEPNEU AESPM AESPM AESPM C19ASMT CM CNCRTX CNCRTX CNCRTX
CNCRTX_1 CNCRTX_1 CNCRTX_1 CP CP CR CVEVT_ARRH_CR CVEVT_ARRH_CR CVEVT_ARRH_CR CVEVT_ARRH_CR CVEVT_ARRH_CR CVEVT_ARRH_CR
CVEVT_CHF_CR CVEVT_CHF_CR CVEVT_CHF_CR CVEVT_CHF_CR CVEVT_CHF_CR CVEVT_CHF_CR CVEVT_CHF_CR CVEVT_CHF_CR CVEVT_CVATIA_CR
CVEVT_CVATIA_CR CVEVT_CVATIA_CR CVEVT_CVATIA_CR CVEVT_DEATH_CR CVEVT_DEATH_CR CVEVT_DVT_CR CVEVT_DVT_CR CVEVT_DVT_CR
CVEVT_DVT_CR CVEVT_DVT_CR CVEVT_DVT_CR CVEVT_DVT_CR CVEVT_MYOINF_CR CVEVT_MYOINF_CR CVEVT_MYOINF_CR CVEVT_MYOINF_CR
CVEVT_MYOINF_CR CVEVT_MYOINF_CR CVEVT_MYOINF_CR CVEVT_MYOINF_CR CVEVT_PAT_CR CVEVT_PAT_CR CVEVT_PAT_CR CVEVT_PAT_CR
CVEVT_PULHYP_CR CVEVT_PULHYP_CR CVEVT_PULHYP_CR CVEVT_PULHYP_CR CVEVT_REVAS_CR CVEVT_REVAS_CR CVEVT_VALV_CR
CVEVT_VALV_CR CVEVT_VALV_CR CVEVT_VALV_CR CVEVT_VALV_CR CVEVT_VALV_CR DA DEATH DEATH DM DM DM DS EOTN EOTN EOTT EVAL EX
EX_15 EX_IV EX_IV FD FUACT FUACT HVT ICF_WITH IE IE INDTX INDTX INF_CONSENT INF_CONSENT LBIOPSY_CR LBIOPSY_CR_1 LB_CHEM
LB_COAG LB_HEMA LB_LIPID LB_URIN LEREPORT_CR LEREPORT_CR LIMAGING_CR MEDHIST_A_LIVER_CR MH NESCREEN NSCLCHIS NSCLCHIS
NSCLCHIS NTM OH PHEM PK_LIVER_PKSMPID PR PR_FCR PR_IMG PV QS RAND RUCAM_CR SAE SI SUBUSE_AL_LIVER_CR SURVSTAT TLSUM TSH
TUNL TUNL TUNT2 TUNT2 TUTG2 TUTG2 UNSCH UPT VS VS_1

Re: Macro : Read values from a macro variable

PaigeMiller — Wed, 18 Aug 2021 15:08:46 GMT

Inside a macro

%do i=1 %to %sysfunc(countw(&list));
    %let thisvar = %scan(&list,&i,%str( ));
    /* Do some action with &thisvar */
%end;

Re: Macro : Read values from a macro variable

Reeza — Wed, 18 Aug 2021 15:17:11 GMT

You may find these helpful:

SAS Macro Examples

Example 1: Import All CSV Files That Exist within a Directory

Example 2: List All Files within a Directory Including Subdirectories

Example 3: How to Increment a Macro DO Loop by a Non-integer Value

Example 4: How to Use Character Values on a Macro %DO Loop

Example 5: Place All SAS Data Set Variables into a Macro Variable

Example 6: How to Retrieve the Program Name That Is Currently Running in Batch Mode or Interactively

Example 7: Using a Macro to Create New Variable Names from Variable Values

Example 8: Dynamically Determine the Number of Observations and Variables in a SAS Data Set

Example 9: Use Macro Logic to Determine If an External File Is Empty

Example 10: Retrieve Each Word from a Macro Variable List

Example 11: Loop through Dates Using a Macro %DO Loop

Example 12: Using Macro Variables within a CARDS or DATALINES Statement

Example 13: Print Information to the Output Window If a Data Set Is Empty

Example 14: Create a Quoted List Separated by Spaces

Example 15: Delete a File If It Exists

Example 16: Retrieve the File Size, Create Time, and Last Modified Date of an External File

Example 17: Delete All User-defined Macro Variables

Re: Macro : Read values from a macro variable

ballardw — Wed, 18 Aug 2021 15:18:13 GMT

I think that you may seriously want to consider just how you are building that list of variables and what you expect to do with it. You have repeats of the same value such as

CVEVT_ARRH_CR CVEVT_ARRH_CR CVEVT_ARRH_CR CVEVT_ARRH_CR CVEVT_ARRH_CR CVEVT_ARRH_CR

which means that you will likely repeat the same thing 5 times for that value. Which means a likely waste of clock cycles.

There are several of these repeated values, so even more wasted clock cycles.

OR you are going to have to provide more information somewhere if each of those repeats is to be treated differently. Which means that @PaigeMiller's concise solution may be insufficient in the real task.