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
10683 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 has been your most common programming mistake? : Sas programming

1030

Explain the main difference between the sas procedures and functions? : Sas-administrator

1012

how sas deals with business intelligence? : Sas-bi

998

How you can read the variables that you need?

1068

I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1699

Mention the validation tools used in SAS?

1104

how does sas handle missing values in functions? : Sas programming

1121

What is factor analysis?

1077

What is proc sort?

1134

Explain the difference between informat and format with an example.

1113

How do you connect the desktop application to metadata server? : sas-grid-administration

1029

What sas features do you use to check errors and data validation?

1160

what are some differences between proc summary and proc means? : Sas programming

1042

What do the SAS log messages "numeric values have been converted to character" mean?

1326

For what purpose would you use the RETAIN statement?

1464