04-10-2018 09:06 AM
I have a list of respondents (in Excel) that have missing data for postcode, emails, student numbers to name a few demographics.
What code do I need to use in SAS in order to fill in these missing columns of data?
I have attached an example of the data I will be using/the columns of data that are missing and need filling in.
I am using SAS Enterprise Guide 7.1.
Help on this would be greatly appreciated!
04-10-2018 09:19 AM
Import the data into SAS.
Write a datastep with som if statements to fill in the missing values.
Cannot provide anything further, you will need to help us by providing some things:
Test data in the form of a datastep - Excel is useless and dangerous. Post a datastep with some test data, you can follow this post when its in SAS:
Then from that test data show us what you would want out.
To import you have various options such as proc import.
To do ifs you can do something like:
data want; set have; if emails="" then emails="default text"; run;
04-10-2018 09:20 AM