Dear All,    I am trying to create data as instructed in the US Census Data analysis course by following steps mentioned below -  I uploaded the cre8data.sas program found in the downloaded tutorial materials and confirmed that the cre8data.sas program has been uploaded. Then I Double-click the cre8data.sas program to open it on a new tab in the work area. Did Right-click the Census Data Analysis folder and selected the path to the folder and pasted it on the %LET statement, by highlighting the insertpath portion. Then it says that if I Click (Run). On the Results tab, I should see nine tables listed. In addition, my Census Data Analysis folder should contain those nine tables along with three Excel files.   But this is not the case, I am not seeing any data created there in the folder as you can see it with the code I used and the screenshot below -  %let path=/home/u58428058/Census Data Analysis;   libname temp "&path"; options validvarname=any;     Kindly help and guide how I can solve this problem. I am not able to move forward with the course due to this.   Thank you for your time and help.     ... View more

I have a dataset with Medical appointments taken from the Kaggle website.  The dataset I am using contains 110527 medical appointments and their 14 associated variables ( PatientId, AppointmentID, Gender, ScheduledDay, AppointmentDay, Age, Neighbourhood, Scholarship, Hypertension, Diabetes, Alcoholism, Handcap, SMS_received, No-show ).  The original analysis was done using Python and it states that there is no duplicate value in the data.   I am trying to use SAS to find duplicate entries in the dataset and confirm the claim in the original analysis i.e there is no duplicate entry because this is appointment data that may have multiple entries for the same individual but on different dates.    I tried using the Proc Sort procedure  proc sort data=eda_project1 nodupkey dupeout=dupes; by patientid; run; but there are so many entries sorted out in dupes. Can someone guide me on how I can confirm if there are any duplicates or not?  ... View more

Hello everyone;    I am a new SAS user and am trying to create a data analysis project using SAS. I tried renaming a variable with the name "No-Show" to "Show". I tried using all the renaming methods but was not able to change the name of the variable. Kindly guide me on how I can do this. Your help is appreciated.   here is the code I wrote- options validvarname=any; libname aman "/home/u58428058/Aman2023"; data apt_data1 (rename=(no-show=show)); set aman.apt_data; run;   this is the error I am getting- 68 69 data apt_data1 (rename=(no-show=show)); ERROR: no does not have a numeric suffix. 70 set aman.apt_data; 71 run;   kindly help. ... View more

Hello Everyone,    I am a new SAS learner and preparing for the base programming certification exam. I have the prep guide but when I am trying to access the ZIP practice data using the link in the pdf it's giving an error. I tried a couple of times and then decided to post here for help.    I request you to kindly help in downloading the data or share it if you have it. I will be thankful. ... View more