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.
Answer Posted / 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 |
Post New Answer View All Answers
Give some examples where proc report’s defaults are same as proc print’s defaults?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
Describe the function and utility of the most difficult SAS macro that you have written?
What do the PUT and INPUT functions do?
what is snowflake schema? : Sas-di
Differentiate input and infile.
what has been your most common programming mistake? : Sas programming
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
Explain how merging helps to combine data sets.
What are the different versions of sas that you have used until now? : sas-grid-administration
What are the data types that sas contain?
What are the default statistics that proc means produce?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
How would you define the end of a macro? : sas-macro
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation