Hello!    For reporting purposes, I am trying to get a list of files from a directory as a variable in a sas dataset. I am using the following code to access a test directory (unfortunately I can't show the actual filenames in the actual directory, so below has a lot of dummy code/placeholders):     filename pipedir pipe "dir test/users/documents" lrecl=5000; data test; infile pipedir truncover; input line $char1000.; put line; run; However, instead of one filename per obs, the variable line in work.test has 4 filenames per obs:    Here's how work.test should look:   I tried 'dlm=".doc"' and 'dlm=" "', but I was not able to fix it. Does anyone have any suggestions?   Thank you in advance.    Best, Yawen  ... View more

Hello,   I have a dataset to start that looks like this:   NAME Adam Anne Alex Allen  and so on. The number of obs doesn't really matter as it is a growing dataset.    For reporting purposes, I would like to randomly assign either 1 or 2 to a name with a 40-60 split. 40% of name will be assigned 1 and 60% will be assigned 2:   NAME Adam   1 Anne    2 Alex     2  Allen    1 and so on.   This part is pretty simple, but the tricky part is having each name retain the same assigned number even when new names are added to the dataset. What I mean by this is if next week, if there are two more names added, the old names should not be assigned a new number, but should keep the old number. The new names will be randomly assigned a new number:   NAME Adam   1 Anne    2 Alex     2  Allen    1 Alfred   2 Albert   2 and so on.   I've tried proc surveyselect, and it does the first part well, but I am having trouble getting the previous names to not get randomly assigned a number again. If anyone has any suggestions, that would be great. I am not set on using proc surveyselect, any method will do as long as it can produce the correct dataset. Thank you! ... View more