topic Re: Copy Previous rows Multiple times in SAS in SAS Programming

Copy Previous rows Multiple times in SAS

Bhavanaa — Tue, 04 Sep 2018 15:51:23 GMT

Hi,

I have a data in which i have to copy value into rows.

ex:

Site Subject Visit_Name

Abc Hospital A101 Screening

Visit1

Visit2

Visit3

AIIMS C102 Screening

Visit1

Visit2

Visit3

So i want to fill the row wise.

i have tried with macro.

but i am unable to understand.

%macro fillin;

%do i = 1 %to 5;

data two; set two;

temp =lag(Site_Id);

if temp NE " " and Site_Id = " " then Site_Id = temp;

run;

%end;

%mend fillin;

%fillin;

Here " %do i = 1 %to 5;" .

i don't want to specify 5 as number as that is not defined.

how to put %do syntax so that it will fill same value till it finds next one.

Thanks in advance.\

Regards,

Re: Copy Previous rows Multiple times in SAS

HB — Tue, 04 Sep 2018 16:52:18 GMT

SAS is not a spreadsheet.

What are you really wanting to do?

A data structure like:

site- values abc, aimms

subject- values A101, C102

visit_type- values screening, regular, special

visit_date - date mm/dd/yyyy

Would allow you to determine "first" visit by date.

Perhaps you could provide more info, some sample data, and/or a sample of the type of query or result you hope to run against or get from the data.

Re: Copy Previous rows Multiple times in SAS

Astounding — Tue, 04 Sep 2018 18:22:12 GMT

To some extent, I'm guessing at what you are trying to achieve Here's a program you can experiment with:

data halfway;

set have;

if site > ' ' then group + 1;

run;

data want;

update halfway (obs=0) halfway;

by group;

output;

drop group;

run;

If you are concerned ONLY with the variable SITE, we might be able to adjust this. But let's start here and see if this version does what you want.

Re: Copy Previous rows Multiple times in SAS

Bhavanaa — Wed, 05 Sep 2018 01:57:38 GMT

Hi,

Please find the excel sheet attached.

i want to fill down the above row values till it is blank.

hope you understood what i am saying.

Kindly help me.

Regards,

Re: Copy Previous rows Multiple times in SAS

Astounding — Wed, 05 Sep 2018 02:12:56 GMT

Did you actually try running the program I posted?

If you did, how were the results? Exactly what you wanted? Close to what you wanted?

Re: Copy Previous rows Multiple times in SAS

Bhavanaa — Wed, 05 Sep 2018 09:02:29 GMT

I have SAS in VM and it's opening very slow. So i am unable to run it.

else i would have check this.

Regards,

Re: Copy Previous rows Multiple times in SAS

HB — Wed, 05 Sep 2018 17:01:53 GMT

Please find the excel sheet attached.

Yes. As noted, SAS is not a spreadsheet.

Again, what are you really wanting to do?

Perhaps you could provide more info, some sample data, and/or a sample of the type of query or result you hope to run against or get from the data.