Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

Answers were Sorted based on User's Feedback



if you have 365 no of data set and each one having different variable from each other. how will you..

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

if you have 365 no of data set and each one having different variable from each other. how will you..

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

Post New Answer

More SAS Interview Questions

how many data types in sas? : Sas-administrator

1 Answers  


What are the efficacy variables in your study?

2 Answers   Accenture, Quintiles,


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;

0 Answers   L&T,


how to display duplicated observations in a data using base sas.

13 Answers   HCL, TCS,


how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

0 Answers  


What are the difference between ceil and floor functions in sas?

0 Answers  


What is SAS informats?

0 Answers  


What is the difference between INPUT and INFILE ?

0 Answers  


What is the general format of function in sas? : sas-grid-administration

0 Answers  


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

0 Answers  


Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

0 Answers  


what does .. meant in sas macros

3 Answers   D&B,


Categories