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
- 6833 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 |
How would you identify a macro variable? : sas-macro
create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;
Identify statements whose placement in the DATA step is critical.
What SAS statements would you code to read an external raw data file to a DATA step?
How would you include common or reuse to be processed along with your statements?
What is difference between (a-z) and (a--z)
what is the difference between proc means and proc tabulate?
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
Mention sas system options to debug sas macros.
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
What is data _null_?
What does PROC print, and PROC contents do?
Teradata 
