could also just upload the data using the specified path data Learn.Survey; infile '/folders/myfolders/BookFiles/survey.txt'; input ID $ Gender $ Age Salary Ques1 $ Ques2 $ Ques3 $ Ques4 $ Ques5 $; run; /* Needed to label each Question out with the dollar sign afterwards instead of doing Ques1-Ques5, dumb */ proc format; value $Gender 'M' = 'Male' 'F' = 'Female' ' ' = 'not listed' other = 'miscoded'; value Age low-29 = 'below 30' 30-50 = '30 to 50' 51-high = 'above 51'; value $Likert '1' = 'Str Disagree' '2' = 'Disagree' '3' = 'No Opinion' '4' = 'Agree' '5' = 'Str Agree'; run; title "Data Set Survey with Formatted Values"; proc print data = Learn.survey; id ID; var Gender Age Salary Ques1-Ques5; format Gender $Gender. Age Age. Ques1-Ques5 $Likert. Salary Dollar11.2; run;
... View more