topic Re: can any one solve this and let me know what is the problem with the code in Programming 1 and 2

Datastep Input: wat is the problem with my code?

Shailesh_R_T — Tue, 22 Apr 2025 15:20:43 GMT

data SRT;
input ProjID $ Manager :$15. Budget CompletionPercent;
datalines;
P001 James Lee 100000 85
P002 Sophia Ray 120000 90
P003 Michael Chen 75
P004 Emma Stone 95000 .
P005 Olivia Park 110000 88
;
run;

proc print data=SRT;
run;

Re: can any one solve this and let me know what is the problem with the code

PaigeMiller — Sun, 20 Apr 2025 19:00:10 GMT

I have fixed a few things here, perhaps this is all of the things that are wrong, or perhaps not, you didn't really tell us what is wrong, and you SHOULD tell us what is wrong.

data SRT;
infile datalines dlmstr='~' truncover;
input ProjID $ Manager :$15. Budget CompletionPercent;
datalines;
P001~James Lee~100000~85
P002~Sophia Ray~120000~90
P003~Michael Chen~75
P004~Emma Stone~95000~.
P005~Olivia Park~110000~88
;

SAS doesn't really know what separates the fields in your data, the default is a space, but that won't work because the field MANAGER must contain a space. So in this example, I have forced the character ~ to be used as the separator between the fields.

Re: can any one solve this and let me know what is the problem with the code

Ksharp — Mon, 21 Apr 2025 01:08:32 GMT

I think you should post your code or data with this button:

Otherwise it would eat your multiple blanks, like there are four blanks in your data,but display it only one blank.

data SRT;
input ProjID $ Manager & $15. Budget CompletionPercent;
datalines;
P001 James Lee      100000 85
P002 Sophia Ray     120000 90
P003 Michael Chen   75
P004 Emma Stone     95000 .
P005 Olivia Park    110000 88
;
run;

proc print data=SRT;
run;

Re: can any one solve this and let me know what is the problem with the code

PaigeMiller — Mon, 21 Apr 2025 10:12:41 GMT

@Ksharp Good point!

But how did you know 4 blanks were compressed into 1?

Re: can any one solve this and let me know what is the problem with the code

Ksharp — Tue, 22 Apr 2025 09:05:03 GMT

@PaigeMiller
I tried it before. One time I posted the data step without the running man icon, I found multiple blanks compressed into 1.
If you don't believe it, you could try it.

Re: can any one solve this and let me know what is the problem with the code

PaigeMiller — Tue, 22 Apr 2025 09:43:41 GMT

Thanks. I do believe you.

Looks like the OP has vanished.

Re: can any one solve this and let me know what is the problem with the code

Shailesh_R_T — Sun, 11 May 2025 17:16:54 GMT

THANKS