proc contents data= dsname out=o/pdsname; run; proc sql; select name in

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 / raghu kishor. k

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

Answer Posted / raghu kishor. k

proc contents data= dsname out=o/pdsname;
run;

proc sql; select name into: macrovariablename separated
by ' 'from o/pdsname;
quit;

Is This Answer Correct ?

12 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

938

what is program data vector? : Sas-administrator

1020

Do you need to rearrange the order of the data for the report?

2268

What are the data types does SAS contain?

1063

What is the use of function Proc summary?

1231

Give some ways by which you can define the variables to produce the summary report (using proc report)?

1045

What are the difference between ceil and floor functions in sas?

1291

Enlist the syntax rules followed in sas statements.

1043

How to test the debugging in sas?

1126

Mention the category in which sas informats are placed?

984

For clinical entire study how many tables will create approx?

1921

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1112

what are several options for creating reports in web report studio? : Sas-bi

1094

Mention the difference between ceil and floor functions in sas?

1113

it will become easy if uuu provide website linkssss and list of consultanciessssss

1930