I want to concatenate two datasets (HAVE1 & HAVE2) and obtain a new dataset that only contains the variables that are in common (WANT) without having to explicitly DROP variables from the concatenated dataset. When I combine the two datasets using the SET statement (CONCAT), I get all variables from both of the original datasets (GET).   EXAMPLE CODE: data have1; input var1 var2; datalines; 11 21 12 22 13 23 ; run;   data have2; input var1 var2 var3; datalines; 14 24 31 15 25 32 16 26 33 ; run;   data want; input var1 var2; datalines; 11 21 12 22 13 23 14 24 15 25 16 26 ; run;   data concat; set have1 have2; run;   data get; input var1 var2 var3; datalines; 11 21 . 12 22 . 13 23 . 14 24 31 15 25 32 16 26 33 ; run; ... View more

I would like to create a graphic in which a histogram that shows the frequencies for one variable (Ability in the data example, Have) shares an axis with a scatterplot of two other variables (X = Item and Y = Difficulty in the data example). That is, the values of Ability and Difficulty would all reference a common axis as shown in the Want figure below. Ideally, the scatterplot points would be labeled with another variable (Label in the data example). Any idea whether and, if so, how this can be done in SAS?   Have: Want: ... View more

  I'm writing a macro that contains a macro parameter with a list of values, and I want to print each of those values on a separate line of the output file. I've tried using TRNWRD to do this, but the spaces in the list are not being replaced with line returns.   Have: List=* 1 2 3 4 *   Want: LIST=* 1 2 3 4 *   When I run the example code, in which I was trying to use TRANWRD to convert spaces to line returns, I get what I thought was the line return code instead of the line returns:   1'0D0A'x2'0D0A'x3'0D0A'x4   Example Code: %macro test(list); %Let List2 = %sysfunc(tranwrd(&List,%str( ),'0D0A'x)); data _null_; put "LIST=*" / "&List2" / "*" ; run; %mend test; %test(1 2 3 4); ... View more

I want to use PROC IRT to score data using item parameters that were created outside of SAS. Can anyone explain (perhaps with an example) how to create a file that SAS will accept in the INMODEL(SCORE) option of the PROC IRT statement?   Attached is a command file that demonstrates what I'm trying to do. The first PROC IRT generates the estimates (for the sake of demonstration--this part would be done outside of SAS in the example I'm describing), and the second PROC IRT attempts to read a data file that I created that contains the estimates. Obviously, I'm not creating the data file correctly, because PROC IRT doesn't recognize the number of groups even though it's specified in the first line of the data file. ... View more