@Blandine Yes, if this is still an active problem let us know. Please also provide some representative sample data via SAS data steps that shows the issue and the desired outcome. Not sure that I really understand what you describe as it sounds like you would end-up in duplicate ID's with what you're trying to achieve. Providing representative sample data will make it much easier for us to understand the problem and provide code that's actually fully working. ... View more

Yes, re-read the text file and ignore the results of the PROC IMPORT.  You can read them one by one or try to use the trick on the other example data step to read all of the files at once into one large dataset.  To read all of the files with one data step they must have the fields in the same order on the lines.  So if the structure has changed over the years you will want to read them one by one (or group the like files together anyway.)   If you write your own data step to read the text files then you can be assured that the variables are all created exactly the same.  This means that you can combine the dataset if you create them separately.  It also means you can prevent variables from being define with the wrong type (numeric or character) or wrong length.   You can use the results of the PROC IMPORT to help you figure out how to define the variables in your program.  But you probably will want to refer to the definition of the variables as published on the source website.  Again some of these fields appear to have only digits in them but they are not NUMBERS.  They are identifiers.  It will probably be useful to define such variables as character.  That is the problem with using PROC IMPORT. A text file has no place to store the attributes of the variables so PROC IMPORT just guesses what to do based the values it checks. ... View more

It looks like your code specifies the NOSAMPLE option in the STRATA statement. This option computes the allocation of the total sample size (among the strata) but doesn't select the sample. Your result is an allocation output data set, which provides the sample sizes for the strata. (The levels of your 2 STRATA variables form 19 strata.)   If you want to select the sample, you can just remove the NOSAMPLE option from the STRATA statement.   ... View more

That's good documentation, and it should be sufficient to write the data step. I note that all the dates seem to be in fact years (numeric, 4 digits). ... View more

The code works and I try to replicate exactly what you show me. My only question is why it did put my variable "STRUCTURE_KIND_043A" in the first column? It's not a big deal I just wanted to understand what part of the code does it. "State_code_001" used to be in the first column   code is: /*This program will select randomly data from the PSC in ID while having a set number for PSC cont. and PSC*/ proc sort data=ID19_PSC out=RBI.ID19PSC_sort; by STRUCTURE_KIND_043A; /*sort by structure type 5=PSC and 6=PSC cont.*/ run;       proc format; /* the STRUCTURE_KIND_043A variable only takes values of 5 and 6 and I want to split into two strata later */ value STRUCTURE_KIND_043Astrata other = '5' 6 = '6'; run; /* this code wants to select 367 from the 5 group and 18 from the 6 */ proc surveyselect data=RBI.ID19PSC_sort out=RBI.ID19PSC_BRsample sampsize=(367 18); strata STRUCTURE_KIND_043A; format STRUCTURE_KIND_043A STRUCTURE_KIND_043Astrata.; run; ... View more