Can anyone help me read values within a variable from a SAS data set one at a time and use it in a macro variable for processing?   Table: PRIORITY     ELEMENT         high               commodity high               date high               state . . .   Using SAS 9.4, I need to pull the first value for ELEMENT and store it as a macro variable and use it for processing.  Once the process is complete I need to move to the next value and repeat the process, then the next value, etc. until the end of file.   Any help is much appreciated.  Thank you!  ... View more

Hello,   I am trying to create a process that would select records from a table until a field is flagged, then skip to the next customer;   OBS     FLAG     Customer   1            0           11111   2            0           11111   3            1           11111   4            0           11111   5            0           22222   6            0           22222   7            1           22222   8            0           22222   9            0           22222  10           1           33333  11           0           33333   In this sample it would pull observations 1,2,3,5,6,7,and 10.  After the flag is equal to 1, I would like it to go to the next customer. Is there a do loop that would complete this action? ... View more

Does anyone know how to use a prompted value to select an existing table in a SAS program using EG.  In the example below I am trying to create a table from the values in the table fact_qtr1_year2015.  Can a prompted value be used in a table name. Example: Proc SQL;      Create table work.example as      select    company,                portfolio,                balance      From libname.Fact_qtr(prompted value)_year(prompted value) Quit; run;     ... View more