topic Re: input comma separated row data for one variable in New SAS User

input comma separated row data for one variable

urban58 — Fri, 12 Apr 2024 17:00:04 GMT

I'm trying to create a series of SAS datasets of ICD codes given to me in a word doc but I'm having trouble reading the data in

have1
S83.51, S83.511A, S83.511D, S83.511S, S83.512A, S83.512D, S83.512S, S83.519A, S83.519D, S83.519S

want1

code
S83.51
S83.511A
S83.511D
S83.511S
S83.512A
S83.512D
S83.512S
S83.519A
S83.519D
S83.519S

have2
29888, 27407, 27427, 27428, 27429

want2

code

29888

27407

27427

27428

27429

data have;
4969 infile DATALINES delimiter=',' missover;
4970 input code $8;
4971 cards;

NOTE: The data set WORK.HAVE has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds

4971 S83.51, S83.511A, S83.511D, S83.511S, S83.512A, S83.512D, S83.512S, S83.519A, S83.519D,
------
180
4972 ! S83.519S ;

ERROR 180-322: Statement is not valid or it is used out of proper order.

4973 run;

I would appreciate any help,

Maggie

Re: input comma separated row data for one variable

ballardw — Fri, 12 Apr 2024 17:55:20 GMT

This perhaps:

data read;
   infile datalines dlm=',';
   input code :$9. @@ ;
datalines;
S83.51, S83.511A, S83.511D, S83.511S, S83.512A, S83.512D, S83.512S, S83.519A, S83.519D, S83.519S
;

The @@ at the end of input holds the input line for multiple reads. You also didn't have an actual Informat specified (missed the .)

Please post log into a text box opened using the </> icon that appears above the message window. Note that the log bit you show doesn't match what you see in your log window? This forum reformats everything pasted into the main message window and results in moving things like the diagnostic characters in the error message.

Re: input comma separated row data for one variable

urban58 — Fri, 12 Apr 2024 18:06:35 GMT

Thanks ballardw,, your code works!