topic Re: Unwanted cut in the output in SAS Programming

Unwanted cut in the output

OGA13 — Thu, 07 May 2020 18:14:32 GMT

I tried to submit the code below, but SAS does't show the word after the blank in the values of the variable "COMPLICATION".

Can anyone fix it?

data complication;
length SUBJECT 8 COMPLICATION $15;
input SUBJECT COMPLICATION $ ;
datalines;
2076 Pneumonia
3585 DVT(Lower)
3630 DVT(Lower)
4585 Compartment
4599 Aspiration
4760 Acute Resp
4775 Pneumonia
2076 Heart Attack
3585 Pneumonia
3660 Heart Attack
4585 Pneumonia
4599 Pneumonia
4760 Pneumonia
4775 DVT(Lower)
2076 Renal Fail
3585 Renal Fail
3630 Pancreatit
4585 Skin Break
4599 Renal Fail
4760 Renal Fail
4775 Pneumonia
3630 Pneumonia
4775 Renal Fail
;
run;

Re: Unwanted cut in the output

brzcol — Thu, 07 May 2020 18:56:27 GMT

data complication;
length Subject 8 Complication $15;
input Subject  Complication & $;
datalines;
2076 Pneumonia
3585 DVT(Lower)
3630 DVT(Lower)
4585 Compartment
4599 Aspiration
4760 Acute Resp
4775 Pneumonia
2076 Heart Attack
3585 Pneumonia
3660 Heart Attack
4585 Pneumonia
4599 Pneumonia
4760 Pneumonia
4775 DVT(Lower)
2076 Renal Fail
3585 Renal Fail
3630 Pancreatit
4585 Skin Break
4599 Renal Fail
4760 Renal Fail
4775 Pneumonia
3630 Pneumonia
4775 Renal Fail
;
run;

What you need to do is add in the & modifier on the input statement since the values include spaces.

https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=lestmtsref&docsetTarget=n0lrz3gb7m9e4rn137op544ddg0v.htm&locale=en#p1wk2kecsf6iz8n1ufug4i5pg6id

Re: Unwanted cut in the output

Shmuel — Thu, 07 May 2020 19:03:43 GMT

Alternatively to @brzcol solution you can try next code:

data complication;
infile datalines truncover;
length Subject 8 Complication $15;
input Subject  Complication $char15.;
datalines;
2076 Pneumonia
......
; run;

Re: Unwanted cut in the output

Reeza — Thu, 07 May 2020 19:03:56 GMT

You're aware the data you have posted is already truncated as well?

Re: Unwanted cut in the output

OGA13 — Thu, 07 May 2020 19:22:00 GMT

Yes, I do. But thanks for the interest.

Re: Unwanted cut in the output

OGA13 — Sat, 09 May 2020 14:22:30 GMT

Thanks very much for your help.

I'm just wondering why do i need to specify the format in the input statement as well?