BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
bbb_NG
Fluorite | Level 6

%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.

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

I noticed a problem.

%macro makeVarMap(dsact);

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

var c1--no;

run;

%mend;

They are diferent.

Ksharp

View solution in original post

6 REPLIES 6
Ksharp
Super User

I noticed a problem.

%macro makeVarMap(dsact);

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

var c1--no;

run;

%mend;

They are diferent.

Ksharp

bbb_NG
Fluorite | Level 6

Ksharp,

     Thank u very much.I made a silly mistake.

ChrisNZ
Tourmaline | Level 20

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

bbb_NG
Fluorite | Level 6

snapshot.JPG

Chris,

I know I should acknowledge those who have given help.

I 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"

ChrisNZ
Tourmaline | Level 20

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.


bbb_NG
Fluorite | Level 6

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1913 views
  • 3 likes
  • 3 in conversation