Hello I have 3 data sets (each data set contains data about another person). I want to create a new data set that contains information from 3 tables and have following columns: Score   Help_Col1  that will have following values: For person1 : 1  1  1  1  1  1 For person2 : 2  2  2  2  2   2 For person3 : 3  3  3  3 3   3     Help_Col2 that will have following values: for person1: 1   1   1   2   2    2  for person2: 1   1   1   2   2    2 for person3: 1   1   1   2   2    2       Data RawData_Person1; Input Score; Cards; 2 4 6 8 10 12 ; run; Data RawData_Person2; Input Score; Cards; 3 6 9 12 15 18 ; run; Data RawData_Person3; Input Score; Cards; 4 8 12 16 20 24 ; run; data combined1 ; set RawData_Person: indsname = dsn ; subject = scan(dsn,2); run ;   ... View more

Hello I am using SAS enterprise guide 5.1 I want to create a panel of 5 tables (3 side by side tables  and 2 side by side tables)    In the output I don't see side by side tables  ods tagsets.msoffice2k file="path\panels.xls" options(panelcols="3") style=normal; proc print data=sashelp.prdsale(obs=10); var actual predict country region; where country="CANADA"; title "Canada Sales"; run; proc print data=sashelp.prdsale(obs=10); var actual predict country region; where country="U.S.A."; title "USA Sales"; run; proc print data=sashelp.prdsale(obs=10); var actual predict country region; where country="GERMANY"; title "Germany Sales"; run; ods tagsets.msoffice2k options(panelcols="2") ; proc print data=sashelp.prdsale(obs=20); where region="EAST"; title "East Sales"; run; proc print data=sashelp.prdsale(obs=20); where region="WEST"; title "West Sales"; run; ods tagsets.msoffice2k close;   ... View more

Hello In following code the data in excel doesn't includes leading zeros. What is the way to solve it? Why option leading_zero="yes"  is not working? data one; retain zip account; set sashelp.class; zip="06555"; account="0345"; run; ods msoffice2k path="path" (url=none) gpath="pathr" (url=none) file="file4b.xls" options( leading_zero="yes") style=normal; proc print data=one noobs; Title; var zip account; var age height / style(data)={htmlstyle="mso-number-format:'##.00'"}; var weight; run; ods msoffice2k close; ... View more

Hello In following code I export multiple tables to multiple sheets. In sheet1 there will be 2 tables In sheet2 there will be 2 tables My question is how to tell SAS to locate the tables in following location: Sheet1-table1 will be located from cell A1,table2 will be located from cell A15 Sheet2-table1 will be located from cell A1,table2 will be located from cell A15   Title; ods tagsets.excelxp file="path/test1.xls" style=minimal options(sheet_interval="none" sheet_name='Sheet1'); proc print data=sashelp.class(obs=5)noobs; run; proc print data=sashelp.air(obs=5) noobs; run; ods tagsets.excelxp options(sheet_interval="none" sheet_name='Sheet2'); proc print data=sashelp.orsales(obs=5)noobs; run; proc print data=sashelp.prdsale(obs=5)noobs; run; ods tagsets.excelxp close;     ... View more

Hello I want to ask please about a missing value in a char var. In this example there is a missing value in a char var. Why should we use point (.) symbol and not a blank to represent a missing value?   data tbl; length name $ 12; input name $ score1 score2; datalines; Riley 1132 1187 Henderson 1015 1102 . 1018 1027 ; Run; ... View more

Hello I saw this code. May anyone explain please why do they use informat $12.? (why not $10 for example)? May anyone explain please why do they use input pointers +4 and +6?why not other numbers? I see that var name has maximum 9 digits I see that var score1 has 5 digits(included comma) I see that var score2 has 5 digits(included comma)   data scores; input name $12. +4 score1 comma5. +6 score2 comma5.; cards; Riley 1,132 1,187 Henderson 1,015 1,102 ; Run; ... View more

Hello I want to ask how can I create a conditional statement that convert specific variable from char to numeric. As you understand in some cases the variable will be numeric and then no need to transfer. And in other cases  variable will be char and then need to transfer it to numeric. Cases1: Data a; input x $; cards; 1 2 3 ; run; case2: Cases1: Data a; input x ; cards; 1 2 3 ; run;       ... View more