topic Re: proc sql select in SAS Procedures

proc sql select

abdullala — Sun, 31 Jan 2010 15:15:14 GMT

data test;
input grp1 grp2 count cntvarname;
cards
1 1 8 g1_g1
1 2 9 g1_g2
1 3 7 g1_g3
2 1 5 g2_g1
2 2 6 g2_g2
;

How do I assign each of the count values to a macro variable whose name is defined in cntvarname? that is, I want a macro variable g1_g1 has value 8, g1_g2 =9, etc.

proc sql select into: needs a resolved macro variable name. I can not get this work. much appreciate for help!

Re: proc sql select

data_null__ — Sun, 31 Jan 2010 15:23:02 GMT

For this a data step with CALL SYMPUTX would be easier.

However, why do it at all. The data is much more useful in a data set than in macro variables. Once the data are in macro variables that are mostly useless because you have to know their names, and the values are not longer numbers, etc.

Re: proc sql select

sbb — Sun, 31 Jan 2010 17:07:50 GMT

At times, I also find this condition to work best with macro variables, mostly where a SAS variable label (or a TITLEn maybe) requires the contents of an incoming SAS variable to be revealed in a report, instead of occupying a column. One example would be event response metrics data where a variable declares some distribution limit value, like "all responses less than &respval1" when used as an associated metric variable label.

Scott Barry
SBBWorks, Inc.

Re: proc sql select

abdullala — Mon, 01 Feb 2010 00:56:57 GMT

thank you all, I should use call symput. yes, I need all those in macro variables to be called in some other places.