how to read multiple variable from multiple datasets like 200 variables from 100 datasets?

[Reeza]

You still need to post more details...

[mssh2712]

Can you plz give me an example?

[Reeza]

What are are you trying to do? What do you have for starter, text files, sas datasets, SQL DB? What do you mean by read variables? What do you need as output? 

Here are some guidelines on asking good questions

http://stackoverflow.com/help/how-to-ask

https://communities.sas.com/t5/SAS-Communities-Library/How-to-ask-a-question-in-SAS-Analytics-U-Comm...

[mssh2712]

Sorry , i don't know about this.. this is an interview question people have asked me. Im struggling as well like you.

[Reeza]

That was the question? Word for word? 

How familiar are you with SAS? 

[mssh2712]

as in SAS datasets... it can be any type of variables.

[Patrick]

That's a too generic and unspecified question to just give a straight answer.

Such a question in an interview situation provides you with the opportunity to demonstrate your analytical approach to requirement analysis and to showcase your understanding of SAS by asking back the right questions to get to the necessary level of detail for an answer.

It's in this regard a really good interview question as you need actual experience and knowledge to deal with it.

[Reeza]

Last set of interviews I did, they received a technical take home exam, and I asked a question I thought was totally clear. 

Of the 6 candidates - one candidate realized it was ambiguous and asked clarifying questions. That's the one I hired. 

3 others interpreted it one way and 2 the other way. 

[LinusH]

Interview questions? Sigh...
C'mon, learn SAS the proper way, and then you can attend interviews with confidence. Just learning by answering some random question will not get you to understand SAS and be pruductive. Also, can you predict what question that will be asked?

[Ksharp · Accepted solution]

1) IML code.
2) Write a macro and CALL EXECUTE:

%macro xx(dsn=);
  proc print data=&dsn;
   var variables-list ;
 run;
%mend;

data _null_;
 set sashelp.members(where=(libname='WORK'));
call execute('%xx(dsn=work.'||memname||')');
run;

[Ksharp]

1) IML code.
2) Write a macro and CALL EXECUTE:

%macro xx(dsn=);
  proc print data=&dsn;
   var variables-list ;
 run;
%mend;

data _null_;
 set sashelp.members(where=(libname='WORK'));
call execute('%xx(dsn=work.'||memname||')');
run;