Hi, In my SAS file, the table looks like below (show only 3 variables here). The blank space are missing values. sex age married F  F  M  M      20     20     25     25     30     30             C             C             S             S             X             X Now the task is to add a new column which concatenates all the values across all those character variables, and put the variable name in front of the values. It should be like below. varname sex_F sex_F sex_M sex_M age_20 age_20 age_25 age_25 age_30 age_30 married_C married_C married_S married_S married_X married_X ... View more

I have a simple but tricky work. Basically, individual summary tables for each of the classification variable have been produced as below in SAS: sex   source     pct F     offline    0.288 F     online     0.113 M     offline    0.427 M     online     0.172    married   source     pct  C         offline    0.127 C         online     0.232 S         offline    0.183 S         online     0.134 X         offline    0.038 X         online     0.286   There are over 20 variables like this (e.g., sex, married), and each variable has unknown levels (e.g., 'F', 'M'). Now I need to combine all these small tables and make the final Excel report like below:                offline   online sex       F     0.288    0.113           M     0.427    0.172 married   C     0.127    0.232           S     0.183    0.134           X     0.038    0.286 ... ... ... Many thanks for your help. ... View more

Hi, I intend to select those cases which satisfy: IF regno LIKE ('M%15', 'M%25', 'M%30', 'DISC') THEN OUTPUT; However, this code is wrong. How can I accomplish this? Thanks a lot. ... View more

%macro break(byval);   data work.age_&byval;     set work.sorted(where=(age=&byval));   run; %mend; proc sort data=sashelp.class out=work.sorted;   by age; run; options mprint; data _null_;   set work.sorted;   by age;   if first.age then call execute('%break('||age||')'); run; ... View more

data work.data;   input x $ y $ gender $;   cards;   1 1 F   1 2 M   2 1 F   2 2 F   1 2 M   ; run; I want to use PROC SQL to create a table which has 4 columns: x, y, gender and percentage. The percentage represents: number of cases for each unique combination of x, y and gender, divided by the number of observations. So the result should look like: 1 1 F  0.2 1 2 M 0.4 2 1 F  0.2 2 2 F 0.2 Thanks a lot. ... View more

Hi, I am learing the %input statement by running an example on the SAS's official  site: http://support.sas.com/kb/1/887.html %macro test;   %put enter the data:;   %input getdata;   %put The data you entered is: &getdata; run; %mend test; %test However, this only resulted in an error: ERROR: Requested function is not supported. I did follow the recommendation that: 'The workaround is to run the code within the SAS Program Editor rather than the SAS Enhanced Editor.'. But even so, the error still exists. Do you know what's wrong with the %input statement? Thanks a lot. ... View more

Any idea how I can reorder variables in a dataset?  ... View more