how to fill the missing data in the succeeding rows ?

srikanthyadav44 — Fri, 23 Oct 2020 12:26:06 GMT

dear all,

i have the data of the companies and their directors. in the below format

Company Name	Director Name
20 Microns Ltd.	CHANDRESH PARIKH
	RAJESH PARIKH
	ATIL C PARIKH
	SEJAL R PARIKH (MRS.)
	P M SHAH
	R A DEVIDAYAL
	ATUL H PATEL
	AJAY I RANKA (DR.)
	JAIDEEP VERMA
3I Infotech Ltd.	ASHOK SHAH
	SAROJINI DIKHALE (MS.)
	SHASHANK DESAI (DR.)
	GAUTAM DUTTA
	SHANTI LAL JAIN
	ANJOO NAVALKAR
	AVAYA KUMAR MOHAPATRA
	RAJEEV KUMAR SINHA
	PADMANABHAN IYER
3M India Ltd.	BHARAT D SHAH
	BIREN GABHAWALA
	RADHIKA RAJAN
	DEBARATI SEN
	B V SHANKARANARAYANA RAO
	ALBERT C WANG
	AMIT LAROYA
	RAMESH RAMADURAI
	JONG HO LEE
	SADHANA KAUL
3P Land Holdings Ltd.	G N JAJODIYA
	VASUDHA JATIA (MS.)
	R C SARAF
	A K SOMANY
	BHAVANISINGH SHEKHAWAT

in the above format, i have to fill the blank rows in the company name column with the company in the preceding row. as follows

Company Name	Director Name
20 Microns Ltd.	CHANDRESH PARIKH
21 Microns Ltd.	RAJESH PARIKH
22 Microns Ltd.	ATIL C PARIKH
23 Microns Ltd.	SEJAL R PARIKH (MRS.)
24 Microns Ltd.	P M SHAH
25 Microns Ltd.	R A DEVIDAYAL
26 Microns Ltd.	ATUL H PATEL
27 Microns Ltd.	AJAY I RANKA (DR.)
28 Microns Ltd.	JAIDEEP VERMA
3I Infotech Ltd.	ASHOK SHAH
3I Infotech Ltd.	SAROJINI DIKHALE (MS.)
3I Infotech Ltd.	SHASHANK DESAI (DR.)
3I Infotech Ltd.	GAUTAM DUTTA
3I Infotech Ltd.	SHANTI LAL JAIN
3I Infotech Ltd.	ANJOO NAVALKAR
3I Infotech Ltd.	AVAYA KUMAR MOHAPATRA
3I Infotech Ltd.	RAJEEV KUMAR SINHA
3I Infotech Ltd.	PADMANABHAN IYER
3M India Ltd.	BHARAT D SHAH
3M India Ltd.	BIREN GABHAWALA
3M India Ltd.	RADHIKA RAJAN
3M India Ltd.	DEBARATI SEN
3M India Ltd.	B V SHANKARANARAYANA RAO
3M India Ltd.	ALBERT C WANG
3M India Ltd.	AMIT LAROYA
3M India Ltd.	RAMESH RAMADURAI
3M India Ltd.	JONG HO LEE
3M India Ltd.	SADHANA KAUL
3P Land Holdings Ltd.	G N JAJODIYA
3P Land Holdings Ltd.	VASUDHA JATIA (MS.)
3P Land Holdings Ltd.	R C SARAF
3P Land Holdings Ltd.	A K SOMANY
3P Land Holdings Ltd.	BHAVANISINGH SHEKHAWAT

please suggest me a suitable SAS code

thanks in advance

Re: how to fill the missing data in the succeeding rows ?

novinosrin — Fri, 23 Oct 2020 13:45:40 GMT

data want;
 set have;
 retain _t;
 if missing(Company_name) then Company_name=_t;
 else _t=Company_name;
 drop _t;
run;

Re: how to fill the missing data in the succeeding rows ?

ballardw — Fri, 23 Oct 2020 14:05:50 GMT

I think you likely should go back to how you created your "want" data and fix the almost-certainly-done-incorrectly by Excel incrementing of the "20 Microns" to "21 Microns" "22 Microns" etc.

Never trust Excel for dragging values if there is a number-like value as part of text. Never.

I had a project where someone did this to a designed sample file and created 200 more school identifiers than existed in the region.

Re: how to fill the missing data in the succeeding rows ?

srikanthyadav44 — Sat, 24 Oct 2020 08:47:22 GMT

thanks . the SAS code is working excellently

topic Re: how to fill the missing data in the succeeding rows ? in SAS Programming

how to fill the missing data in the succeeding rows ?

Re: how to fill the missing data in the succeeding rows ?

Re: how to fill the missing data in the succeeding rows ?

Re: how to fill the missing data in the succeeding rows ?