topic Re: datatyp issue in SAS Programming

datatyp issue

newbie69 — Mon, 07 Mar 2022 17:42:30 GMT

Hi,

can someone tell me why that

data new;
do map = 1 to 7;
output;
end;
char_map= put(map,4.);
run;

doesn't do what it should, namely to change from numeric to character/string? (need it to map with another column which is a string... ) Thanks!

Re: datatyp issue

PaigeMiller — Mon, 07 Mar 2022 18:08:17 GMT

Since your PUT function comes after the OUTPUT statement, nothing from PUT is ever output to the data set. Perhaps this is what you want:

data new;
    do map = 1 to 7;
        char_map= put(map,4.);
        output;
    end;
run;

Now because PUT comes before output, the results of PUT are written to the data set.

And so really, your subject line is wrong, this problem has nothing to do with the data type of the variable. Probably best not to jump to conclusions about the cause, and just simply use a subject line like "PUT statement not working" and ask how to fix it to give the desired result.

Re: datatyp issue

Reeza — Mon, 07 Mar 2022 17:53:45 GMT

I think there is an order of operations issue. The output is within the loop and BEFORE the conversion.

Some concepts:

Once there is an explicit OUTPUT statement there is no more implicit OUTPUT
No input data set also means no default loop
Conversion needs to occur before the record is written to the dataset.

data new;
do map = 1 to 7;
         char_map= put(map,4.);
         output;
end;
run;

@newbie69 wrote:

Hi,

can someone tell me why that

data new;
do map = 1 to 7;
output;
end;
char_map= put(map,4.);
run;

doesn't do what it should, namely to change from numeric to character/string? (need it to map with another column which is a string... ) Thanks!