topic Re: Flag value getting cut off in New SAS User

Flag value getting cut off

AJ_Brien — Mon, 24 Jun 2019 18:12:45 GMT

Hello,

I'm running this piece of code, but even though here it says LEAD, in the output it shows up as LEA. Why is the flag value getting cut off?

This is the first instance of the variable flag that SAS encounters, so it's not even that the size of flag is being set before by some other value. Appreciate the help. Thanks!

data abc;
set abc;
if stage in ('45','35') then flag="LEAD";
run;

Re: Flag value getting cut off

PGStats — Mon, 24 Jun 2019 18:24:55 GMT

It might be that flag already exists in dataset abc.

Add the statement

length flag $8;

before the set statement.

Re: Flag value getting cut off

AJ_Brien — Mon, 24 Jun 2019 18:42:12 GMT

For some reason that didn't help either. It still displays as LEA.

This flag has not been declared, initialized or used anywhere else before this statement, that's what's confusing me

Re: Flag value getting cut off

AJ_Brien — Mon, 24 Jun 2019 18:43:33 GMT

This is what the log says at the end of that datastep:

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
2765:4
NOTE: There were 522116 observations read from the data set WORK.ABC.
NOTE: The data set WORK.ABC has 522116 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.17 seconds
cpu time 0.18 seconds

Re: Flag value getting cut off

PGStats — Mon, 24 Jun 2019 18:51:26 GMT

Then try

data abc;
set abc(drop=flag);
if stage in (45, 35) then flag="LEAD";
run;

Re: Flag value getting cut off

Tom — Mon, 24 Jun 2019 18:54:00 GMT

It is possible that the issues is with a format that is attached to the variable. Changing the length will not change the format attached. So if you force the length to by 8 bytes but it still has $3 format attached to it then only the first three characters will show on printouts.

Re: Flag value getting cut off

ballardw — Mon, 24 Jun 2019 21:09:10 GMT

@AJ_Brien wrote:

Hello,

I'm running this piece of code, but even though here it says LEAD, in the output it shows up as LEA. Why is the flag value getting cut off?

This is the first instance of the variable flag that SAS encounters, so it's not even that the size of flag is being set before by some other value. Appreciate the help. Thanks!
data abc;
set abc;
if stage in ('45','35') then flag="LEAD";
run;

If you ran this code more than once then you do have the variable flag in the data set ABC because you placed it there.

This is a side effect of using the

Data abc;

set abc;

code structure. The first time you ran that code and there were no errors preventing the execution you completely replaced the data set.

If you previously ran the code with a logic error such as:

if stage in ('45','35') then flag="LEA";

then you created a text variable with a length of 3.

When testing recoding of variables always send the output to a different data set so you do not corrupt your starting data.

Also post your log with code and any messages together into a code box.

Something else: define "getting cut off". How are you seeing a "cut off" value? Did you Print the data set (or at least that variable)? Put statement in the data step? Something else?

Have you run Proc contents on the data set to tell you what the properties of the variable Flag might be? Perhaps somehow it acquired a format of $3. limiting what value will display in either a viewtable or printed output.