for a character variable, what is the difference between a length statement and a format statement, such as,   Length course $8; Format course $8.;           ... View more

when we use proc export to export a as table to a certain file do we have to specify the file type? such as;   proc export data=score.score_data (where=(gender='f')) outfile='/folders/myfolders/Femalelist2.csv' dbms=csv replace; if we remove .csv from the output file, the file can still open in excel or notepad.   this is similar to a dlm file, proc export data=score.score_data outfile="/folders/myfolders/sd.dat" dbms=dlm replace; delimiter='&'; run; you can remove .dat and open the output sd file with notepad.  proc export data=score.score_data outfile='/folders/myfolders/sd_excel.xls' dbms=XLSX replace; sheet='data'; run;    for xlsx, it does not matter if you add .xls. the output is an excel file.  ... View more

Column and formatted inputs to load a file are similar but different.    When you load the following datasheet test.txt,   Name Sex DOB Weight 12345678901234567890 John  M08/10/202060   For column input Data test.col; infile "path/test.txt"; input name $1-5 sex $6 DOB $7-16 Weight 17-18; run; you will get DOB in character. You can use input to convert the character to numeric of DOB before the calculation with DOB.   But if you use formatted input:   Data test.col; infile "path/test.txt"; input @1 name $5. @6 sex $1. @7 DOB mmddyy10. @17 Weight 2.; run; you will get the numeric DOB.     ... View more

title 'Selected Park Types by Regions'; ods graphics on; proc freq data=pg1.np_codelookup order=freq; tables type*region/nocol crosslist; plots=freqplot(groupby=row scale=grouppercent orient=horizontal); where Type in ('National Historic Site', 'National Monument', 'National Park'); run; title; Has the University Edition SAS Studio disable the plots function? I can run the codes above. OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: ODS statements in the SAS Studio environment may disable some output features. 73 74 title 'Selected Park Types by Regions'; 75 76 ods graphics on; 77 proc freq data=pg1.np_codelookup order=freq; 78 tables type*region/nocol crosslist; 79 plots=freqplot(groupby=row scale=grouppercent orient=horizontal); _____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order.   ... View more

proc sql; create table inner_one As select g.stu_id, score1, score3 from score_data_g as g inner join score_data_ng as ng on g.stu_id=ng.stu_id; /* on score_data_g.stu_id = score_data_ng.stu_id; */ quit; proc sql; create table inner_one As select g.stu_id, score1, score3 from score_data_g as g, score_data_ng as ng /* where g.stu_id=ng.stu_id; */ /* where score_data_g.stu_id = score_data_ng.stu_id; */ where g.stu_id = ng.stu_id; quit;   In two codes above, the on clause in inner join can be replaced by the where clause. But it does not work for outer join (left, right and full join). In both the where clause and the inner join, it seems that order of two datasets does not make different. Does this correct? ... View more

Type Frequency Percent Cumulative Frequency Cumulative Percent NM 63 46.67 63 46.67 NP 51 37.78 114 84.44 NPRE 1 0.74 115 85.19 NS 10 7.41 125 92.59 PRE 3 2.22 128 94.81 PRESERVE 4 2.96 132 97.78 RIVERWAYS 1 0.74 133 98.52 RVR 2 1.48 135 100.00   For level 2 practice of lesson 3, I generated the table above by proc freq. The answer is that NPRE, PRESERVE, and RIVERWAYS are invalid values for Type. I do not understand why. Has anyone worked on the relevant codes?   ... View more