Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 10964 Views
- Accenture, Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / yuyin
Use PROC SQL; Select * into: macro_variables separated
by ' ' from table;
| Is This Answer Correct ? | 4 Yes | 7 No |
how do u test a pros sql(works or not) without executing it?
Why is SAS considered self-documenting?
What would you change about your job?
here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
How would you delete duplicate observations?
what do the pad and dim functions do? : Sas programming
what is picture format? give any one example?
what is the prob plot in clinical domain
How can sas program be validated?
is there any differnce between proc means and proc summary?
What are the 3 components in sas programming?
which features do you use to check the data validations and errors? : Sas-administrator
Teradata 
