topic Re: How to avoid values getting truncated when creating a new calculated column? in SAS Programming

How to avoid values getting truncated when creating a new calculated column?

avijit_p — Wed, 06 Dec 2017 15:49:14 GMT

I am self learning SAS and am stuck in a very basic Issue.

Kindly refer to the code:

data work.empsal1;
set work.empsal;
if salary < 20000 then PAYBAND = "LOW" ;
ELSE IF 20000 <= SALARY < 30000 THEN PAYBAND = "MEDIUM";
ELSE PAYBAND = "HIGH";
RUN;

The values in the PAYBAND column is appearing as 'LOW', 'MED', 'HIG'

How to fix It.

It is very basic issue but as I have no direct tutor I cannot solve it. Plz help.

Re: How to avoid values getting truncated when creating a new calculated column?

PaigeMiller — Wed, 06 Dec 2017 15:53:39 GMT

after the SET statement, you need a LENGTH statement to specify the maximum length of the variable. If you don't it sets the length by the length of the first time the variable is assigned a value.

length payband $ 6;

Re: How to avoid values getting truncated when creating a new calculated column?

Reeza — Wed, 06 Dec 2017 16:39:29 GMT

@avijit_p wrote:

It is very basic issue but as I have no direct tutor I cannot solve it. Plz help.

People get direct tutors?

Re: How to avoid values getting truncated when creating a new calculated column?

ballardw — Wed, 06 Dec 2017 16:47:41 GMT

A very important part of SAS is the Format of variable. The format displays desired text and for almost all of the analysis procedures will use the formatted values for categories. The very fun part is that you can create formats as needed. That will allow you to create multiple displays or analysis from the same variable without having to create multiple variables as long as you only need one category set per procedure for a given variable.

Consider:

proc format library=work;
value payband
low   - < 20000 = 'LOW'
20000 - < 30000 = 'MEDIUM'
30000 - HIGH   = 'HIGH'
;
value alpayband
0  - < 20000 = 'LOW'
20000 - < 30000 = 'MEDIUM'
30000 - < 50000 = 'Higher'
50000 - High = 'HIGHEST'
;

run;

proc freq data=work.empsal;
   tables salary;
   format salary payband.;
run;

proc freq data=work.empsal;
   tables salary;
   format salary altpayband.;
run;

Re: How to avoid values getting truncated when creating a new calculated column?

Reeza — Wed, 06 Dec 2017 16:50:59 GMT

The first SAS e-course is free and covers topics like this. There's also

video.sas.com -> How To> Analytics U

http://video.sas.com/#category/videos/sas-analytics-u

Lots of videos that cover these topics.

Re: How to avoid values getting truncated when creating a new calculated column?

avijit_p — Thu, 07 Dec 2017 05:11:55 GMT

Thanks for the support.

Re: How to avoid values getting truncated when creating a new calculated column?

avijit_p — Thu, 07 Dec 2017 05:13:39 GMT

Thanks a lot.

The videos would of a great help.