Longfish questions

Longfish answers

• Algorithm to sample groups to match expected proportions
• SAS proc sql to turn 2 columns into 1 column
• Counting number of sequential occurences for a person - SQL
• how to create array with same dimension as another array in SAS
• Select variable only if exists SAS SQL
• Create control dates in bilateral case crossover design
• format macro variable to comma6
• By group processing in SAS
• Count of 2 columns by GROUP BY and catx giving different outputs
• SAS - transpose multiple variables in rows to columns