topic Re: List Input or Modified List Input in SAS Programming

List Input or Modified List Input

sas_td2016 — Mon, 26 Feb 2018 00:05:36 GMT

Hello Friends

Can you please help me on this query?

I want to get out put for the following file using list or modified list input.

2458 Murray, W 72 185 128 12 38 D
2462 Almers, C 68 171 133 10 5 I
2501 Bonaventure, T 78 177 139 11 13 I
2523 Johnson, R 69 162 114 9 42 S
2539 LaMance, K 75 168 141 11 46 D

Thanks.

Re: List Input or Modified List Input

art297 — Mon, 26 Feb 2018 01:38:26 GMT

Not sure what you're asking, but the following might be close to what you're looking for:

data want (drop=x);
  infile cards truncover;
  informat name $20.;
  input @;
  x=anydigit(substr(_infile_,5))+4;
  _infile_=substr(_infile_,1, x-1)||'  '||substr(_infile_,x);
  input id name & x1-x5 z $;
  cards;
2458 Murray, W 72 185 128 12 38 D
2462 Almers, C 68 171 133 10 5 I
2501 Bonaventure, T 78 177 139 11 13 I
2523 Johnson, R 69 162 114 9 42 S
2539 LaMance, K 75 168 141 11 46 D
;

Art, CEO, AnalystFinder.com

Re: List Input or Modified List Input

sas_td2016 — Mon, 26 Feb 2018 01:57:02 GMT

Thanks for your reply.

I need to get out as eg, Murray, W in the output.

Re: List Input or Modified List Input

art297 — Mon, 26 Feb 2018 02:37:04 GMT

That's what the code I suggested does.

Art, CEO, AnalystFinder.com

Re: List Input or Modified List Input

sas_td2016 — Mon, 26 Feb 2018 02:39:00 GMT

Thanks Art for your help and appreciate that, let me try how it work.

Re: List Input or Modified List Input

Astounding — Mon, 26 Feb 2018 02:58:10 GMT

Simplest might be to read in the first initial as a separate variable, then tack it on to the last name. For example:

data want;

length lastname $ 15;

input id lastname initial $ n1 n2 n3 n4 n5 c1 $;

name = catx(' ', lastname, initial);

drop lastname initial;

cards;

2458 Murray, W 72 185 128 12 38 D
2462 Almers, C 68 171 133 10 5 I
2501 Bonaventure, T 78 177 139 11 13 I
2523 Johnson, R 69 162 114 9 42 S
2539 LaMance, K 75 168 141 11 46 D

;

Re: List Input or Modified List Input

sas_td2016 — Mon, 26 Feb 2018 18:14:24 GMT

Thanks and appreciated for your help.

This is what I get.

My code:

data want;
length lastname $15.;
input
id lastname initial $ RestHR MaxHR RecHR TimeMin TimeSec Tolerance $;
name = catx('',lastname, initial);
drop lastname initial;
cards;

2458 Murray, W 72 185 128 12 38 D
2462 Almers, C 68 171 133 10 5 I
2501 Bonaventure, T 78 177 139 11 13 I
2523 Johnson, R 69 162 114 9 42 S
2539 LaMance, K 75 168 141 11 46 D
;
run;
proc print;run;

Here is the output:

How can I get name in the first column after obs?

What is the importance of this line

drop lastname initial;

Thanks.

Re: List Input or Modified List Input

Astounding — Mon, 26 Feb 2018 18:27:29 GMT

To get NAME in the first column, add it to the LENGTH statement. For example:

length name $ 20 lastname $ 15;

A DROP statement you will need to learn, as part of the basics. It means that the variables LASTNAME and INITIAL should not become part of the final data set. They are computed along the way, but should be removed.

Re: List Input or Modified List Input

sas_td2016 — Mon, 26 Feb 2018 18:45:35 GMT

Great. It works fine.

Thanks lot.