Hi, i have 42 variables with long names in my data. I want to change their names to V1, V2 etc. Instead of writing each of their names is there a quick way to rename them?   Thanks, ... View more

Hi all, I am using below code to draw a bar graph. The total percentage of all groups in the graph is 100%. However I want to get 100% for each group. For example, the total of "5.sinif" should be 100%, the total of "6.sinif" should be 100%. pctlevel statement did not resolve my question. The second graph was populated when I used pctlevel=group. Also, "sinif" below the x category  in the graph is not sorted. How can I sort it? Thank you proc sgplot data=ss; where sinif<9; vbar _3_Ogretmen_Ogrenci/group=sinif stat=percent datalabel groupdisplay=cluster; xaxis label= "3.Ogretmen-ogrenci"; yaxis label= "Yuzde"; run; ... View more

Hi all, I am using the below code to draw a frequency distribution/histogram and getting the graphs as in the attachment. I don't know how I can remove the "cluster=1" or "1" title above the graphs. I am drawing these graphs per cluster but I don't want that information since I am indicating it in the title.   Thanks,             %macro graphs2(g, p,r,a); ods graphics / width=400px height=250px; proc sgpanel data = &g._gr_&a. ; title "Scale Score: &p &r."; panelby cluster / columns = 1 rows=1 uniscale = column novarname; histogram &g._scale_score / transparency=0.25 fillattrs=(color=black) ; label &g._scale_score= 'Scale Score'; rowaxis label= 'Count'; colaxis values=(910 to 945 by 5) valueshint; run; ods graphics / width=400px height=250px; proc sort data=&g._gr_&a. ; by cluster; run; proc sgplot data=&g._gr_&a. PCTLEVEL=BY; title "Proficiency Level:&p &r."; vbar &g._pl / stat=pct transparency=0.25 fillattrs=(color=black) ; yaxis label= 'Percent' ; xaxis label= 'Proficiency Level'; by cluster; run; %mend; %graphs2 (listening,List,1-2,1); ... View more

Hi all, I have a categorical variable in my data. I am trying to draw a bar graph for this variable based on the percents. The below code is working but the sum of percentages is not 100%. I don't know how it is calculating this. Is there an easy way to draw a percentage-based bar graph?   Thank you,   proc sgplot data=alt_listening; title "Proficiency Level: List 1-2"; vbar listening_pl / stat=pct transparency=0.25 fillattrs=(color=black) ; yaxis label= 'Percent' ; xaxis label= 'Proficiency Level'; by cluster_listening; run;   ... View more

Hi all, I am sure there is an easy way to do it but you can see my looong code for a simple proc tabulate. By using this code I am calculating some descriptive statistics for each domain (i.e. listening reading etc.). In the end, I want to put all of them together. So, I'm saving them in my drive then importing (because it is not saving them as a SAS file in the SAS.) them and trying to put them together. The problem is it's only putting the "overall" results which is the last domain in the macro. It's overwriting. How can resolve it? Thanks, ods excel file="C:\Grade\scale_scores\ss_by_gr_&s..xlsx" style=minimal; proc tabulate data=alt_&s. out=ss_by_gr_&s. ; class grade; var &s._scale_score; table &s._scale_score*(format=comma16.) , grade *(N* format=comma16. Mean* f=6.2 Std*f=6.2); run; ods excel close; PROC IMPORT OUT= ss_by_gr_&s. DATAFILE= "C:\Grade\scale_scores\ss_by_gr_&s..xlsx" DBMS=xlsx REPLACE; GETNAMES=YES; RUN; data ss_by_gr_all; set ss_by_gr_&s. ; run; %mend; %part (listening); %part (reading); %part (speaking); %part (writing); %part (oral); %part (literacy); %part (comprehension); %part (overall); ... View more

Hi all, I have a question. I am using the below code to format the total. By using this I am getting percentages with no decimals. However, I want the N counts to have no decimals but the percentages have two decimals. How can I modify it?   Thank you,   proc tabulate data=alt501_main out=gender_grade; class gender grade /missing; table grade (all= 'Total'* format=comma16.) , gender *(N*format=comma16. Rowpctn)(all= 'Total'* format=comma16.); run;   ... View more