Leading blank space removed while reading from datalines.

[nilesh1985]

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

[PeterClemmensen · Accepted solution]

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;

[nilesh1985]

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