Hey everyone! I succesfully created a SAS table with the code below but what I need/want to do now is add another column/variable that is equal to variables One - Two. Help please!   proc sql; create table work.combined as select a. Number, a. County, a. Counts, a. Sickness, a. One, a. OverallSickness, b. Number, b. Two from today a, yesterday b where a.Number = b.Number; quit; ... View more

Hello!   How do I change my entire dataset from character to numeric??   I have the code on how to do one variable at a time but is there a code for the whole dataset?   Using SAS 9.4 for windowing environments!   Thanks! ... View more

I am trying to learn on SAS Enterprise while going through programming I. It seems like its missing some instructions but I could just be missing something.   For example - in lesson 2 there is a portion wanting you to make a library based off an excel file. However it doesn't tell you where this excel file is for enterprise? The zip file downloaded for enterprise doesn't have any excel files in it.   Any insight is appreciated.   Thanks! ... View more