Hello I am trying to export a sas data set to txt file. proc export data=sashelp.class outfile="/usr/local/SAS/xxxlexample.txt"      dbms=tab replace; putnames=no; run;   When I open the  txt file i see that all data is in one row. I want to export the data and keep same table structure as in original data set.   Thanks Ronekd ... View more

Hello I have the following data set with binary fields C1,C2.....C10.   Data tbl; input ID C1 C2 C3 C4 C5 C6 C7 C8 C9 C10; cards; 111 1 0 0 0 0 0 0 1 1 0 222 0 0 0 0 0 0 0 0 1 1 333 0 1 0 0 0 0 0 0 0 0 444 0 0 0 0 0 0 0 0 0 0 555 0 0 0 0 0 0 1 1 0 1 ; run;   I want to create a new calculated variable that tell us which variables received value 1. For example : For ID  111 the new variable will receive value  C8,C9 For ID  222  the new variable will receive value  C9,C10 For ID  333  the new variable will receive value  C2 For ID  444  the new variable will receive value  'No_Fail' because  none of fields received value 1 For ID  555  the new variable will receive value  C7,C8,C10     Can anyone help to write the code for that? thanks Koein   ... View more

Hello friends I have a question please. I run the following code. I want to display values with % symbol. I want also to add Totals in each column . I want also to add Totals in each Row . I want to modify header "product" to "Product Name". I want to modify header "Actual sales"  to "Sales". Can anyone help to modify the code to get it?   proc tabulate data=sashelp.prdsale; class country product; var actual; table country,product*actual*pctsum/box="Country Name"; run; ... View more

Hello , I know that there is a way to create a primary key to a table using proc sql. for example: PROC SQL; Alter table aaa Add primary key(ID,month); QUIT;   is there a way to add a primary key to a data set by using sas data set and not proc sql? What is the advantage of adding a primary key to a table? Usually when I see SAS programs I don't see that people adding primary key to data sets. But in sql server I usually see that people add primary key to tables. Why?     thanks R         ... View more

Hello Following code below is creating one excel file with one sheet and 4 tables . I want to have 2 sheets and each sheet will have 2 tables. Can anyone fix the code and show how to do it? I just know to add sheet_interval="none"   but when i add it I get  4 sheets with 1 table in each sheet   ods _all_ close; ods tagsets.ExcelXP file="/usr/local/SAS/RON/UserDir/Tbl8.XML" style=Printer options(sheet_name="Sheet1Ron" embedded_titles='yes' embedded_footnotes='yes') ; %macro print_age(age); Proc print data = sashelp.class; Where age = &age. ; title "age : &age." ; footnote1 '*Height in CM'; footnote2 '*Weight in KG'; Run; PROC SQL; create table NoLak as select count(*) as No_Lak from sashelp.class where age = &age. ; QUIT; proc print data=NoLak noobs;run; %mend; %print_age(13); %print_age(16); ods tagsets.ExcelXP close; ... View more