One way of creating a new variable in Macros is by %
Let....What is the other way..?
- 5 Answers
- 9726 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prem krishnan
1) %macro <macroname> ( );
%mend (<macroname>;
a DATA step that contains a SYMPUT routine within a macro
definition
a DATA step that contains a SYMPUTX routine within a macro
definition
a SELECT statement that contains an INTO clause in PROC SQL
within a macro
definition
a %LOCAL statement.
%global statement
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / satyanand
•A %LET statement (used outside a macro definition)
•A DATA step that contains a SYMPUT routine
•A DATA step that contains a SYMPUTX routine (beginning in
SAS 9)
•A SELECT statement that contains an INTO clause in PROC SQL
•A %GLOBAL statement.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / aruna
Use Callsymput(<variable>, <Value>) for version lessthan
SAS9
Use Callsymputx(<variable>, <Value>) for SAS9
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / xxx
%Global;
%Local;
%let;
call symput in datastep;
into clause in proc sql;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / lavanya
In addition to the %LET statement, other features of the macro language that create macro variables are
iterative %DO statement
%GLOBAL statement
%INPUT statement
INTO clause of the SELECT statement in SQL
%LOCAL statement
%MACRO statement
SYMPUT routine and SYMPUTN routine in SCL
%WINDOW statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
where are dashboard components are created and maintained? : Sas-bi
What data sets do you need to produce the report?
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
for whom is sas data integration studio designed? : Sas-di
What are the statements in proc sql?
How can I remove header from output data set?
What is difference between N and n????
At compile time when a SAS data set is read, what items are created?
How do dates work in SAS data?
what is picture format? give any one example?
what is the need of INDEX in datasets?
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
Teradata 
