topic Re: how to read multiple variable from multiple datasets like 200 variables from 100 datasets? in SAS Programming

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

mssh2712 — Sun, 20 Nov 2016 14:56:34 GMT

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

Reeza — Sun, 20 Nov 2016 15:02:40 GMT

You still need to post more details...

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

mssh2712 — Sun, 20 Nov 2016 15:05:25 GMT

Can you plz give me an example?

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

Reeza — Sun, 20 Nov 2016 15:09:24 GMT

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-Communities/ta-p/221163

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

mssh2712 — Sun, 20 Nov 2016 15:11:29 GMT

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

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

mssh2712 — Sun, 20 Nov 2016 15:12:40 GMT

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

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

LinusH — Sun, 20 Nov 2016 15:17:02 GMT

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?

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

Reeza — Sun, 20 Nov 2016 15:23:22 GMT

That was the question? Word for word?

How familiar are you with SAS?

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

Patrick — Sun, 20 Nov 2016 23:35:29 GMT

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.

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

Reeza — Mon, 21 Nov 2016 00:34:34 GMT

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.

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

Ksharp — Mon, 21 Nov 2016 10:01:59 GMT

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;

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

Ksharp — Mon, 21 Nov 2016 10:05:56 GMT

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;