topic Re: Required output for macro in SAS Programming

Required output for macro

deleted_user — Thu, 04 Dec 2008 09:20:27 GMT

hi i have one query
%let a=23;
%let b=45;
%let C=89;

so now i need the output
x
-------------
a
b
c

where x is the variable..

abd a, b and c variable names should present in single column as shown above

Re: Required output for macro

yonib — Thu, 04 Dec 2008 09:34:43 GMT

If you have only 3 macro parameters you can do :

options symbolgen;
%let a=23;
%let b=45;
%let C=89;
data a;
x=&a;
output;
x=&b;
output;
x=&c;
output;
run;

Re: Required output for macro

Patrick — Thu, 04 Dec 2008 09:39:23 GMT

Not sure what you're after but you can always query dictionary.macros (or sashelp.vmacro).
http://www.codecraftersinc.com/pdf/DictionaryTablesRefCard.pdf

HTH
Patrick

Re: Required output for macro

Patrick — Thu, 04 Dec 2008 09:43:17 GMT

Hi yonib
As I understand it sas@kumar asked for the names of the macro vars and not their values.
Cheers, Patrick

Re: Required output for macro

deleted_user — Thu, 04 Dec 2008 09:45:31 GMT

hi ............i dont require the values of that variables ..........i need the variable names itself

Re: Required output for macro

yonib — Thu, 04 Dec 2008 10:11:20 GMT

Yes Patrick ,my bad
Soo the query dictionary.macros will do job......

Re: Required output for macro

deleted_user — Thu, 04 Dec 2008 10:25:38 GMT

yes patrick............u r right.........can u help me with example?

Re: Required output for macro

Patrick — Thu, 04 Dec 2008 10:47:04 GMT

proc sql;
select *
from dictionary.macros;
quit;

OR:
proc print data=sashelp.vsmacro;
run;

And to get what you asked for:

proc sql;
create table MyTable as
select name as x
from dictionary.macros;
quit;

OR:
data MyTable;
set sashelp.vsmacro(keep=name);
rename name=x;
run;

Have a look at the link I've sent already: There you see the names and description of the fields in the dictionary table. sashelp.vsmacro is a view on dictionary.macros. Using PC SAS or SAS EG you can also browse sashelp.vsmacro

HTH
Patrick

Re: Required output for macro

deleted_user — Thu, 04 Dec 2008 11:33:44 GMT

hi patrick,

data test1;
input id y x1 x2 x3;
cards;
01 1 13 14 15
02 1 33 44 55
03 0 44 55 66
04 1 55 66 77
05 0 66 77 88
06 0 77 88 99
07 1 88 99 11
08 1 22 33 44
09 0 32 43 54
10 0 22 33 44
11 1 32 43 54
;
run;

this is my data set, now my output should be in the form of data set shown below:

x
-----------
y
x1
x2
x3

so what is the syntax?

thanks]

kumar

Re: Required output for macro

LinusH — Thu, 04 Dec 2008 14:22:06 GMT

Do you want to putput the name of your columns?
PROC CONTENTS or PROC DATASETS may be used for that.

I also suggest that take a couple of training classes, since most of your questions concern basic programming concepts in SAS.

Regards,
Linus