Hi, thanks for helping but no luck SAS log window showing the same error.   ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/LEARN.CRIME_STATS.TXT. ... View more

Hi, The code is correct as per attachment but not able to import the data into SAS by retaining only client_id and State such that A. only transaction data is imported  B. only header data is imported ... View more

Hi, please confirm why I'm wrong in the below code.   DATA X1; INFILE HCA ; INPUT ID $ @; IF ID = 'H' THEN INPUT CLIENT_ID STATE $ DOB : DATE7. ; ELSE IF ID = 'C' THEN INPUT TRANSACTION_DATE : DATE7. PURCHASE : COMMA11.2; FORMAT DOB transaction_date DATE9. PURCHASE DOLLAR11.2 ; RUN ; ... View more

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. ... View more

Hi Paige Miller,   I'm not able to find any relevant logic to write the statements to import the data into SAS because almost in every records there is different type of data but according to the query they've only ID, State, DOB and different purchases. ... View more

Hi, thanks for the help but still not able to solve the part 1 and part 2 where daily usage difference was asked. And also will you please suggest some doc's to understand about arrays more clearly DATA X1 ; INFILE BILL PAD ; INPUT DATE : DATE9. DURATION @@ ; ARRAY DURS{9:12} DUR9-DUR12 ; ARRAY DATES{9:12} SEPT OCT NOV DEC ; ARRAY DURDIFF{10:12} DURDIFF1 DURDIFF2 DURDIFF3 ; DURS{MONTH(DATE)} = DURATION ; DATES{MONTH(DATE)} = DATE ; DURDIFF{MONTH(DATE)} = (DURATION+1) - DURATION ; RUN ; ... View more

Hi, tried to solve the query but not able to do it, will you please help me to confirm where I'm wrong with the code   FILENAME BILL '/folders/myfolders/Assignment 8/Daily_call_duration.txt' ; DATA LEARN.QUES_5 ; INFILE BILL PAD ; INPUT DATE : DATE9. DURATION @@; IF MONTH(DATE) = 9 THEN DO ; SEPT = DATE ; DUR_SEPT = DURATION ; END ; ELSE IF MONTH(DATE) =10 THEN DO ; OCT = DATE ; DUR_OCT = DURATION ; END ; ELSE IF MONTH(DATE) =11 THEN DO ; NOV = DATE ; DUR_NOV = DURATION ; END ; ELSE IF MONTH(DATE) = 12 THEN DO ; DEC = DATE ; DUR_DEC = DURATION ; END ; FORMAT DATE SEPT OCT NOV DEC DATE9. ; DROP DATE ; array dur{4} dur_9-dur_12; /* dur_9 to dur_12 would be read in the input statement */ array diffs{3} diff_10-diff_12; DO I = 1 TO 3 ; DIFFS(I) = DUR(I+1) - DUR(I) ; END ; RUN ; ... 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

FILENAME CALL '/folders/myfolders/Assignment 6/Daily_call_duration.txt' ; DATA QUES_4 ; INFILE CALL PAD; INPUT DATE : DATE9. DURATION @@; IF MONTH(DATE) = 9 THEN SEPT = DATE ; ELSE IF MONTH(DATE) =10 THEN OCT = DATE ; ELSE IF MONTH(DATE) =11 THEN NOV = DATE ; ELSE IF MONTH(DATE) =12 THEN DEC = DATE ; FORMAT DATE SEPT OCT NOV DEC DATE9. ; RUN ; I want 4 new variables but wants only non-missing data w.r.t to each variable and regarding the "daily usage difference for each successive month"  calculation, difference between 1Sep11 - 1Oct11 and so on is required. ... View more