Interested to Buy Any Domain ? << Click Here >> for more details...
if you have 365 no of data set and each one having different
variable from each other. how will you read by creating
macros and create a single data set.
- 2 Answers
- 6735 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manoj mishra
Make a library where all data set resides. Use proc contect
and out option to create a data of proc contect from where
we get all data set name. Create Macro using Call Symput for
each dataset name into separate macro variable. We can not
merge them as they dont have common variable. We need set or
Append or SQL to merge them together.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / singh.naveen409
%macro naveen(xx,n);
data www;
merge
%do i=1 %to &n;
&xx&i
%end;
;
run;
%mend naveen;
%naveen (qq,2);
| Is This Answer Correct ? | 1 Yes | 10 No |
what is the difference between unique key and primary key? : Sas-di
How necessary is it to be creative in your work?
in data set200 observation how to take 110,150,170 using sql procedure?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
what is validvarname and varnum? why we are using this options; explain with a syntax for this options?
What is the role of unrestrictive users? : sas-grid-administration
What is the difference between SAS Data step and SAS PROC SQL, and which is better?
i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
what is the basic structure sas administrator? : Sas-administrator
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.
How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
Teradata 
