I am trying to understand how to use formats and informats to correctly import data from .csv into SAS. I have a practice csv that looks to have been created with SAS in the past. I'm trying to determine how to import all of the columns that contain dates so they maintain the DATETIME19 format they were originally created with. The dates appear exactly like this in the csv: 5/25/2014 8:30     proc import datafile="C:\Users\pc\Documents\SASPractice\chop\visit.csv" dbms=csv out=chop.visit  replace; guessingrows=max; run;   The code above successfully imports the csv and creates a sas datafile. I'm somewhat familiar with SQL, in that you can format each column individually as they come in. I'm sure there's a method to maintain the format of all columns that are imported but am unsure how to build.  ... View more

As a new SAS user, I frequently make mistakes. I am confused on the syntax and usage of the STOP and ABORT functions to halt the progress of the code. When one wants to stop their code from running, do I need to always include these statements at the end of my program just in case?  ... View more

I'm writing a PROC SQL code to full outer join 2 tables. I am somewhat familiar with the syntax in PostgreSQL but am unsure what the naming syntax is when writing a step like this inside PROC SQL. My issue is I get a syntax error on the last line before the run statement at the period between the first diagnosis and DX_KEY. In SAS how is one supposed to identify the primary key matching columns? The chop is the name of the library I created.    ON chop.diagnosis.DX_KEY = chop.visit_diagnosis.DX_KEY; - 22 76 ERROR 22-322: Syntax error,     PROC SQL; CREATE TABLE chop_dx_joined AS Select * FROM chop.diagnosis FULL JOIN chop.visit_diagnosis ON chop.diagnosis.DX_KEY = chop.visit_diagnosis.DX_KEY; run; ... View more

    I am learning SAS with the SAS essentials learning module that has been very helpful thus far. One of the practice questions requries we produce the following code:   proc sort data=pg1.storm_summary out=STORM_SORT; where Basin IN ("NA" "na"); by descending MaxWindMPH; run;   I understand that the above code is creating an output file called STORM_SORT that has certain filters. Based ont he log I got ~400 rows returned.  I'm trying to dig deeper with my understanding and tried a PROC PRINT step  that tries to print the same filtered information as before.   Proc print data=pg1.storm_summary; where Basin IN ("NA" "na"); by descending MaxWindMPH; run;   When I run it only 1 row is returned. I am stumped as to what my error is. Please help point me in the right direction and thank you!  ... View more