This will do the job   data Daily_call_duration_2; infile " " ; input Sep :date9. dur9 Oct :date9. dur10 Nov :date9. dur11 Dec :date9. dur12; format Sep date9. Oct date9. Nov date9. Dec date9.; array data{*} dur9-dur12; array dif_for_succesive_{3}; array dif_from_sep_{3}; do i=1 to 3; dif_for_succesive_{i}=data{i+1}-data{i}; dif_from_sep_{i}=data{i+1}-data{1}; end; drop i; run; ... View more

This should do the job     data HCA_file (drop = fil); infile " " ; input fil :$1 @ ; if fil = "H" then input #1 @3 Id :$6. State :$4. ; if fil = "C" then input Dates :date9. Transaction :dollar6.2 ; retain ID state Date; if dates = . then delete; format Dates date9.; run;   data HCA_file (drop = fil); infile " " ; input fil :$1 @; if fil = "H" then input Id :$6. State :$4. DOB :date9.; if fil ="C" then delete; format dob date9.; run; ... View more

@GAUTAMDVN wrote: Below is the code  of mine:   DATA _NULL_ ; INFILE CRIME DSD; INPUT City : $18. Population Crime_index Total_crime_index MANM Forcible_rape Robbery Aggravated_assault Burglary Larceny_theft Motor_vehicle_theft Arson ; FILE 'LEARN.CRIME_STATS.TXT' ; RUN ;  and below is the error I'm getting   ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/LEARN.CRIME_STATS.TXT. This whole step serves no purpose. It reads some data from an external file, but does not out that anywhere. Since you have no put statement to write data to the external file named in the file statement, that statement is useless. If you want to read data from an external file into a dataset, you have to name that dataset in the data statement. So you should test this: data want; infile crime dsd; input City : $18. Population Crime_index Total_crime_index MANM Forcible_rape Robbery Aggravated_assault Burglary Larceny_theft Motor_vehicle_theft Arson ; run; and post the log from that.   ... View more

Apologies if you got offended but I didn't mean to insult or to offend someone. I was just asking regarding the pointer control in a healthy way. ... View more