Hello. Please see the code below. I am using the SAS University Edition (SAS Studio). I am not getting the correct output along with error messages. The output should reflect under columns (Ques1-Ques5) "Agree", "Strongly Agree", etc. I may be mixing apples and oranges here. Can anybody tell me how to correct my code or show me a correct version of my code? FYI: I am a student and following along in my book (p.59-60) in the book entitled: "Learning SAS by Example. A Programmer's Guide. 2nd Edition" Code: libname Learn1 '/folders/myshortcuts/New_folder';
data Learn1.Test_Scores1;
input ID Gender$ Age Salary Ques1-Ques5$;
datalines;
001 M 23 28000 1 2 1 2 3
002 F 55 76123 4 5 2 1 1
003 M 38 36500 2 2 2 2 1
004 F 67 128000 5 3 2 2 4
005 M 22 23060 3 3 3 4 2
006 M 63 90000 2 3 5 4 3
007 F 45 76100 5 3 4 3 3
;
run;
proc format;
value $Gender 'M' = 'Male'
'F' = 'Female'
' ' = 'Not Entered'
other = 'Miscoded';
value Age low-29 = 'Less than 30'
30-50 = '30 to 50'
51-high = '51+';
value $Likert '1' = 'Str Disagree'
'2' = 'Disagree'
'3' = 'No opinion'
'4' = 'Agree'
'5' = 'Str Agree';
run;
title "Data";
proc print data=Learn1.Test_Scores1;
id ID;
var Gender Age Salary Ques1-Ques5;
format Gender $Gender.
Age Age.
Ques1-Ques5 $Likert.
Salary Dollar11.2;
run; Errors: ERROR: You are trying to use the character format $LIKERT with the numeric variable Ques1 in data set LEARN1.TEST_SCORES1. ERROR: You are trying to use the character format $LIKERT with the numeric variable Ques2 in data set LEARN1.TEST_SCORES1. ERROR: You are trying to use the character format $LIKERT with the numeric variable Ques3 in data set LEARN1.TEST_SCORES1. ERROR: You are trying to use the character format $LIKERT with the numeric variable Ques4 in data set LEARN1.TEST_SCORES1. 110 run;
... View more