topic Re: What's wrong with the variable input in a macro in SAS Programming

What's wrong with the variable input in a macro

bbb_NG — Wed, 06 Jun 2012 08:59:31 GMT

%macro makeVarMap(dsact);

proc transpose data=&dsform out=tempform (keep =_name_);

var c1--no;

run;

%mend;

%macro makeVarMap(thesis.sb_v_12);

doesn't work while following codes works

proc transpose data=thesis.sb_v_12 out=tempform (keep =_name_);

var c1--no;

run;

thesis.sb_v_12 has several variables like c1,c2,c3,n1,n2,n3 and end with no.

and the error codes seems point to the irregular format of dataset name :thesis.sb_v_12,but this kind of naming method works with my

other macros.

Can anyone give a thought?

Thanks.

Re: What's wrong with the variable input in a macro

Ksharp — Wed, 06 Jun 2012 09:02:58 GMT

I noticed a problem.

%macro makeVarMap(dsact);

proc transpose data=&dsform out=tempform (keep =_name_);

var c1--no;

run;

%mend;

They are diferent.

Ksharp

Re: What's wrong with the variable input in a macro

bbb_NG — Wed, 06 Jun 2012 09:09:22 GMT

Ksharp,

Thank u very much.I made a silly mistake.

Re: What's wrong with the variable input in a macro

ChrisNZ — Tue, 12 Jun 2012 02:51:07 GMT

Please give credit by clicking "correct answer", it is the least you can do to acknowledge the time and effort people spend helping you.

Re: What's wrong with the variable input in a macro

bbb_NG — Tue, 12 Jun 2012 03:01:22 GMT

Chris,

I know I should acknowledge those who have given help.

Ｉ put on a snapshot here to show that there's no correct answer button here.

the 3 clicks below translating into english is "diversity,like, reply"

Re: What's wrong with the variable input in a macro

ChrisNZ — Tue, 12 Jun 2012 05:55:40 GMT

Good on you for trying.

That's odd, you should also have a yellow star and a green one if you are logged in.

"Diversity" is "Branch" in the english version.

Re: What's wrong with the variable input in a macro

bbb_NG — Tue, 12 Jun 2012 06:00:42 GMT

Chris,

Thanks for your reminding.I'm so appreciated with other's patient help and always bearing in mind to click on those "correct answer" if have.

I am logging on, maybe it's due to my location?

It happend some times.

And now the correct answer appears.

Confused.

Dawn.