Longfish questions

Longfish answers

• 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
• Dynamic variable names in SAS
• SAS - Creating a dataset regardless of input dataset