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
- 5893 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 interleaving in SAS?
what other sas products have you used and consider yourself proficient in using? : Sas programming
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
How many tiers in sas architecture?
Give some ways by which you can define the variables to produce the summary report (using proc report)?
What are the default statistics that proc means produce?
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
what are input dataset and output dataset options?
i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What can be the size of largest dataset in SAS?
Teradata 
