topic Re: How to use PUT function in dynamic variables (based on row number) in SAS Programming

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

Rian0126 — Mon, 05 Jul 2021 09:26:54 GMT

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.

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

andreas_lds — Mon, 05 Jul 2021 10:48:47 GMT

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.

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

Rian0126 — Tue, 06 Jul 2021 01:01:32 GMT

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. 🙂