data state1; input name $ rank status $ ; length name $5 status $50; datalines; mekelele 1 nohope torres 1 depress valdes 1 sotkaal bhutia 1 fulltension ; run;   In the above statement - I have particularly set the length of variable name to $5 and status to $50 By that logic I must get: for mekelele - makel(only 5 characters) and for fulltension - fulltension (since length is $50 the whole word must come)   However, i am  not gettign the desired outcome (see screenshot attached)? ... View more

Code as written by me: Approach1 data temp_sw; set ramu.temp; select; when (Expense>4000) spendanalysed="Low class"; and when (Expense>20000) spendanalysed="Middle class"; and when (Expense>50000) spendanalysed="Affluent"; otherwise spendanalysed="Poor"; end; run;   Code as written by me: Approach2 data temp_sw; set ramu.temp; length spendanalysed $25; select; if (Expense>4000) spendanalysed="Low class"; else if (Expense>20000) spendanalysed="Middle class"; else if (Expense>50000) spendanalysed="Affluent"; else do spendanalysed="Poor"; end; run;   In both aprroaches, i am getting an error in the log. the respective logs are attached below for your reference.   Please help:-( ... View more

Hi Guys, I am Shriram from Bangalore, India. I am new to this community/forum. I have just about started learning SAS and have lots of doubts. I would be glad and grateful if anyone can give me pointers on how to approach the subject, how to ask mny questions and any other suggestions.   Heres is to a start of our association:   Scenario 1: No problems and it works fine data _null_; x=123.45567; y=round(x,0.1); /* nth decimal place*/ z=round(x,100); /* nearest 100 place*/ m=round(x,10);  /*nearest 10 place*/ put y; put z; put m; run;   Scenario 2: how to round of columns of an incoming data set data roundtest;   set <libref>.filename; then how to write the code for rounding of columns y w r l and k. (Attached screen shot of columns) the data comprises of columns y w r l and K and year. Now all these columns(except year) are in 8-9th decimal place. I want to round of to the first decimal  place?... ... View more