Hello    I am trying to import a csv file into SAS. One of the variables DOB was created using the following variables: 1) month 2) day 3) year. When I read it in SAS I used the following format: Month (.2) Day (.2) Year (.4). DOB (date9.). When it's done I noticed that DOB was calculated incorrectly so I went back to the csv file and realized the issue was with the csv file. For instance,    Month Day    Year           DOB   1          0       22016           .                            (should be 1/2/2016) 1          0       62016           .                            (should be 1/6/2016) 4          2       42016           .                            (should be 4/24/2016) 12        1       32016           .                            (should be 12/13/2016) 10        2        2016         10/2/2016                (how do I know if it is 10/2/2016 or 10/20/2016)   All I know is that the original data was a txt file and converted into csv by someone else. Unfortunately, I do not know how he/she did it also do not have access to the original text file. Can anyone help me how to resolve the issue here?    Thank you!       ... View more

  Hello, I have two txt files List A and List B. Both are a list of file numbers (6-digit all numeric). List A has 30 records and List B has 2000 records. Theoretically, everyone in List A should be in List B. I am trying to output a dataset (List C) that has everyone in List B that is  NOT in List A thus exclude the people in List A.   Next, with a newly created List C (n=1970), I need to merge it with another csv file called Info, which has the file number and variables I need. Again, theoretically, everyone in List C should be in Info as well. I’d like to create a SAS dataset called Master, which has everyone in List C with the file number and some of the variables from Info.   Does anyone know how I can do this? Thank you so much.  ... View more

Hello    I am trying to read data from a text file. When I did that using the statement below I got notes saying 'invalid data for xyz variable'; I went back to the txt file and they had missing values. Is there any way I can tell SAS to ignore the observations w/ missing values or just get a summary of how many of those have missing values instead of getting notes for each case? The two variables I had missing values are: DTFSPNTC and DLNRMNBG    data selected; infile bb missover; input @1 caseid 6. @172 dob mmddyy8. @414 age 2. @1567 DTFSPNTC mmddyy8. @1672 DLNRMNBG mmddyy8. @1749 weight 4. @1759 multiple 1.; format dob date9. DTFSPNTC date9. DLNRMNBG date9.; run;     Thank you!     ... View more

Hello    I am trying to subset observations that are 9 digits and in AAA-SS-XXXX format (e.g. 132980984). I found some variations including values that are fewer than 9 digits, missing (.), 0, and some values that doesn't have any posted meaning (e.g. 999999999 or 888888888) So far, I am considering anything except AAA-SS-XXXX as being unknown. Can someone help me figure out how to do this?    Thank you!     ... View more

Hello   I am trying to merge Data A (approx 90,000 obs and 50 variables) and Data B (approx 600 obs and 20 variables) and my merged dataset should have everyone from Data B.  There is no unique var that links the two datasets so I am trying to create one. Theoretically, everyone in Data B should be in Data A. The outcome of interest is in Data B (outcome=0 or 1) and most of the info I need for my analysis are in Data A. I've tried to create a unique var using different combinations, but cannot seem to get it right the way I want. For instance, I've tried something like:   firsttname x lastname x 1st line of address x dob (txt): Too conservative as some of the obs in Data A had first name as 'man' or 'resident' instead of the actual names. Last name seems like a good var to use as they were relatively consistent in both datasets.     lastname x dob (txt): This returned some incorrect matching because the merged dataset had more than 700 records.   I am curious if there are any good ways to get this right. The sample size is relatively small so if nothing works I could probably go through them manually, say use the second combo then try to find the ones that do not actually match the records in Data B. Does anybody has any suggestions or tips on this?   Thank you!     ... View more

Hello    I am trying to combine three SAS datasets. Each dataset has a different number of variables (e.g. dataset A has 209 vars, B has 97 vars and C has 102.) When I tried combining them using the data step I got a bunch of warning messages saying "multiple lengths were specified for..".  I expected this because the datasets were created by different people. So my question is what would be the best way to go about this? How do I redefine the length and the type of the variables so that those variables I would like to see included in my master dataset are formatted consistently (e.g. character, length etc.) Also, should that happen before I combine them or after? I am only going to keep the variables that exist in all three datasets once I combine them.    Thank you!  ... View more

Hello    I have a variable called Plural in my dataset (numeric; 1-8; 9=unknown). Since for those w. Plural >1 will have duplicate values for the variables I am interested in, I want  SAS to keep only one record (doesn't matter which) when Plural >1. Does anyone know how to do this?    Thank you!      ... View more