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.
... View more