jim.groeneveld@hccnet.nl wrote: > Hi Rajesh, > > No, SAS variables only exist in datasets and can be manipulated by a.o.

"a.o." - what's that an abbreviation for?

> the data step (and SQL, and read by PROCs). But you can use macro

And SCL - "Screen Control Language" that got changed to "System Component Language". Don't forget that! Sometimes I need to produce a proc report for every category I have so I write the categories to a dataset and do it the macro way by looping through a dataset for each category in turn like this:

%do i=1 %to %nobs(dset); %let cat=%getvalue(dset,category,&i);

%end;

The %getvalue macro is here: http://www.datasavantconsulting.com/roland/getvalue.sas

> variables throughout the whole code of your SAS (and macro) program. > Start studying macro language (if you are up to that) from your SAS > documentation (on the web). > > Regards - Jim. > -- > Jim Groeneveld, Netherlands > Statistician, SAS consultant > home.hccnet.nl/jim.groeneveld > > [common disclaimer] > > > > "Rajesh" <Rajesh.vishwanath@gmail.com> wrote: > >HI All, > > > >Please me help me out. > >Can i use sas variable inside macro.Can you guide me on this. > >If there is links on the same please forward me. > > > >Thanks, > >