topic Leading blank space removed while reading from datalines. in SAS Programming

Leading blank space removed while reading from datalines.

nilesh1985 — Mon, 07 Feb 2022 09:31:07 GMT

Hi,

Environment : SAS ODAMID/ SAS Studio

I am trying to create a dataset using datalines, wherein one of the columns has leading spaces. I want to keep the leading spaces in the created dataset which is not happening by default.

Would appreciate any help. Thanks in advance.

Example

data exp3;
infile datalines delimiter=","; 
INPUT SNO :8. cat :$150.;
datalines;
1,     main category
2,         sub category
;
run;

Output (Default)

1|main category

2|sub category

Desired Output

1| main category

2| sub category

Regards,

Nilesh

Re: Leading blank space removed while reading from datalines.

PeterClemmensen — Mon, 07 Feb 2022 09:41:37 GMT

It's an informat thing. Use the $Charw. instead like this

data exp3;
infile datalines delimiter=","; 
INPUT SNO :8. cat :$char150.;
datalines;
1,     main category
2,         sub category
;
run;

Re: Leading blank space removed while reading from datalines.

nilesh1985 — Tue, 08 Feb 2022 06:31:50 GMT

On the same lines need some more clarification:-
data exp3;
infile datalines delimiter=",";
INPUT SNO :8. cat :$char150.;
datalines;
1, main category 1 - orthopedics
2, sub category
3, main category sub 2 - hemotology
4, sub category 2
;
run;

If I manually align the sub category to come below the - of main category it gets automatically aligned with less spacing, but if i put any other character like '*' in place of space, then it works.

Reason being i am trying to create a template for report.

Any help would be appreciated.

Regards,
Nilesh