$1)$ Download the Demographic file of all adverse events reported to the food and drugs administration $($FDA$)$ in the first quarter of $2019($DEMO$19$Q$1).$ The dataset comes as an ASCII file $(.$txt file extension$).$

$2)$ Create a permanent SAS library called Exam$1(1$ pt$)$

$3)$ Using the INFILE statement method only, import the Demographics file into SAS and permanently store it in the Exam$1$ library. Name the SAS dataset $$Demog$.$ Use the data description file $($ASC$\_$NTS$.$PDF$)$ to determine the list of variables.

a$.$ The length of some character variables are as follows:

i$.$ Mfr$\_$sndr$=120$

ii$.$ Mfr$\_$num$=100$ iii. Lit$\_$ref$=1000$

Note: Ensure to open the file to explore the data and understand its structure. Do you notice consecutive delimiters? Think of an INFILE statement option that can handle the situation. Take note of the date values and use the right SAS informat to read the data. Some dates are partial and could appear missing depending on the informat you choose. This is acceptable in this exam $(10$ pts$)$

$4)$ Create labels for all variables using the data description file. Remember the character limit of labels is $252$ so try to make your labels succinct. $(2$ pts$)$

Now that you$$ve saved the demographic ASCII file as a SAS dataset, answer the questions below.

Questions:

$1)$ How many reports were submitted in the first quarter? Assume each observation is a unique report $(1$ pt$)$

$2)$ How many variables are in the dataset? $(1$ pt$).$ Use the appropriate SAS code to answer questions $(1)$ and $(2)$

$3)$ Print out the first $10$ observations for the variables listed below. Use an appropriate format to display the dates as two$-$digit day, three$-$letter month and four$-$digit year $($ex$.01$JAN$2020).$ Also, ensure the variable labels are displayed in the output. Submit this output

a$.$ Primaryid

b$.$ Sex

c$.$ Age

d$.$ Age$\_$grp

e$.$ Rept$\_$dt

f$.$ Occp$\_$cod $(1$ pt$)$