SAS Exam Question 1

The following SAS program is submitted:
data work.AreaCodes;
Phonenumber=3125551212;
Code='('!!substr(Phonenumber,1,3)!!')';
run;
Which one of the following is the value of the variable Code in the output data set?
a. (  3)
b. (312)
c. 3
d. 312


Answer:   A (see the answer after replying the post )


Tips: the substr function convert the numerical variables to character variables, the length is 12, the format is best12.

Beautiful geographical picture in SAS

You may have some geographacial data and want to present it a easily understandable way, how can we do that in SAS? Here are some example output we can make in SAS:

The coding part is relative easy, copy the following code and run in SAS, you will get some similar output: 

/**********************************/
goptions gunit=pct cback=white htitle=4 htext=3
colors=(PAGY LIY STY DEGY dark_yellow very_dark_yellow ) ;

title1 "US Population in 1990";
proc gmap map=maps.us data=maps.uscity all;
id state;

block pop/levels=6;
choro pop/levels=6;

run; quit; 

/***********************************/

Brief introdcution for SAS certification exam

4 certification exams. I passed two of them when i was still in graduate school and passed another two from work. It takes some time to prepare. I'll explain some tips or strategies later how to prepare and study those exams.

• SAS Certified Base Programmer for SAS 9

The fundamental one, it's 1st sas exam to take.

• SAS Certified Clinical Trials Programmer Using SAS 9

This one is very good for pharmaceutical industry.

• SAS Certified Advanced Programmer for SAS 9

Advanced one, SQL query is the key. You really have to play with the data.

• SAS Certified Predictive Modeler Using SAS Enterprise Miner 5 or 6

More about data mining and text mining, requires good understanding of general data mining principle and sound statistics background.


Note: If you are still students or some faculty or staff from academic institution, then you are qualified for academic 50% discount for the registration fee.


People sometimes address SAS professionals: semi-colon genius!