It took some time to wrap my head around this one but  now I think I figured out what is going on. Apparently your raw data has few non-standard characters that sas is having trouble reading .The next column is getting affected  whenever it encounters a funky character.   Example : Peter Bühler   You need to change the encoding while reading the data and see if this works, this works for me . Specify the encoding in the filename.   filename tmp_ '/folders/myfolders/sasuser.v94/test123.csv' ENCODING="WLATIN1"; proc import datafile=tmp_ out=test123 dbms=csv replace; getnames=yes; run; proc freq data=test123; tables Segment / missing; run;   Result :   Segment Frequency Percent Cumulative Consumer 5658 51.75 5658 51.75 Corporate 3264 29.85 8922 81.61 Home Office 2011 18.39 10933 100.00   ... View more

Try this Modified Code :   %LET DSN = SASUSER.MOVIES ; %LET DSN2 = SASUSER.ACTORS; %LET VAR = TITLE ; %LET CLASS_VAR = Rating ; %MACRO stats(dsname); proc means data=&dsname maxdec=0; var &VAR; class &CLASS_VAR; run; %MEND stats; %stats(&DSN) %stats(&DSN2) Issues Identified in your code :   1. Statement not ended with a semi-colon : %LET DSN2 = SASUSER.ACTORS The above has resulted in the error :   ERROR: Open code statement recursion detected.   2.  Invalid Syntax : proc means data=&DSN,&DSN2 You cannot pass multiple dataset names to the proc at the same time ,the syntax is invalid.  You can parameterize the macro and call it twice , each time with a different dataset name in this fashion :   %MACRO stats(dsname); .... ... %Mend; %stats(&DSN) %stats(&DSN2)   ... View more

data problem3; format RtlCost dollar8.0; input ProdNum ProdName$ 6-27 ManuNum PodType$33-43 RtlCost dollar8.0; put (_all_) (=); cards; 5009 Dream Machine 500 Workstation $3,200 4506 Business Machine 450 Workstation $3,345 2101 Travel Laptop 400 Laptop $2,760 2212 Analog Cell Phone 230 Phone $35 4509 Digital Cell Phone 245 Phone $175 5003 Office Phone 560 Phone $145 1110 Spreadsheet Software 134 Software $300 1200 Database Software 113 Software $799 3409 Statistical Software 243 Software $1,899 2102 Wordprocessor Software 245 Software $345 2200 Graphics Software 246 Software $599 ; run;   Log :   26 data problem3; 27 format RtlCost dollar8.0; 28 input ProdNum ProdName$ 6-27 ManuNum PodType$33-43 RtlCost dollar8.0; 29 30 put (_all_) (=); 31 cards; RtlCost=$3,200 ProdNum=5009 ProdName=Dream Machine ManuNum=500 PodType=Workstation RtlCost=$3,345 ProdNum=4506 ProdName=Business Machine ManuNum=450 PodType=Workstation RtlCost=$2,760 ProdNum=2101 ProdName=Travel Laptop ManuNum=400 PodType=Laptop RtlCost=$35 ProdNum=2212 ProdName=Analog Cell Phone ManuNum=230 PodType=Phone RtlCost=$175 ProdNum=4509 ProdName=Digital Cell Phone ManuNum=245 PodType=Phone RtlCost=$145 ProdNum=5003 ProdName=Office Phone ManuNum=560 PodType=Phone RtlCost=$300 ProdNum=1110 ProdName=Spreadsheet Software ManuNum=134 PodType=Software RtlCost=$799 ProdNum=1200 ProdName=Database Software ManuNum=113 PodType=Software RtlCost=$1,899 ProdNum=3409 ProdName=Statistical Software ManuNum=243 PodType=Software RtlCost=$345 ProdNum=2102 ProdName=Wordprocessor Software ManuNum=245 PodType=Software RtlCost=$599 ProdNum=2200 ProdName=Graphics Software ManuNum=246 PodType=Software NOTE: The data set WORK.PROBLEM3 has 11 observations and 5 variables. NOTE: Compressing data set WORK.PROBLEM3 increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. ... View more