How to use PUT function in dynamic variables (based on row number)

[Rian0126]

Hi,

I have a table (Accounts) for example:

Account_Number    Name       Birthdate

01                          Mark         January 23, 1988

02                          Ely            March 15, 1956

03                          Omar        June 16, 1987

The table is dynamically changing from the source data; thus, I need to put them as a macro variable in a loop. 

Now, I need to add them on a csv file. I'm trying to use PUT function with a macrovariable in a loop (for example: PUT &Name.i) where is starts from 1 in a loop. How can I print them (or PUT function) on a csv file depending on the row number in a loop? Thanks.

[andreas_lds]

I don't see any reason to hold data in macro-variables. Please explain what you expect as result using the data you have shown.

[Rian0126 · Accepted solution]

Hi @andreas_lds , it's OK now. I found a solution by using another table as reference. I was just thinking of using macro-variables to fetch data when needed and put it on a csv file for report. Somewhat like a header for a repeated data (same person) with further details (different further details like bank transaction for several times). Thanks anyway. 🙂