Thanks for the feedback Art and Tom. I appreciate it. Art, I am attaching files for you to see the output. The files I am attaching are: FirstOperation3 - The SAS Code (You will note I am not a clean coder, though I do use comments. My code is a random sample of things I found that worked and not elegant). Test7.csv - The output with the ok negative numbers. InitialAppend.csv This is imported early in the code to make the base file to append data to. Note this goes in a SASOUT Folder Assassins_Creed.csv this is the data. Note this goes in a SASCODING folder. Note you may need to change the directories to see all of the test outputs. The long long story: This is part of my PhD research. I, and three coders I have hired, have coded every sentence of reviews of video games to better understand the predictors of product quality. Not every sentence gets a positive or negative number attached, only some. Not all of us have coded every game, and not all of us coded the games in the same order. As you will see, only Rebeca and myself coded Assassins_Creed.csv. The ultimate goal is to get all of the data transposed and into a huge appended file with 200+ games in it (from SASCODING folder with 200+ csv files). I hope the comments makes sense, but basically I load the initialappend.csv to dataset appendlist to get the correct variables in the appended file (I dont mind changing them all to character). I then create a macro to cycle through all of the files in the SASCODING folder to loop through each game's file. The rest (before test8) is trying to get the data in a manageable format for an append. Variable names: _NAME_ = Name of Sentence # of the Review. Also has data on type of coding. David, Rebeca, Victoria, Coder4 = All Coders NEWNAME = Game Name Type = Type of Code (there were initially four types, but type 4 is NA's I drop it) Tom, Thanks for your insights. I am not skilled enough to follow all of your code, but if I wanted to make everything character would I do input $; instead of input @;? I appreciate all of the help immensly. -David
... View more