Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how we can call macros with in data step?

Answers were Sorted based on User's Feedback



how we can call macros with in data step?..

Answer / name is no need

oh....use less felows don't give this much answers how can
a person knows which one is the correct answer,i can see
here more wrong answers than correct answers.i suggest some
of the people who don't know the exact answer better don't
post stupid answers ,why because the persons who are facing
the interview they are in learning stage they can't
differentiate the answers.

Is This Answer Correct ?    19 Yes 0 No

how we can call macros with in data step?..

Answer / syam

using call excute

Is This Answer Correct ?    10 Yes 1 No

how we can call macros with in data step?..

Answer / learner

We have to use call execute to call a macro. For other
answers
1 &(amperson) is used to resolve the macrovariable and not
call macro .
2 Call symput is to define a macro variable dynamical in
data step. useful in data driven programs.

3 symget is to get the macro variable from symbol table and
not call a macro.

Hope it will help..would recomand to double check before
post ..al the best

Is This Answer Correct ?    11 Yes 2 No

how we can call macros with in data step?..

Answer / xyz

oh....use less felows don't give this much answers how can
a person knows which one is the correct answer,i can see
here more wrong answers than correct answers.i suggest some
of the people who don't know the exact answer better don't
post stupid answers ,why because the persons who are facing
the interview they are in learning stage they can't
differentiate the answers.

Is This Answer Correct ?    6 Yes 0 No

how we can call macros with in data step?..

Answer / selvi

We can call macro in a dataset by preceding % with macro
name.

call symput - used to create macro variable in data step.

symget - used to assign value of macro variable to data
step variable.

Is This Answer Correct ?    5 Yes 1 No

how we can call macros with in data step?..

Answer / sr

call execute and also %macro both used

Is This Answer Correct ?    1 Yes 0 No

how we can call macros with in data step?..

Answer / pambrose

here is the answer with self explaining code... picked from SAS book

data prices; /* ID for price category and actual price */
input code amount;
datalines;
56 300
99 10000
24 225
;

data names; /* name of sales department and item sold */
input dept $ item $;
cards;
BB Boat
SK Ski
;
%macro items(codevar=); /* create macro variable if needed */
%global special;
data _null_;
set names;
if &codevar=99 and dept='BB' then
call symput('special', item);
run;
%mend items;

data _null_; /* call the macro in this step */
set prices;
if amount > 500 then
call execute('%items(codevar=' || code || ')' );
run;

data sales; /* use the value created by the macro in this step */
set prices;
length saleitem $ 20;
saleitem="&special";
run;

Is This Answer Correct ?    1 Yes 0 No

how we can call macros with in data step?..

Answer / kumaraswamy maduri

Answer 10 is perfect i.e use Call execute to compile and
execute a macro with in a data step.

Is This Answer Correct ?    0 Yes 0 No

how we can call macros with in data step?..

Answer / net_ameen

Call Execute() is used to call Macro aswellas call macro variable eg: Call execute ('%macroname');
Call execute ('&macrovarname');

Call Symput() is used to create a Global macro variable from within a datastep.

Symget() is used to call a macro variable and assign its value to a datastep variable.

%include() is not a macro statement yet used to call either a macro, extn file containing codes or proc/datastep within a program to be executed together.

Resolve() is used to resolve macro variables created thru call symput within same datastep.

Hope this helps. If any argument pls post.

Is This Answer Correct ?    0 Yes 0 No

how we can call macros with in data step?..

Answer / saslearner

syntax:
data _null_;
call execute("%macroname(perameters)");
run;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SAS Interview Questions

Name and describe few sas character functions that are used for data cleaning in brief.

0 Answers  


Do you prefer Proc Report or Proc Tabulate? Why?

9 Answers   Oracle,


what is in stream data in SAS?

1 Answers  


wat has been most common programming mistake?

3 Answers  


what is conditional processing?

4 Answers   Accenture,


what is the use of LRECL option.

1 Answers   L&T,


Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

3 Answers  


In which format does Date stores in sas..? What is the use of DATE in SAS.?

3 Answers   TCS,


I have a dataset concat having variable a b & c. How to rename a b to e & f?

0 Answers  


Mention sas system options to debug sas macros.

0 Answers  


What do you feel about hardcoding?

1 Answers  


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

0 Answers  


Categories