Please I am having trouble with the syntax for working with relational databases. I have two SAS files on the same CD with a one-to-many relationship and one common field (ID No).
Please I need help with with the code/command to read 'simultaneously' from both files/datasets.
However, it appears I'm still not doing something right (I'm really new to SAS). Additional info: The IDNo represents individual patients. Each patient in file1 has many test results in file2.
I am interested in analyzing the data to see, for instance, the mean value of the test results for each patient, etc.
Can you help me with the code please, starting from reading the files (my cd drive is 'D').