/*So neither version of code actually gives a length of 17 to Smoking_Status. It caps out at 14 in the output (I have noticed that 14 is the length of the string Smoking_Status). In either version of the code, if I move the length statement to the beginning of the data step the length is still incorrect. PLEASE HELP!*/   /*The key's solution:*/   libname certdata XLSX '/home/aaronbailey790/cert/heart.xlsx'; data work.heart; set certdata.heart(drop=AgeAtDeath DeathCause); where Status='Alive'; if AgeCHDdiag=. then delete; length Smoking_Status $17; if 0<=Smoking<6 then Smoking_Status='Non-Smoker (0-5)'; else if 6<=Smoking<=15 then Smoking_Status='Moderate (6-15)'; else if 16<=Smoking<=25 then Smoking_Status='Heavy (16-25)'; else if Smoking>25 then Smoking_Status='Very Heavy (> 25)'; else Smoking_Status='Error'; run;   \*My solution*\   proc import datafile = '/home/aaronbailey790/cert/heart.xlsx' dbms = xlsx out = work.temp replace; run; data work.heart (drop = AgeAtDeath DeathCause); set work.temp; length Smoking_Status $17; if 0<= Smoking < 6 then Smoking_Status = 'None (0-5)'; else if 6 <= Smoking <=15 then Smoking_Status = 'Moderate (6-15)'; else if 16 <= Smoking <=25 then Smoking_Status = 'Very Heavy (>25)'; else Smoking_Status = 'Error'; if AgeCHDdiag = . then delete; if Status = 'Alive' then output; run; ... View more

I am using SAS studio, fully online.   In Scenario 4, to generate a pdf, I came up with this code which agrees with the solution:   proc sort data = cert.laguardia out = work.laguardia; by dest; run; ods html close; ods pdf file = 'LGA Airport' style=FestivalPrinter; proc print data=work.laguardia; title 'Laguardia Flights'; by dest; run; ods pdf close;   However, I cannot seem to actually create the pdf and get this message in the log:   ERROR: Insufficient authorization to access /pbr/biconfig/940/Lev1/SASApp/LGA Airport.   How do I view pdf output? ... View more