Remove the BY statement.   Worked example: data class; set sashelp.class; keep name age; run; proc transpose data=class out=want; id name; var age; run; @Wolverine wrote: I've assembled some frequency tables into a single file that I am now trying to organize into a table. I'm trying to use Proc Transpose, but all the examples I'm finding have at least 3 variables. My file only has 2 variables: Group COUNT_ROWPERCENT American_Ind_pt 76(0.50%) Asian_pt 635(4.15%) Black_pt 2176(14.21%) Hispanic_pt 1098(7.17%) White_pt 9702(63.36%) missing_pt 1486(9.70%) multi_race_pt 139(0.91%)   Here is my code: PROC TRANSPOSE data=HAVE out=WANT; BY group; ID group; VAR COUNT_ROWPERCENT; RUN; Which produces this:   Group _NAME_ American_Ind_pt Asian_pt Black_pt Hispanic_pt White_pt missing_pt multi_race_pt American_Ind_pt COUNT_ROWPERCENT 76(0.50%)             Asian_pt COUNT_ROWPERCENT   635(4.15%)           Black_pt COUNT_ROWPERCENT     2176(14.21%)         Hispanic_pt COUNT_ROWPERCENT       1098(7.17%)       White_pt COUNT_ROWPERCENT         9702(63.36%)     missing_pt COUNT_ROWPERCENT           1486(9.70%)   multi_race_pt COUNT_ROWPERCENT             139(0.91%)                     When I actually want this: American_Ind_pt Asian_pt Black_pt Hispanic_pt White_pt missing_pt multi_race_pt 76(0.50%) 635(4.15%) 2176(14.21%) 1098(7.17%) 9702(63.36%) 1486(9.70%) 139(0.91%)       ... View more

data new; set oldDataSet; newDate = mdy(month, day, year); format newDate ddmmyy8.; run; Assuming you already have a data set with the day, month, year referencing it with a SET statement instead is what you want to do.    @kimmialex wrote: I used this code, but I have over 8,000 observations. When I use this code, I only see my first three observations. I am sure there is an easier code without putting each dataline in. Thanks for the help   data deaths; input year day month; format new ddmmyy8.; new=mdy(month,day,year); datalines; 1999 1 1 1999 1 2 1999 1 3 ; run;   ... View more

  data MaTable; input Nom $ "A.D.C_EF"n $ Score_biomarqueur Score_pesticides "Q13t"n $ "Q13bist"n $ "Q1.A"n $ "Qt.2"n $; datalines; Doe John 30 1 oui o T i Smith Jane 25 20 oui n T o Brown Alice 35 2 non n T o A C 2 2 non n K j A C 5 23 non n K j B John 10 21 non n K l K C 31 13 oui o K l B Jane 21 4 non o S l ; run; %macro stat_central(); proc sql; select nliteral(name) into :char_vars separated by '|' from dictionary.columns where libname='WORK' and memname="MATABLE" and type='char'; quit; %put &char_vars.; %do k=1 %to %sysfunc(countw(&char_vars., |)); %let char = %scan(&char_vars., &k., |); %put &char.; proc sort data=MATABLE; by &char.; run; proc means data=MATABLE; class &char.; var Score_biomarqueur Score_pesticides; run; %end; %mend; %stat_central();     Use NLITERAL to get the name in a valid naming format. Use a delimiter that is not a space to delimit the list.  Add the delimiter specification to the COUNTW().   But you can also do this using CLASS and a WAYS statement without the loops and use _character_ to reference character variables.   proc means data=MATABLE; class _character_; ways 1; var Score_biomarqueur Score_pesticides; run;         ... View more

Do you have a paid licensed version of SAS? If not, the cloud version is the free one to access, although it's titled academics you can use it as a individual learner.   https://www.sas.com/en_ca/software/on-demand-for-academics.html ... View more