Using SAS 9.4   I am submitting data and the format is specific that each field is to be separated by space only and not by tabs. Is there a good method in SAS to use to accomplish this? Thank you ... View more

Hello,   Using SAS 9.4.    Is it possible to merge 2 data sets by a specific ID that is not the same? Meaning I have 2 data sets where I want to keep all information from both data sets and have the data in a wide format. The only problem is the data is a 1:2 merge with ID that do not match. Is there a good method to perform this? Thank you   ID     ID2 1      10 1      20 2      3 2      8 3      90 3      15   So I need to have 2 rows with ID 1 and merge in ID 10 and 20 on the same row as ID 1 to create the data set? Any thoughts would be helpful.  ... View more

Hello,   Using SAS 9.4.    I am creating a line graph of the average satisfaction score for a group of people. Is it possible to have the number of people (n) who contributed a score displayed on the line? Meaning I want to see essentially the number of people contributing a score and not the acutal average across the multiple time points. Below is a copy of my code, I know how to put the average at each time point on the line but am not sure how to put the number of respondents or if that is even possible. Thank you   PROC SGPLOT DATA = have; where event_name = 'A' or 'G' or 'L' or 'M' or 'N'; SERIES X = event_name Y = AVG_SATISTFACTION / group= failure datalabel = AVG_SATISTFACTION MARKERS LINEATTRS = (THICKNESS = 2); TITLE 'Average Satistfaction by Failure'; yaxis label = 'Average Satistfaction Captured'; RUN; ... View more

Using SAS 9.4   I have 14 data sets that I need to "merge". I put merge in quotations because it is not a true merge where I would combining information I more just need to put all of the information from the data sets into one large data set so that I can run a frequency. The hard part is some of the variables are in one data set and not the other:   data set 1- 5213 observations and 953 variables 2 -90 observations and 834 variables 3- 812 observations and 973 variables 4- 30 observations and 935 variables 5- 275 observations and 1163 variables 6- 6612 observations and 1058 variables 7- 78 observations and 76 variables 8- 1111 observations and 76 variables 9- 70 observations and 1031 variables 10- 452 observations and 871 variables 11- 360 observations and 2277 variables 12- 2060 observations and 789 variables 13- 2222 observations and 1880 variables 14- 60 observations and 1237 variables   So my question is with the different number of variables across all of the data sets is their a good way to combine the data without losing any of the variables, understanding (and wanting) that this will create blank observations in the new data set. Thank you ... View more