Store variable values in a list

[NewUsrStat]

Hi guys,

I have a variable that takes different values (char).

In a code written to perform some calculations, the if-then-else loop is used different times to execute operations.

In all if-then-else loops, only variable values in ("the reference date", "the hospitalization date", "the hospitalization status", "the relapse") are considered and not the remaining ones. Is there a way to put those values in a variable so that it is not necessary to specify every time the list of values that should be considered?

I mean something like this: %let varlist= .... but in my case I have not variables but values of a variable. 

Thank you in advance

[yabwon · Accepted solution]

Do you mean something like this:

%let myList=("the reference date", "the hospitalization date", "the hospitalization status", "the relapse");

data _null_;
  do x = "the reference date", "the noref date";
    if x IN &myList. then put "A"; else put "B";
  end;
run;

Bart

[Kathryn_SAS]

You could use PROC SQL similar to the following:

146  proc sql noprint;
147   select name into :val_list separated by ','
148   from sashelp.class;
149  quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.05 seconds
      cpu time            0.00 seconds


150  %put &val_list;
Alfred,Alice,Barbara,Carol,Henry,James,Jane,Janet,Jeffrey,John,Joyce,Judy,Louise,Mary,Philip,Robert,Ro
nald,Thomas,William