topic plz help in SAS Programming

plz help

deleted_user — Sat, 05 Mar 2011 09:09:41 GMT

how to get the output of this program. I am unable to get output.

data abc;
input pid name $ age race $;
cardsl
101 rakesh kumar 34 asian
102 hari 29 african
;

Re: plz help

Oleg_L — Sat, 05 Mar 2011 09:51:19 GMT

I'm also having a difficulties with your sample data.
The variable name in the first row consists of two parts, but in the second row the second part is missing.
Don't you miss something? Does your actual data as inconsistent as you post it?

[pre]
data abc;
infile cards missover;
input pid fname :$30. sname :$30. age race :$10.;
cards;
101 rakesh kumar 34 asian
102 hari Sname_is_missing 29 african
;
[/pre]

Re: plz help

deleted_user — Sat, 05 Mar 2011 09:56:00 GMT

No missing data is there.I have to display in name column as rakesh kumar and hari without keeping Sname_is_missing.

Re: plz help

Oleg_L — Sat, 05 Mar 2011 10:05:07 GMT

The code below is a solution from this forum poster "Data _null_".

http://support.sas.com/forums/thread.jspa?messageID=51217접

>
http://support.sas.com/forums/thread.jspa?messageID=51217접

[pre]

data a;
retain dlm ' ';
infile cards truncover dsd dlm=dlm;
input @;
end = length(_infile_)+1;
do j = 1 to 2;
end = find(_infile_,dlm,-(end-1));
end;
start = find(_infile_,dlm,1);
length = end-start-1;
input pid :8. name $varying50. length +1 age :8. race :$10.;
keep pid name age race;
cards;
101 rakesh kumar 34 asian
102 hari 29 african
;

[/pre]

Message was edited by: Oleg_L

Message was edited by: Oleg_L Message was edited by: Oleg_L

Re: plz help

Ksharp — Mon, 07 Mar 2011 01:29:56 GMT

It is interesting.Ok, Let's overcome it.

[pre]
data temp;
infile datalines truncover;
input pid remain $100.;
name=substr(remain,1,anydigit(remain)-1);
age=scan(remain,-2);
race=scan(remain,-1);
drop remain;
datalines;
101 rakesh kumar 34 asian
102 hari 29 african
;
run;
[/pre]

Ksharp