data adresses;
infile '/folders/myfolders/Mail.dat';
input Name $ 6. Street $ 18. City $ 9. State $ 6.;
run;
Title 'Addresses_notsorted';
proc print;
run;
proc sort data=adresses out =sortone
sortseq=linguistic (NUMERIC_COLLATION=on);
by street;
run;
proc print data=sortone;
Title ='Addresses_sorted_by_street';
run;
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 data adresses; 74 infile '/folders/myfolders/Mail.dat'; 75 input Name $ 6. Street $ 18. City $ 9. State $ 6.; 76 run; NOTE: The infile '/folders/myfolders/Mail.dat' is: Filename=/folders/myfolders/Mail.dat, Owner Name=sasdemo,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=09Feb2018:21:01:38, File Size (bytes)=162 NOTE: 4 records were read from the infile '/folders/myfolders/Mail.dat'. The minimum record length was 39. The maximum record length was 39. NOTE: The data set WORK.ADRESSES has 4 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 77 Title 'Addresses_notsorted'; 78 proc print; 79 run; NOTE: There were 4 observations read from the data set WORK.ADRESSES. NOTE: PROCEDURE PRINT used (Total process time): real time 0.06 seconds cpu time 0.07 seconds 80 81 proc sort data=adresses out =sortone 82 sortseq=linguistic (NUMERIC_COLLATION=on); 83 by street; 84 run; NOTE: There were 4 observations read from the data set WORK.ADRESSES. NOTE: The data set WORK.SORTONE has 4 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 85 86 proc print data=sortone; 87 Title ='Addresses_sorted_by_street'; _____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 88 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 89 90 91 92 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 105 User: sasdemo Messages: 17 Procedure Statements
Hello everyone,
I had problem printing out the second "Title" which is 'Addresses_sorted_by_Street'
and the LOG showed that it was an invalid statement.
I have checked out on it several times but I did not realize what I had done wrong.
Can anyone give me a suggestion to modify that?
Thank you!
Compare the TITLE statement that worked, vs. the TITLE statement that failed. You'll notice a significant difference.
Compare the TITLE statement that worked, vs. the TITLE statement that failed. You'll notice a significant difference.
I found it.....:p
Thank you!
Did have blind side...
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.