PROC CONTENTS DATA=SASHELP.CLASS OUT=T VARNUM; RUN; PROC SQL NOPRINT;

How will you assign all the variables of an dataset into a
macro variable separated by a space? For example if a
dataset has variables A,B,C. Assign them to a macro variable
X as
X=A B C

Question Posted / somanath

3 Answers
10859 Views
Accenture, Oracle, I also Faced
E-Mail Answers

Answer Posted / somanath

PROC CONTENTS DATA=SASHELP.CLASS OUT=T VARNUM;
RUN;

PROC SQL NOPRINT;
SELECT NAME INTO : Y separated BY ' ' FROM T ;
QUIT;

%put &Y;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is maximum storage capability of SAS?

1428

Can you execute a macro within a macro? Describe. : sas-macro

1111

What is factor analysis?

1140

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1050

Explain the use of proc print and proc contents?

965

In sas admin differentiate between roles and capabilities? : sas-grid-administration

1003

what is sas and what are the functions? : Sas-administrator

992

What does the trace option do?

1114

what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

1035

How substr function works in sas?

1225

What is the maximum length of the macro variable?

1182

what versions of sas have you used (on which platforms)? : Sas programming

1073

What is the sas data set? : sas-grid-administration

985

What is the difference between the proc sql and data step?

1181

What is the purpose of trailing @ and @@? How do you use them?

1041