on 11-29-2017 06:32 AM
This is a discussion group for those on the CERT94 London 27th Nov - 1st Dec. Ask any questions you need help with and help out by answering questions you might know the answer to!
11-29-2017 08:40 AM - edited 11-29-2017 09:21 AM
*** This is not needed for the Base Certification Exam ***
To suppress the word 'Frequency' from appearing every observation when using the FREQ procedure run the following code first...
(to change the template used for proc freq)
ods path work.templat(update) sashelp.tmplmst(read);
Or just use proc tabulate!
on 11-30-2017 07:54 AM
This is not on the certification exam - it is the answer to a question asked on the course.
********** Create Data **********;
input First $ Gender $ EmpID;
Togar M 121150
Kylie F 121151
Birin M 121152
input EmpID Type $ Phone $15.;
121150 Home +61(2)5555-1793
121150 Work +61(2)5555-1794
121151 Home +61(2)5555-1849
121151 Work +61(2)5555-1850
121152 Home +61(2)5555-1665
121152 Work +61(2)5555-1666
The following program merges the datasets but only creates one record per EmpID. Work and home phone numbers are concatenated into one string.
Multiple records into 1.....
********** One-to-Many Merge **********;
merge EmpsAU PhoneHW;
length bigphone $123;
if first.EmpID then bigphone =“ ”;
if last.EmpID ;