About amitsas

amitsas · ‎03-19-2012

Sorry for my ignorance, and thank you again!

amitsas · ‎03-19-2012

I just ran your macro without making any changes. But if you open the dataset, the value inside is C and not CA

amitsas · ‎03-19-2012

Thanks a lot! This works. This is very similar to how I did it originally. The only change needed is probably in the %scan function. Right now it is only using the C from CA (and N from NY etc) fwhen resolving %let value=%scan(&values,&i);, while it needs to use the whole CA.I can probably take care of that.

amitsas · ‎03-19-2012

This is not a homework. I haven't used SAS in a while. I have a list of close to 2000 values for which I have retrieve some data. And I do not want to run the code 2000 times, based on each value. From what i remember when I did do it, I used a long character string as a macro variable, and resolved the value by moving the do loop counter by 1 and then ran the code.

amitsas · ‎03-19-2012

Hi, I am hoping someone can help with request. I need to create (say) 5 tables or data sets, for 5 states - CA, VA, NY, TX and OK Each table has some information based on some criteria (say, name of state and its population). So the table for California looks like CA 34,000,000 I can have a data step to do this, but I want to put the names of states in a marco variable string along with a do loop so that the do loop runs and creates a data step for each state in the macro variable string, for example %LET STATE = CA VA NY TX OK; do loop (CA) followed by do loop VA etc.. Thanks to all who try to help.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Need help with creating a do loop

Need help with creating a do loop

Need help with creating a do loop

Need help with creating a do loop

Need help with creating a do loop

Need help with creating a do loop

Need help with creating a do loop

Need help with creating a do loop

Need help with creating a do loop

Need help with creating a do loop