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
- 6756 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 do you feel about hardcoding?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
How would you remove a format that has been permanently associated with a variables?
how do you pull data from equifax?tell me the process?
0 Answers Synchrony Financial,
how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?
Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation
Diff between proc sql merge and join?
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
how many types of prompts are there? : Sas-bi
Differentiate between proc means and proc summary.
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
What is highest missing value for numeric?
Teradata 
