ods pdf file="g:\myfolder\filename.pdf"; proc print data=yourdatasetname; run; ods pdf close; If you really need something more powerful like PROC REPORT, then you need to provide (a portion of) the input data as SAS data step code (instructions) and not in any other form. ... View more

can i get this output on this format column first merge with cells    ... View more

I moved your post into here, where you already asked a similar question. Please provide data following my example. ... View more

I moved your post into here, where you already asked a similar question. Please provide data following my example. ... View more

If you need someone to do your work for you, hire soneone. If, while doing your work, you run into a problem, post example data, your code and the log from it. ... View more

I see nothing in your code that does an append. ... View more

@Daily1 wrote: Hi All, Can anyone help me to understand, SAS : Importing multiple excel sheets in a single dataset Regards As others already wrote you need to think of each Excel sheet as a separate table and though you need to write code to combine these tables into one. One of the challenges with Excel as a source: What column attributes you get in SAS (especially type and length) depends on the cell data in the source Excel sheet. So even if all your sheets got the same structure (the same columns) you still could face an issue with the data types and especially the lengths of the columns. Let's say in your first sheet there is a column A with the longest string being a single character then SAS will create a variable A with a length of $1 - but then if in your 2nd sheet in column A there is a string of 2 characters then for this sheet SAS will create a column with a length of $2. If you now combine the first SAS table with the 2nd on then SAS will create a target column with the length as found the first time in the source tables - which could be $1 and which then leads to data truncation (and only a Warning and not an Error in the SAS log).   To get around the length issue what you can do is combine the data via a SQL UNION Corr as with this syntax the length in the target table will be the longest length found in source. Below code generates such SQL syntax. What I haven't addressed in below code is the case where for the "same" column the data type differs between the tables. That would require quite a bit more coding and just demonstrate that Excel isn't an ideal source for any ETL process. /** create sample Excel Workbook with two sheets **/ %let path_on_disk=%sysfunc(pathname(work)); /*%let path_on_disk=c:\temp;*/ libname demo xlsx "&path_on_disk\demo.xlsx"; data demo.class_1; set sashelp.class; run; data demo.class_2; length sex $6; set sashelp.class; if sex='F' then sex='Female'; else sex='Male'; run; data demo.class_3; set sashelp.class; run; libname demo clear; /** read data from all sheets in Excel Workbook and combine into a single table **/ libname demo xlsx "&path_on_disk\demo.xlsx"; /* create list of all sheets in the Excel Workbook */ proc sql; create table source_tables as select cats(libname,'.',memname) as source_table length=41 from dictionary.tables where libname='DEMO' ; quit; /* generate code that concatenates the data into a new table */ filename codegen temp; data _null_; file codegen; set source_tables end=last; if _n_=1 then do; put 'proc sql;' / ' create table want as' / ' select * from ' source_table ; end; else do; put ' union corr all' / ' select * from ' source_table ; end; if last then do; put ' ;'/ 'quit;' ; end; run; /* execute generated code */ %include codegen / source2; filename codegen clear; libname demo clear; ... View more

@Daily1 wrote: Hi All, Can anyone help me to understand, SAS : Importing multiple excel sheets in a single dataset Regards As others already wrote you need to think of each Excel sheet as a separate table and though you need to write code to combine these tables into one. One of the challenges with Excel as a source: What column attributes you get in SAS (especially type and length) depends on the cell data in the source Excel sheet. So even if all your sheets got the same structure (the same columns) you still could face an issue with the data types and especially the lengths of the columns. Let's say in your first sheet there is a column A with the longest string being a single character then SAS will create a variable A with a length of $1 - but then if in your 2nd sheet in column A there is a string of 2 characters then for this sheet SAS will create a column with a length of $2. If you now combine the first SAS table with the 2nd on then SAS will create a target column with the length as found the first time in the source tables - which could be $1 and which then leads to data truncation (and only a Warning and not an Error in the SAS log).   To get around the length issue what you can do is combine the data via a SQL UNION Corr as with this syntax the length in the target table will be the longest length found in source. Below code generates such SQL syntax. What I haven't addressed in below code is the case where for the "same" column the data type differs between the tables. That would require quite a bit more coding and just demonstrate that Excel isn't an ideal source for any ETL process. /** create sample Excel Workbook with two sheets **/ %let path_on_disk=%sysfunc(pathname(work)); /*%let path_on_disk=c:\temp;*/ libname demo xlsx "&path_on_disk\demo.xlsx"; data demo.class_1; set sashelp.class; run; data demo.class_2; length sex $6; set sashelp.class; if sex='F' then sex='Female'; else sex='Male'; run; data demo.class_3; set sashelp.class; run; libname demo clear; /** read data from all sheets in Excel Workbook and combine into a single table **/ libname demo xlsx "&path_on_disk\demo.xlsx"; /* create list of all sheets in the Excel Workbook */ proc sql; create table source_tables as select cats(libname,'.',memname) as source_table length=41 from dictionary.tables where libname='DEMO' ; quit; /* generate code that concatenates the data into a new table */ filename codegen temp; data _null_; file codegen; set source_tables end=last; if _n_=1 then do; put 'proc sql;' / ' create table want as' / ' select * from ' source_table ; end; else do; put ' union corr all' / ' select * from ' source_table ; end; if last then do; put ' ;'/ 'quit;' ; end; run; /* execute generated code */ %include codegen / source2; filename codegen clear; libname demo clear; ... View more

PROC APPEND example https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/p1pyryfvsrne2kn1cv2diraku41o.htm   i want to joint this type of dataset    There are many types of joins. Please explain further. ... View more

B D ... View more

In SAS use an ESTIMATE statement to perform a t-test to test for a difference between the mean number for the first and third branches and the mean number for branch 2. Use alpha = 0.05.   What is your question? ... View more

Regression tutorial (code) https://stats.idre.ucla.edu/sas/webbooks/reg/chapter1/regressionwith-saschapter-1-simple-and-multiple-regression/   Regression tutorial (SAS Studio Task) https://video.sas.com/detail/video/5537540651001/the-linear-regression-task-in-sas%C2%AE-studio?autoStart=true&q=regression   PROC REG documentation - check the example for fully worked examples including code and explanations https://documentation.sas.com/?docsetId=statug&docsetTarget=statug_reg_syntax01.htm&docsetVersion=15.1&locale=en   @Daily1 wrote: data dummy; input time 2. mass :4.; infile datalines; datalines; 0 6.64 1 6.34 2 6.04 4 5.47 6 4.94 8 4.44 10 3.98 12 3.55 14 3.15 16 2.79 18 2.45 20 2.14 22 1.86 24 1.6 26 1.37 28 1.17 30 0.98 35 0.6 40 0.34 45 0.17 50 0.06 ; a)Write the equation of a straight-line model relating the value of the mass of the spill (y) and the time (x). b)Find a 95% confidence interval for the mean mass of all spills with an elapsed time of 15 minutes. Interpret the result c)Find a 95% prediction interval for the mass of a single spill with an elapsed time of 15 minutes. Interpret the result.   ... View more

@Daily1 wrote: proc sql ; select* from emp where hiredate '01-jan-81' and '31-dec-81'; Does not work.   Your Hiredate, read with a date11 informat is a SAS date value. If you are going to compare a SAS date value to a specific value the format is '01JAN81'd or '01JAN2018'd. The quotes plus the trailing D tell SAS you want to use a date literal value.   Comparison of date to string '01-Jan-81'; 223 data junk; 224 x='01Jan1981'd; 225 format x date11.; 226 if x= '01-Jan-81' then put 'Match'; 227 run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 226:9 NOTE: Invalid numeric data, '01-Jan-81' , at line 226 column 9. Second is the incorrect use of 'and' in "hiredate '01-jan-81' and '31-dec-81';" If you want to test if the hiredate is one of either of the values then: hiredate in ( '01-jan-81'd '31-dec-81'd); Though I would suggest ALWAYS using 4 digit years. hiredate in ( '01jan1981'd '31dec1981'd); The way you used 'and' originally only compared Hiredate to the first value.   ... View more