topic Re: How to write macro to extract first obs from particular library in SAS Procedures

How to write macro to extract first obs from particular library

Ravikumarpa4 — Tue, 04 Oct 2016 05:12:29 GMT

Hi how to write a macro to extract first obs from library which is shorted by crdate if first obs is blank then its need to extract second obs so on... Kindly help me

Re: How to write macro to extract first obs from particular library

Reeza — Tue, 04 Oct 2016 05:59:35 GMT

When you need to write a macro you first need working code and then you convert it.

Do you have working code that needs to be turned into a macro? And since this is a trivial task why do you need a macro? Which parts are dynamic in nature. Please be more explicit in your questions.

Re: How to write macro to extract first obs from particular library

Ravikumarpa4 — Tue, 04 Oct 2016 06:25:33 GMT

Hi

Yes I've working code, whenever I run the working code it'll generate new
dataset here I need only that dataset some times if data is not available
old dataset will be there. So I need write a macro so that it can extractt
first obs dataset.

Thanks and Regards
Ravikumar

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: How to write macro to extract first obs from particular library

Kurt_Bremser — Tue, 04 Oct 2016 07:28:54 GMT

Post the code and describe which part of it should be parameterized.

Re: How to write macro to extract first obs from particular library

RW9 — Tue, 04 Oct 2016 08:26:22 GMT

Post code, and examples to clarify the question. As for your problem, why do you need a macro?

/* Test data */
proc sql;
  create table a (a char(2));
quit;
data b;
  b=1;
run;

/* This is the code */
proc sort data=sashelp.vtable out=inter;
  by memname;
  where libname="WORK" and nobs > 0;
run;
data _null_;
  set inter (obs=1);
  call execute(cats('data want; set work.',memname,' (obs=1); run;'));
run;

Re: How to write macro to extract first obs from particular library

Kurt_Bremser — Tue, 04 Oct 2016 08:55:15 GMT

@Ravikumarpa4 wrote:
Hi how to write a macro to extract first obs from library which is shorted by crdate if first obs is blank then its need to extract second obs so on... Kindly help me

Libraries have datasets, and datasets have observations. Libraries do not have observations.

Re: How to write macro to extract first obs from particular library

Ravikumarpa4 — Wed, 05 Oct 2016 05:43:45 GMT

Hi
Code which I wrote is
Proc sql;
Create table abc as
Select * from
Dictionary.tables
Where libname= 'common'
Order by crdate desc;
Quit;

When I'm running above code its shows all the datasets in that library but
I want only one data set which is created most recently by writing macro.
Thanks

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: How to write macro to extract first obs from particular library

Kurt_Bremser — Wed, 05 Oct 2016 05:54:38 GMT

Use the having clause and the max() summary function in SQL:

proc sql;
select * from dictionary.tables
where libname = 'common'
having crdate = max(crdate);
quit;

Re: How to write macro to extract first obs from particular library

Ravikumarpa4 — Wed, 05 Oct 2016 07:50:33 GMT

Hi

Now coding is working fine but I need assign macro how to do that,?

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: How to write macro to extract first obs from particular library

Kurt_Bremser — Wed, 05 Oct 2016 08:22:26 GMT

Which parts of the code need to be parameterized?

Re: How to write macro to extract first obs from particular library

Ravikumarpa4 — Wed, 05 Oct 2016 09:00:33 GMT

Hi

crdate part

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: How to write macro to extract first obs from particular library

Kurt_Bremser — Wed, 05 Oct 2016 09:04:40 GMT

Do you want to change the variable that's used, or do you want to compare with a specific value?

Re: How to write macro to extract first obs from particular library

Ravikumarpa4 — Wed, 05 Oct 2016 09:07:33 GMT

Hi
variable will be same but value will change

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: How to write macro to extract first obs from particular library

Reeza — Wed, 05 Oct 2016 09:14:07 GMT

But the max crdate is always used. If the variable name doesn't change that doesn't need to be parametrized.

Post a few different versions of what the code would be for us to understand what you need a macro for.

Re: How to write macro to extract first obs from particular library

Ravikumarpa4 — Wed, 05 Oct 2016 10:21:33 GMT

Hi

Now I need to assign macro to 'memname' variable then how can I do.

Thanks

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: How to write macro to extract first obs from particular library

Kurt_Bremser — Wed, 05 Oct 2016 10:49:17 GMT

%macro your_macro_name(memname);

*here comes your code;
*example;
where memname = "&memname";

*further code;
%mend;