SAS Programming 1: Essentials Case Study

[Ashwini15]

I am currently doing the essentials case study 1 and this was the code I put in:

proc import datafile="/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv"
dbms=csv
out=tsa.claimsimport
replace;
guessingrows=max;
run;

The log however states this with no errors, but states that the table is unable to open:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

72

73 proc import datafile="/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv"

74 dbms=csv

75 out=tsa.claimsimport

76 replace;

77 guessingrows=max;

78 run;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

How can I resolve this.

[Kurt_Bremser]

This NOTE informs you that your SASUSER library was opened in read-only mode (default for most current SAS installations, especially those used for learning). It mentions a parameter catalog, not the dataset you created. This would be mentioned as TSA.CLAIMSIMPORT.DATA.

You can safely ignore the message.

If you still think you have problems, post the whole log (from the start of your proc import down to any message), using this button:

[Ashwini15]

Thank you for this, however when I want to print the data using proc print statement. I get stuck in an infinite loop when i run the programme. Please explain this to me??

[Kurt_Bremser]

If you have lots of observations in your dataset, a proc print output might be too large for your SAS interface (Studio or Enterprise Guide). Just run your import and show us the log from that.

[Ashwini15]

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         proc import datafile="/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv"
 74         dbms=csv
 75         out=tsa.claims_cleaned
 76         replace;
 77         guessingrows=max;
 78         run;
 
 NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to 
 WORK.PARMS.PARMS.SLIST.
 79          /**********************************************************************
 80          *   PRODUCT:   SAS
 81          *   VERSION:   9.4
 82          *   CREATOR:   External File Interface
 83          *   DATE:      04JUN20
 84          *   DESC:      Generated SAS Datastep Code
 85          *   TEMPLATE SOURCE:  (None Specified.)
 86          ***********************************************************************/
 87             data TSA.CLAIMS_CLEANED    ;
 88             %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
 89             infile '/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv' delimiter = ',' MISSOVER DSD lrecl=32767
 89       ! firstobs=2 ;
 90                informat Claim_Number $13. ;
 91                informat Date_Received best32. ;
 92                informat Incident_Date best32. ;
 93                informat Airport_Code $3. ;
 94                informat Airport_Name $48. ;
 95                informat Claim_Type $39. ;
 96                informat Claim_Site $15. ;
 97                informat Item_Category $834. ;
 98                informat Close_Amount best32. ;
 99                informat Disposition $23. ;
 100               informat StateName $17. ;
 101               informat State $2. ;
 102               informat County $20. ;
 103               informat City $33. ;
 104               format Claim_Number $13. ;
 105               format Date_Received best12. ;
 106               format Incident_Date best12. ;
 107               format Airport_Code $3. ;
 108               format Airport_Name $48. ;
 109               format Claim_Type $39. ;
 110               format Claim_Site $15. ;
 111               format Item_Category $834. ;
 112               format Close_Amount best12. ;
 113               format Disposition $23. ;
 114               format StateName $17. ;
 115               format State $2. ;
 116               format County $20. ;
 117               format City $33. ;
 118            input
 119                        Claim_Number  $
 120                        Date_Received
 121                        Incident_Date
 122                        Airport_Code  $
 123                        Airport_Name  $
 124                        Claim_Type  $
 125                        Claim_Site  $
 126                        Item_Category  $
 127                        Close_Amount
 128                        Disposition  $
 129                        StateName  $
 130                        State  $
 131                        County  $
 132                        City  $
 133            ;
 134            if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */
 135            run;
 
 NOTE: The infile '/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv' is:
       Filename=/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv,
       Owner Name=u48548322,Group Name=oda,
       Access Permission=-rw-r--r--,
       Last Modified=04 June 2020 11:09:42,
       File Size (bytes)=35157057
 
 NOTE: 220855 records were read from the infile '/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv'.
       The minimum record length was 23.
       The maximum record length was 994.
 NOTE: The data set TSA.CLAIMS_CLEANED has 220855 observations and 14 variables.
 NOTE: DATA statement used (Total process time):
       real time           1.68 seconds
       user cpu time       0.33 seconds
       system cpu time     0.22 seconds
       memory              12781.40k
       OS Memory           43132.00k
       Timestamp           04/06/2020 11:35:44 AM
       Step Count                        29  Switch Count  1
       Page Faults                       0
       Page Reclaims                     481
       Page Swaps                        0
       Voluntary Context Switches        3152
       Involuntary Context Switches      6
       Block Input Operations            0
       Block Output Operations           463624
       
 
 220855 rows created in TSA.CLAIMS_CLEANED from /home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv.
   
   
   
 NOTE: TSA.CLAIMS_CLEANED data set was successfully created.
 NOTE: The data set TSA.CLAIMS_CLEANED has 220855 observations and 14 variables.
 NOTE: PROCEDURE IMPORT used (Total process time):
       real time           1:35.74
       user cpu time       1:33.99
       system cpu time     0.62 seconds
       memory              12781.40k
       OS Memory           43648.00k
       Timestamp           04/06/2020 11:35:44 AM
       Step Count                        29  Switch Count  8
       Page Faults                       0
       Page Reclaims                     15216
       Page Swaps                        0
       Voluntary Context Switches        3262
       Involuntary Context Switches      115
       Block Input Operations            288
       Block Output Operations           463744
       
 
 136        
 137        
 138        OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 150        

Here is the log I got.

[Kurt_Bremser]

This is your essential clue:

 NOTE: TSA.CLAIMS_CLEANED data set was successfully created.
 NOTE: The data set TSA.CLAIMS_CLEANED has 220855 observations and 14 variables.
 NOTE: PROCEDURE IMPORT used (Total process time):

So the dataset was successfully created.

But if you want to print 200000 lines with possibly considerably large content (those 14 columns might be quite wide), this might overwhelm your front-end (the browser if you use SAS Studio).

[Ashwini15]

• Import the raw data file TSAClaims2002_2017.csv.
• The final data should be in the permanent library tsa, and the data set should be named
claims_cleaned.
• Entirely duplicated records need to be removed from the data set.
• All missing and “-“ values in the columns Claim_Type, Claim_Site, and Disposition must be
changed to Unknown.
• Values in the columns Claim_Type, Claim_Site, and Disposition must follow the requirements in
the data layout.
• All StateName values should be in proper case.
• All State values should be in uppercase.
• You create a new column named Date_Issues with a value of Needs Review to indicate that a
row has a date issue. Date issues consist of the following:
– a missing value for Incident_Date or Date_Received
– an Incident_Date or Date_Received value out of the predefined year range of 2002 through
2017
– an Incident_Date value that occurs after the Date_Received value
• Remove the County and City columns.
• Currency should be permanently formatted with a dollar sign and include two decimal points.
• All dates should be permanently formatted in the style 01JAN2000.
• Permanent labels should be assigned columns by replacing the underscores with a space.
• Final data should be sorted in ascending order by Incident_Date.


I have done the first two bullet points, however when I try to do the subsequent steps it doesnt show anything or I am stuck in an infinite loop.

[Kurt_Bremser]

Please post the code you tried for #3.

[Ashwini15]

I have clicked run and now I am stuck in an infinite loop

[Kurt_Bremser]

Restart your SAS session, and run the steps in order (mark the code and then click submit).