Learning SAS? Welcome to the exclusive online community for all SAS learners.

NIS Database Not Loading In to SAS UE

Reply
Occasional Contributor
Posts: 9

NIS Database Not Loading In to SAS UE

Any one else trying to work with the NIS database? I've had two errors!

 

1) The physical file does not exist (this was resolved with the help of tech support)

 

2) This work does not contain any columns! (UNRESOLVED)

 

I've turned to the forums since IT said they don't support SAS UE programming. I tried scouring the forums for help with that and have tried multiple "solutions" to no avail! Any advice is welcome!

Regular Contributor
Posts: 187

Re: NIS Database Not Loading In to SAS UE

I'm not personally familiar with this database but a quick google search implies it might be very large (greater than 10GB). The error message also implies that there may be some file corruption in your import - putting these two factors together it may be that your data is simply too big for SAS UE to handle.

Super User
Posts: 10,516

Re: NIS Database Not Loading In to SAS UE

1) You should mention which NIS data base. There is more than one.

2) Post log results of your code in a codebox opened with the forum {i} menu icon instead of an attachment.

3) I get a corrupted PDF error from you attachment when attempting to read it.

Occasional Contributor
Posts: 9

Re: NIS Database Not Loading In to SAS UE

I'm trying to start with the NIS National 2014 Core data. H-CUP gives their load program here (it's long): https://www.hcup-us.ahrq.gov/db/nation/nis/tools/pgms/SASLoad_NIS_2014_Core.SAS

 

Here is the code I'm working with for uploading:

 

 

DATA NIS_2014_Core; 
INFILE "/folders/myfolders/All NIS extracted data/NIS 2014/NIS_2014_Core.ASC" LRECL = 547;
run;

 

 

Sorry, you got an error- I had the other users I work with validate it since I originally got an error trying to upload it; I guess I still did it wrong (again, sorry, but this was my first post). 

Regular Contributor
Posts: 187

Re: NIS Database Not Loading In to SAS UE

This https://www.hcup-us.ahrq.gov/db/nation/nis/nisfilespecs.jsp#2014NIS tells me the file has over 7M records and 152 variables - as I said you might be pushing your luck trying to read a file of this size into SAS UE......

Occasional Contributor
Posts: 9

Re: NIS Database Not Loading In to SAS UE

SAS help said it should be possible- just that they don't support SASUE programming help. 

Super User
Posts: 10,516

Re: NIS Database Not Loading In to SAS UE

Infile only points to the file to be read.

You need all of the attrib and input statements as well. Otherwise you basically told SAS: Look and see if that file exists.

Attrib tells SAS what the variable type and length will be. The INPUT statement tells SAS what order the variables appear in the data set, and as done in the NIS code, what format to read the variables with. The INVALUE statements in the Proc format code provide the details on how to treat certain code values, such as -8 when it appears in a field that normally should contain the month of the year (1 to 12)

 

And you should post log of the code you ran, also paste it into a code box to preserve formatting of any error messages.

Occasional Contributor
Posts: 9

Re: NIS Database Not Loading In to SAS UE

You're gonna have to be slow with me, this is only the second time I'm trying to use SASUE and the person who taught me is now in med school on the other side of the country. The code I ran is the same I linked in the previous reply plus the one I included in the format you showed me to post (thanks!). So basically I have all that code from the h-cup link with the only modification being the updated filepath taken directly from the file properties (per SAS tech support help).  

 

Heres the code (I'm just reluctant since it's so long):

 

 

PROC FORMAT;
  INVALUE N2PF
    '-9' = .
    '-8' = .A
    '-6' = .C
    '-5' = .N
    OTHER = (|2.|)
  ;
  INVALUE N3PF
    '-99' = .
    '-88' = .A
    '-66' = .C
    OTHER = (|3.|)
  ;
  INVALUE N4PF
    '-999' = .
    '-888' = .A
    '-666' = .C
    OTHER = (|4.|)
  ;
  INVALUE N4P1F
    '-9.9' = .
    '-8.8' = .A
    '-6.6' = .C
    OTHER = (|4.1|)
  ;
  INVALUE N5PF
    '-9999' = .
    '-8888' = .A
    '-6666' = .C
    OTHER = (|5.|)
  ;
  INVALUE N5P2F
    '-9.99' = .
    '-8.88' = .A
    '-6.66' = .C
    OTHER = (|5.2|)
  ;
  INVALUE N6PF
    '-99999' = .
    '-88888' = .A
    '-66666' = .C
    OTHER = (|6.|)
  ;
  INVALUE N6P2F
    '-99.99' = .
    '-88.88' = .A
    '-66.66' = .C
    OTHER = (|6.2|)
  ;
  INVALUE N7P2F
    '-999.99' = .
    '-888.88' = .A
    '-666.66' = .C
    OTHER = (|7.2|)
  ;
  INVALUE N8PF
    '-9999999' = .
    '-8888888' = .A
    '-6666666' = .C
    OTHER = (|8.|)
  ;
  INVALUE N8P2F
    '-9999.99' = .
    '-8888.88' = .A
    '-6666.66' = .C
    OTHER = (|8.2|)
  ;
  INVALUE N8P4F
    '-99.9999' = .
    '-88.8888' = .A
    '-66.6666' = .C
    OTHER = (|8.4|)
  ;
  INVALUE N10PF
    '-999999999' = .
    '-888888888' = .A
    '-666666666' = .C
    OTHER = (|10.|)
  ;
  INVALUE N10P4F
    '-9999.9999' = .
    '-8888.8888' = .A
    '-6666.6666' = .C
    OTHER = (|10.4|)
  ;
  INVALUE N10P5F
    '-999.99999' = .
    '-888.88888' = .A
    '-666.66666' = .C
    OTHER = (|10.5|)
  ;
  INVALUE DATE10F
    '-999999999' = .
    '-888888888' = .A
    '-666666666' = .C
    OTHER = (|MMDDYY10.|)
  ;
  INVALUE N11P7F
    '-99.9999999' = .
    '-88.8888888' = .A
    '-66.6666666' = .C
    OTHER = (|11.7|)
  ;
  INVALUE N12P2F
    '-99999999.99' = .
    '-88888888.88' = .A
    '-66666666.66' = .C
    OTHER = (|12.2|)
  ;
  INVALUE N12P5F
    '-99999.99999' = .
    '-88888.88888' = .A
    '-66666.66666' = .C
    OTHER = (|12.5|)
  ;
  INVALUE N13PF
    '-999999999999' = .
    '-888888888888' = .A
    '-666666666666' = .C
    OTHER = (|13.|)
  ;
  INVALUE N15P2F
    '-99999999999.99' = .
    '-88888888888.88' = .A
    '-66666666666.66' = .C
    OTHER = (|15.2|)
  ;
RUN;

*** Data Step to load the file ***;
DATA NIS_2014_Core; 
INFILE 'NIS_2014_Core.ASC' LRECL = 547;

*** Define data element attributes ***;
ATTRIB 
  AGE                        LENGTH=3
  LABEL="Age in years at admission"

  AGE_NEONATE                LENGTH=3
  LABEL="Neonatal age (first 28 days after birth) indicator"

  AMONTH                     LENGTH=3
  LABEL="Admission month"

  AWEEKEND                   LENGTH=3
  LABEL="Admission day is a weekend"

  DIED                       LENGTH=3
  LABEL="Died during hospitalization"

  DISCWT                     LENGTH=8
  LABEL="NIS discharge weight"

  DISPUNIFORM                LENGTH=3
  LABEL="Disposition of patient (uniform)"

  DQTR                       LENGTH=3
  LABEL="Discharge quarter"

  DRG                        LENGTH=3
  LABEL="DRG in effect on discharge date"

  DRG24                      LENGTH=3
  LABEL="DRG, version 24"

  DRGVER                     LENGTH=3
  LABEL="DRG grouper version used on discharge date"

  DRG_NoPOA                  LENGTH=3
  LABEL="DRG in use on discharge date, calculated without POA"

  DX1                        LENGTH=$5
  LABEL="Diagnosis 1"

  DX2                        LENGTH=$5
  LABEL="Diagnosis 2"

  DX3                        LENGTH=$5
  LABEL="Diagnosis 3"

  DX4                        LENGTH=$5
  LABEL="Diagnosis 4"

  DX5                        LENGTH=$5
  LABEL="Diagnosis 5"

  DX6                        LENGTH=$5
  LABEL="Diagnosis 6"

  DX7                        LENGTH=$5
  LABEL="Diagnosis 7"

  DX8                        LENGTH=$5
  LABEL="Diagnosis 8"

  DX9                        LENGTH=$5
  LABEL="Diagnosis 9"

  DX10                       LENGTH=$5
  LABEL="Diagnosis 10"

  DX11                       LENGTH=$5
  LABEL="Diagnosis 11"

  DX12                       LENGTH=$5
  LABEL="Diagnosis 12"

  DX13                       LENGTH=$5
  LABEL="Diagnosis 13"

  DX14                       LENGTH=$5
  LABEL="Diagnosis 14"

  DX15                       LENGTH=$5
  LABEL="Diagnosis 15"

  DX16                       LENGTH=$5
  LABEL="Diagnosis 16"

  DX17                       LENGTH=$5
  LABEL="Diagnosis 17"

  DX18                       LENGTH=$5
  LABEL="Diagnosis 18"

  DX19                       LENGTH=$5
  LABEL="Diagnosis 19"

  DX20                       LENGTH=$5
  LABEL="Diagnosis 20"

  DX21                       LENGTH=$5
  LABEL="Diagnosis 21"

  DX22                       LENGTH=$5
  LABEL="Diagnosis 22"

  DX23                       LENGTH=$5
  LABEL="Diagnosis 23"

  DX24                       LENGTH=$5
  LABEL="Diagnosis 24"

  DX25                       LENGTH=$5
  LABEL="Diagnosis 25"

  DX26                       LENGTH=$5
  LABEL="Diagnosis 26"

  DX27                       LENGTH=$5
  LABEL="Diagnosis 27"

  DX28                       LENGTH=$5
  LABEL="Diagnosis 28"

  DX29                       LENGTH=$5
  LABEL="Diagnosis 29"

  DX30                       LENGTH=$5
  LABEL="Diagnosis 30"

  DXCCS1                     LENGTH=3
  LABEL="CCS: diagnosis 1"

  DXCCS2                     LENGTH=3
  LABEL="CCS: diagnosis 2"

  DXCCS3                     LENGTH=3
  LABEL="CCS: diagnosis 3"

  DXCCS4                     LENGTH=3
  LABEL="CCS: diagnosis 4"

  DXCCS5                     LENGTH=3
  LABEL="CCS: diagnosis 5"

  DXCCS6                     LENGTH=3
  LABEL="CCS: diagnosis 6"

  DXCCS7                     LENGTH=3
  LABEL="CCS: diagnosis 7"

  DXCCS8                     LENGTH=3
  LABEL="CCS: diagnosis 8"

  DXCCS9                     LENGTH=3
  LABEL="CCS: diagnosis 9"

  DXCCS10                    LENGTH=3
  LABEL="CCS: diagnosis 10"

  DXCCS11                    LENGTH=3
  LABEL="CCS: diagnosis 11"

  DXCCS12                    LENGTH=3
  LABEL="CCS: diagnosis 12"

  DXCCS13                    LENGTH=3
  LABEL="CCS: diagnosis 13"

  DXCCS14                    LENGTH=3
  LABEL="CCS: diagnosis 14"

  DXCCS15                    LENGTH=3
  LABEL="CCS: diagnosis 15"

  DXCCS16                    LENGTH=3
  LABEL="CCS: diagnosis 16"

  DXCCS17                    LENGTH=3
  LABEL="CCS: diagnosis 17"

  DXCCS18                    LENGTH=3
  LABEL="CCS: diagnosis 18"

  DXCCS19                    LENGTH=3
  LABEL="CCS: diagnosis 19"

  DXCCS20                    LENGTH=3
  LABEL="CCS: diagnosis 20"

  DXCCS21                    LENGTH=3
  LABEL="CCS: diagnosis 21"

  DXCCS22                    LENGTH=3
  LABEL="CCS: diagnosis 22"

  DXCCS23                    LENGTH=3
  LABEL="CCS: diagnosis 23"

  DXCCS24                    LENGTH=3
  LABEL="CCS: diagnosis 24"

  DXCCS25                    LENGTH=3
  LABEL="CCS: diagnosis 25"

  DXCCS26                    LENGTH=3
  LABEL="CCS: diagnosis 26"

  DXCCS27                    LENGTH=3
  LABEL="CCS: diagnosis 27"

  DXCCS28                    LENGTH=3
  LABEL="CCS: diagnosis 28"

  DXCCS29                    LENGTH=3
  LABEL="CCS: diagnosis 29"

  DXCCS30                    LENGTH=3
  LABEL="CCS: diagnosis 30"

  ECODE1                     LENGTH=$5
  LABEL="E code 1"

  ECODE2                     LENGTH=$5
  LABEL="E code 2"

  ECODE3                     LENGTH=$5
  LABEL="E code 3"

  ECODE4                     LENGTH=$5
  LABEL="E code 4"

  ELECTIVE                   LENGTH=3
  LABEL="Elective versus non-elective admission"

  E_CCS1                     LENGTH=3
  LABEL="CCS: E Code 1"

  E_CCS2                     LENGTH=3
  LABEL="CCS: E Code 2"

  E_CCS3                     LENGTH=3
  LABEL="CCS: E Code 3"

  E_CCS4                     LENGTH=3
  LABEL="CCS: E Code 4"

  FEMALE                     LENGTH=3
  LABEL="Indicator of sex"

  HCUP_ED                    LENGTH=3
  LABEL="HCUP Emergency Department service indicator"

  HOSPBRTH                   LENGTH=3
  LABEL="Indicator of birth in this hospital"

  HOSP_DIVISION              LENGTH=3            FORMAT=2.
  LABEL="Census Division of hospital"

  HOSP_NIS                   LENGTH=4            FORMAT=5.
  LABEL="NIS hospital number"

  KEY_NIS                    LENGTH=5            FORMAT=8.
  LABEL="NIS record number"

  LOS                        LENGTH=4
  LABEL="Length of stay (cleaned)"

  MDC                        LENGTH=3
  LABEL="MDC in effect on discharge date"

  MDC24                      LENGTH=3
  LABEL="MDC, version 24"

  MDC_NoPOA                  LENGTH=3
  LABEL="MDC in use on discharge date, calculated without POA"

  NCHRONIC                   LENGTH=3
  LABEL="Number of chronic conditions"

  NDX                        LENGTH=3
  LABEL="Number of diagnoses on this record"

  NECODE                     LENGTH=3
  LABEL="Number of E codes on this record"

  NEOMAT                     LENGTH=3
  LABEL="Neonatal and/or maternal DX and/or PR"

  NIS_STRATUM                LENGTH=4            FORMAT=4.
  LABEL="NIS hospital stratum"

  NPR                        LENGTH=3
  LABEL="Number of procedures on this record"

  ORPROC                     LENGTH=3
  LABEL="Major operating room procedure indicator"

  PAY1                       LENGTH=3
  LABEL="Primary expected payer (uniform)"

  PL_NCHS                    LENGTH=3
  LABEL="Patient Location: NCHS Urban-Rural Code"

  PR1                        LENGTH=$4
  LABEL="Procedure 1"

  PR2                        LENGTH=$4
  LABEL="Procedure 2"

  PR3                        LENGTH=$4
  LABEL="Procedure 3"

  PR4                        LENGTH=$4
  LABEL="Procedure 4"

  PR5                        LENGTH=$4
  LABEL="Procedure 5"

  PR6                        LENGTH=$4
  LABEL="Procedure 6"

  PR7                        LENGTH=$4
  LABEL="Procedure 7"

  PR8                        LENGTH=$4
  LABEL="Procedure 8"

  PR9                        LENGTH=$4
  LABEL="Procedure 9"

  PR10                       LENGTH=$4
  LABEL="Procedure 10"

  PR11                       LENGTH=$4
  LABEL="Procedure 11"

  PR12                       LENGTH=$4
  LABEL="Procedure 12"

  PR13                       LENGTH=$4
  LABEL="Procedure 13"

  PR14                       LENGTH=$4
  LABEL="Procedure 14"

  PR15                       LENGTH=$4
  LABEL="Procedure 15"

  PRCCS1                     LENGTH=3
  LABEL="CCS: procedure 1"

  PRCCS2                     LENGTH=3
  LABEL="CCS: procedure 2"

  PRCCS3                     LENGTH=3
  LABEL="CCS: procedure 3"

  PRCCS4                     LENGTH=3
  LABEL="CCS: procedure 4"

  PRCCS5                     LENGTH=3
  LABEL="CCS: procedure 5"

  PRCCS6                     LENGTH=3
  LABEL="CCS: procedure 6"

  PRCCS7                     LENGTH=3
  LABEL="CCS: procedure 7"

  PRCCS8                     LENGTH=3
  LABEL="CCS: procedure 8"

  PRCCS9                     LENGTH=3
  LABEL="CCS: procedure 9"

  PRCCS10                    LENGTH=3
  LABEL="CCS: procedure 10"

  PRCCS11                    LENGTH=3
  LABEL="CCS: procedure 11"

  PRCCS12                    LENGTH=3
  LABEL="CCS: procedure 12"

  PRCCS13                    LENGTH=3
  LABEL="CCS: procedure 13"

  PRCCS14                    LENGTH=3
  LABEL="CCS: procedure 14"

  PRCCS15                    LENGTH=3
  LABEL="CCS: procedure 15"

  PRDAY1                     LENGTH=4
  LABEL="Number of days from admission to PR1"

  PRDAY2                     LENGTH=4
  LABEL="Number of days from admission to PR2"

  PRDAY3                     LENGTH=4
  LABEL="Number of days from admission to PR3"

  PRDAY4                     LENGTH=4
  LABEL="Number of days from admission to PR4"

  PRDAY5                     LENGTH=4
  LABEL="Number of days from admission to PR5"

  PRDAY6                     LENGTH=4
  LABEL="Number of days from admission to PR6"

  PRDAY7                     LENGTH=4
  LABEL="Number of days from admission to PR7"

  PRDAY8                     LENGTH=4
  LABEL="Number of days from admission to PR8"

  PRDAY9                     LENGTH=4
  LABEL="Number of days from admission to PR9"

  PRDAY10                    LENGTH=4
  LABEL="Number of days from admission to PR10"

  PRDAY11                    LENGTH=4
  LABEL="Number of days from admission to PR11"

  PRDAY12                    LENGTH=4
  LABEL="Number of days from admission to PR12"

  PRDAY13                    LENGTH=4
  LABEL="Number of days from admission to PR13"

  PRDAY14                    LENGTH=4
  LABEL="Number of days from admission to PR14"

  PRDAY15                    LENGTH=4
  LABEL="Number of days from admission to PR15"

  RACE                       LENGTH=3
  LABEL="Race (uniform)"

  SERVICELINE                LENGTH=3
  LABEL="Hospital Service Line"

  TOTCHG                     LENGTH=6
  LABEL="Total charges (cleaned)"

  TRAN_IN                    LENGTH=3
  LABEL="Transfer in indicator"

  TRAN_OUT                   LENGTH=3
  LABEL="Transfer out indicator"

  YEAR                       LENGTH=3
  LABEL="Calendar year"

  ZIPINC_QRTL                LENGTH=3
  LABEL="Median household income national quartile for patient ZIP Code"
  ;

*** Read data elements from the ASCII file ***;
INPUT 
      @1      AGE                      N3PF.
      @4      AGE_NEONATE              N2PF.
      @6      AMONTH                   N2PF.
      @8      AWEEKEND                 N2PF.
      @10     DIED                     N2PF.
      @12     DISCWT                   N11P7F.
      @23     DISPUNIFORM              N2PF.
      @25     DQTR                     N2PF.
      @27     DRG                      N3PF.
      @30     DRG24                    N3PF.
      @33     DRGVER                   N2PF.
      @35     DRG_NoPOA                N3PF.
      @38     DX1                      $CHAR5.
      @43     DX2                      $CHAR5.
      @48     DX3                      $CHAR5.
      @53     DX4                      $CHAR5.
      @58     DX5                      $CHAR5.
      @63     DX6                      $CHAR5.
      @68     DX7                      $CHAR5.
      @73     DX8                      $CHAR5.
      @78     DX9                      $CHAR5.
      @83     DX10                     $CHAR5.
      @88     DX11                     $CHAR5.
      @93     DX12                     $CHAR5.
      @98     DX13                     $CHAR5.
      @103    DX14                     $CHAR5.
      @108    DX15                     $CHAR5.
      @113    DX16                     $CHAR5.
      @118    DX17                     $CHAR5.
      @123    DX18                     $CHAR5.
      @128    DX19                     $CHAR5.
      @133    DX20                     $CHAR5.
      @138    DX21                     $CHAR5.
      @143    DX22                     $CHAR5.
      @148    DX23                     $CHAR5.
      @153    DX24                     $CHAR5.
      @158    DX25                     $CHAR5.
      @163    DX26                     $CHAR5.
      @168    DX27                     $CHAR5.
      @173    DX28                     $CHAR5.
      @178    DX29                     $CHAR5.
      @183    DX30                     $CHAR5.
      @188    DXCCS1                   N3PF.
      @191    DXCCS2                   N3PF.
      @194    DXCCS3                   N3PF.
      @197    DXCCS4                   N3PF.
      @200    DXCCS5                   N3PF.
      @203    DXCCS6                   N3PF.
      @206    DXCCS7                   N3PF.
      @209    DXCCS8                   N3PF.
      @212    DXCCS9                   N3PF.
      @215    DXCCS10                  N3PF.
      @218    DXCCS11                  N3PF.
      @221    DXCCS12                  N3PF.
      @224    DXCCS13                  N3PF.
      @227    DXCCS14                  N3PF.
      @230    DXCCS15                  N3PF.
      @233    DXCCS16                  N3PF.
      @236    DXCCS17                  N3PF.
      @239    DXCCS18                  N3PF.
      @242    DXCCS19                  N3PF.
      @245    DXCCS20                  N3PF.
      @248    DXCCS21                  N3PF.
      @251    DXCCS22                  N3PF.
      @254    DXCCS23                  N3PF.
      @257    DXCCS24                  N3PF.
      @260    DXCCS25                  N3PF.
      @263    DXCCS26                  N3PF.
      @266    DXCCS27                  N3PF.
      @269    DXCCS28                  N3PF.
      @272    DXCCS29                  N3PF.
      @275    DXCCS30                  N3PF.
      @278    ECODE1                   $CHAR5.
      @283    ECODE2                   $CHAR5.
      @288    ECODE3                   $CHAR5.
      @293    ECODE4                   $CHAR5.
      @298    ELECTIVE                 N2PF.
      @300    E_CCS1                   N4PF.
      @304    E_CCS2                   N4PF.
      @308    E_CCS3                   N4PF.
      @312    E_CCS4                   N4PF.
      @316    FEMALE                   N2PF.
      @318    HCUP_ED                  N3PF.
      @321    HOSPBRTH                 N2PF.
      @323    HOSP_DIVISION            N2PF.
      @325    HOSP_NIS                 N5PF.
      @330    KEY_NIS                  N10PF.
      @340    LOS                      N5PF.
      @345    MDC                      N2PF.
      @347    MDC24                    N2PF.
      @349    MDC_NoPOA                N2PF.
      @351    NCHRONIC                 N2PF.
      @353    NDX                      N2PF.
      @355    NECODE                   N3PF.
      @358    NEOMAT                   N2PF.
      @360    NIS_STRATUM              N4PF.
      @364    NPR                      N2PF.
      @366    ORPROC                   N2PF.
      @368    PAY1                     N2PF.
      @370    PL_NCHS                  N3PF.
      @373    PR1                      $CHAR4.
      @377    PR2                      $CHAR4.
      @381    PR3                      $CHAR4.
      @385    PR4                      $CHAR4.
      @389    PR5                      $CHAR4.
      @393    PR6                      $CHAR4.
      @397    PR7                      $CHAR4.
      @401    PR8                      $CHAR4.
      @405    PR9                      $CHAR4.
      @409    PR10                     $CHAR4.
      @413    PR11                     $CHAR4.
      @417    PR12                     $CHAR4.
      @421    PR13                     $CHAR4.
      @425    PR14                     $CHAR4.
      @429    PR15                     $CHAR4.
      @433    PRCCS1                   N3PF.
      @436    PRCCS2                   N3PF.
      @439    PRCCS3                   N3PF.
      @442    PRCCS4                   N3PF.
      @445    PRCCS5                   N3PF.
      @448    PRCCS6                   N3PF.
      @451    PRCCS7                   N3PF.
      @454    PRCCS8                   N3PF.
      @457    PRCCS9                   N3PF.
      @460    PRCCS10                  N3PF.
      @463    PRCCS11                  N3PF.
      @466    PRCCS12                  N3PF.
      @469    PRCCS13                  N3PF.
      @472    PRCCS14                  N3PF.
      @475    PRCCS15                  N3PF.
      @478    PRDAY1                   N3PF.
      @481    PRDAY2                   N3PF.
      @484    PRDAY3                   N3PF.
      @487    PRDAY4                   N3PF.
      @490    PRDAY5                   N3PF.
      @493    PRDAY6                   N3PF.
      @496    PRDAY7                   N3PF.
      @499    PRDAY8                   N3PF.
      @502    PRDAY9                   N3PF.
      @505    PRDAY10                  N3PF.
      @508    PRDAY11                  N3PF.
      @511    PRDAY12                  N3PF.
      @514    PRDAY13                  N3PF.
      @517    PRDAY14                  N3PF.
      @520    PRDAY15                  N3PF.
      @523    RACE                     N2PF.
      @525    SERVICELINE              N3PF.
      @528    TOTCHG                   N10PF.
      @538    TRAN_IN                  N2PF.
      @540    TRAN_OUT                 N2PF.
      @542    YEAR                     N4PF.
      @546    ZIPINC_QRTL              N2PF.
      ;
RUN;

 

 

 

Super User
Super User
Posts: 6,502

Re: NIS Database Not Loading In to SAS UE

[ Edited ]

I cannot see your PDF file as it appears to be corrupt.

With HCUP NIS programs make sure the filename the program is reading matches the file name of the data file. They use mixed case filename and SAS UE is running on Unix which uses case senstive file names.

DATA NIS_2014_Core; 
INFILE 'NIS_2014_Core.ASC' LRECL = 547;

If you are having trouble with the size of the generated data set make sure to write it a library other than WORK. That way you can use the disk space on your PC to store the file instead of the disk space in the virtural machine.

libname out '/folders/myfolders/nis_2014';
DATA out.NIS_2014_Core; 
INFILE '/folders/myfolders/nis_2014/NIS_2014_Core.ASC' LRECL = 547;
...

Here are the sizes on the 2014 data files on my Linux system.

[data/hcup_nis/2014/raw]->du -hs --apparent-size *.sas7bdat
192K	ccratio.sas7bdat
3.8G	nis_2014_core.sas7bdat
1.8G	nis_2014_dx_pr_grps.sas7bdat
320K	nis_2014_hospital.sas7bdat
731M	nis_2014_severity.sas7bdat
[data/hcup_nis/2014/raw]->
Occasional Contributor
Posts: 9

Re: NIS Database Not Loading In to SAS UE

Hi!

 

I responded to the post above yours with the exact file path I've been using (since that user also pointed out it was corrupt, whoops!). That file path is taken directly from the file property (which was the directions of SAS tech support). 

Super User
Super User
Posts: 6,502

Re: NIS Database Not Loading In to SAS UE

 

Like I said before you should add a LIBNAME statement and change the DATA statement to use a two level dataset name.

 

You need to show the error you are getting so we know if it is a syntax error, data error or space issues.

 

Occasional Contributor
Posts: 9

Re: NIS Database Not Loading In to SAS UE

libname yanglab "/folders/myfolders";
run;

PROC FORMAT;
  INVALUE N2PF
    '-9' = .
    '-8' = .A
    '-6' = .C
    '-5' = .N
    OTHER = (|2.|)
  ;
  INVALUE N3PF
    '-99' = .
    '-88' = .A
    '-66' = .C
    OTHER = (|3.|)
  ;
  INVALUE N4PF
    '-999' = .
    '-888' = .A
    '-666' = .C
    OTHER = (|4.|)
  ;
  INVALUE N4P1F
    '-9.9' = .
    '-8.8' = .A
    '-6.6' = .C
    OTHER = (|4.1|)
  ;
  INVALUE N5PF
    '-9999' = .
    '-8888' = .A
    '-6666' = .C
    OTHER = (|5.|)
  ;
  INVALUE N5P2F
    '-9.99' = .
    '-8.88' = .A
    '-6.66' = .C
    OTHER = (|5.2|)
  ;
  INVALUE N6PF
    '-99999' = .
    '-88888' = .A
    '-66666' = .C
    OTHER = (|6.|)
  ;
  INVALUE N6P2F
    '-99.99' = .
    '-88.88' = .A
    '-66.66' = .C
    OTHER = (|6.2|)
  ;
  INVALUE N7P2F
    '-999.99' = .
    '-888.88' = .A
    '-666.66' = .C
    OTHER = (|7.2|)
  ;
  INVALUE N8PF
    '-9999999' = .
    '-8888888' = .A
    '-6666666' = .C
    OTHER = (|8.|)
  ;
  INVALUE N8P2F
    '-9999.99' = .
    '-8888.88' = .A
    '-6666.66' = .C
    OTHER = (|8.2|)
  ;
  INVALUE N8P4F
    '-99.9999' = .
    '-88.8888' = .A
    '-66.6666' = .C
    OTHER = (|8.4|)
  ;
  INVALUE N10PF
    '-999999999' = .
    '-888888888' = .A
    '-666666666' = .C
    OTHER = (|10.|)
  ;
  INVALUE N10P4F
    '-9999.9999' = .
    '-8888.8888' = .A
    '-6666.6666' = .C
    OTHER = (|10.4|)
  ;
  INVALUE N10P5F
    '-999.99999' = .
    '-888.88888' = .A
    '-666.66666' = .C
    OTHER = (|10.5|)
  ;
  INVALUE DATE10F
    '-999999999' = .
    '-888888888' = .A
    '-666666666' = .C
    OTHER = (|MMDDYY10.|)
  ;
  INVALUE N11P7F
    '-99.9999999' = .
    '-88.8888888' = .A
    '-66.6666666' = .C
    OTHER = (|11.7|)
  ;
  INVALUE N12P2F
    '-99999999.99' = .
    '-88888888.88' = .A
    '-66666666.66' = .C
    OTHER = (|12.2|)
  ;
  INVALUE N12P5F
    '-99999.99999' = .
    '-88888.88888' = .A
    '-66666.66666' = .C
    OTHER = (|12.5|)
  ;
  INVALUE N13PF
    '-999999999999' = .
    '-888888888888' = .A
    '-666666666666' = .C
    OTHER = (|13.|)
  ;
  INVALUE N15P2F
    '-99999999999.99' = .
    '-88888888888.88' = .A
    '-66666666666.66' = .C
    OTHER = (|15.2|)
  ;
RUN;

DATA NIS_2014_Core; 
INFILE "/folders/myfolders/All NIS extracted data/NIS 2014/NIS_2014_Core.ASC" LRECL = 547;

libname yanglab "/folders/myfolders";
data yanglab.NIS_2014_Core.ASC;
	set a;
run;

Hi Tim, 

 

Here's the libname statement I've been using. Apologies for not including it earlier- I thought it would be assumed I was using that already. Can you explain to me what a DATA statement with a two level dataset name is? I'm afraid I'm having trouble understanding what the formal definition is trying to say on the SAS user guides. Also that corrupted PDF was of the error message I've been getting- I'm having trouble uploading into the forum since it needs to be in a certain format. 

Occasional Contributor
Posts: 9

Re: NIS Database Not Loading In to SAS UE

Still having trouble with uploading the proper format for the screenshot- but it pops up in a SAS Studio window 

 

"The table "YANGLAB.NIS_2014_CORE" cannot be opened because it does not contain any columns."

Super User
Posts: 10,516

Re: NIS Database Not Loading In to SAS UE

Your code should look a bit more like this:

libname yanglab "/folders/myfolders";

DATA yanglab.NIS_2014_Core; 
INFILE "/folders/myfolders/All NIS extracted data/NIS 2014/NIS_2014_Core.ASC" LRECL = 547;
<attrib and input statements>

run;

You should have gotten at least one error from

 

data yanglab.NIS_2014_Core.ASC;

As yanglab.NIS_2014_Core.ASC is not a legal SAS data set name. The second . is right out.

 

And you have gotten several request to post a LOG. The LOG will have indications of syntax issues, missing files, data sets created with 0 observations and lots of other helpful information. At this point we still do not know the ACTUAL code you are running because what you are pasting fairly obviously is not comming from the log as the data step to read the file would have some information about the number of records read from the external file and how much was used if there were no errors. If there were errors then they would be in the middle of the data step code.

 

Please look at this log:

409  data work.want;
410     infile 'sometext';
411  run;

ERROR: Physical file does not exist, D:\Data\WORK\SASTemp\_TD90212_CWPP0173_\sometext.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.WANT may be incomplete.  When this step was stopped there were 0
         observations and 0 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


in this case the text file to read does not exist. There were no instructions to read any variables (INPUT statement). However a data set by the name work.want WAS created, it has no observations and no variables. Which causes the error message you mention. I'm working in Base SAS but can generate messages like:

 

NOTE: No variables in data set WORK.WANT.

or similar.

 

So PLEASE show a log where you include the attrib and inputstatements and any messages related to running that data step to read the file.

Occasional Contributor
Posts: 9

Re: NIS Database Not Loading In to SAS UE

libname yanglab "/folders/myfolders";

DATA yanglab.NIS_2014_Core; 
INFILE "/folders/myfolders/All NIS extracted data/NIS 2014/NIS_2014_Core.ASC" LRECL = 547;
run;

PROC FORMAT; INVALUE N2PF '-9' = . '-8' = .A '-6' = .C '-5' = .N OTHER = (|2.|) ; INVALUE N3PF '-99' = . '-88' = .A '-66' = .C OTHER = (|3.|) ; INVALUE N4PF '-999' = . '-888' = .A '-666' = .C OTHER = (|4.|) ; INVALUE N4P1F '-9.9' = . '-8.8' = .A '-6.6' = .C OTHER = (|4.1|) ; INVALUE N5PF '-9999' = . '-8888' = .A '-6666' = .C OTHER = (|5.|) ; INVALUE N5P2F '-9.99' = . '-8.88' = .A '-6.66' = .C OTHER = (|5.2|) ; INVALUE N6PF '-99999' = . '-88888' = .A '-66666' = .C OTHER = (|6.|) ; INVALUE N6P2F '-99.99' = . '-88.88' = .A '-66.66' = .C OTHER = (|6.2|) ; INVALUE N7P2F '-999.99' = . '-888.88' = .A '-666.66' = .C OTHER = (|7.2|) ; INVALUE N8PF '-9999999' = . '-8888888' = .A '-6666666' = .C OTHER = (|8.|) ; INVALUE N8P2F '-9999.99' = . '-8888.88' = .A '-6666.66' = .C OTHER = (|8.2|) ; INVALUE N8P4F '-99.9999' = . '-88.8888' = .A '-66.6666' = .C OTHER = (|8.4|) ; INVALUE N10PF '-999999999' = . '-888888888' = .A '-666666666' = .C OTHER = (|10.|) ; INVALUE N10P4F '-9999.9999' = . '-8888.8888' = .A '-6666.6666' = .C OTHER = (|10.4|) ; INVALUE N10P5F '-999.99999' = . '-888.88888' = .A '-666.66666' = .C OTHER = (|10.5|) ; INVALUE DATE10F '-999999999' = . '-888888888' = .A '-666666666' = .C OTHER = (|MMDDYY10.|) ; INVALUE N11P7F '-99.9999999' = . '-88.8888888' = .A '-66.6666666' = .C OTHER = (|11.7|) ; INVALUE N12P2F '-99999999.99' = . '-88888888.88' = .A '-66666666.66' = .C OTHER = (|12.2|) ; INVALUE N12P5F '-99999.99999' = . '-88888.88888' = .A '-66666.66666' = .C OTHER = (|12.5|) ; INVALUE N13PF '-999999999999' = . '-888888888888' = .A '-666666666666' = .C OTHER = (|13.|) ; INVALUE N15P2F '-99999999999.99' = . '-88888888888.88' = .A '-66666666666.66' = .C OTHER = (|15.2|) ; RUN; ATTRIB AGE LENGTH=3 LABEL="Age in years at admission" AGE_NEONATE LENGTH=3 LABEL="Neonatal age (first 28 days after birth) indicator" AMONTH LENGTH=3 LABEL="Admission month" AWEEKEND LENGTH=3 LABEL="Admission day is a weekend" DIED LENGTH=3 LABEL="Died during hospitalization" DISCWT LENGTH=8 LABEL="NIS discharge weight" DISPUNIFORM LENGTH=3 LABEL="Disposition of patient (uniform)" DQTR LENGTH=3 LABEL="Discharge quarter" DRG LENGTH=3 LABEL="DRG in effect on discharge date" DRG24 LENGTH=3 LABEL="DRG, version 24" DRGVER LENGTH=3 LABEL="DRG grouper version used on discharge date" DRG_NoPOA LENGTH=3 LABEL="DRG in use on discharge date, calculated without POA" DX1 LENGTH=$5 LABEL="Diagnosis 1" DX2 LENGTH=$5 LABEL="Diagnosis 2" DX3 LENGTH=$5 LABEL="Diagnosis 3" DX4 LENGTH=$5 LABEL="Diagnosis 4" DX5 LENGTH=$5 LABEL="Diagnosis 5" DX6 LENGTH=$5 LABEL="Diagnosis 6" DX7 LENGTH=$5 LABEL="Diagnosis 7" DX8 LENGTH=$5 LABEL="Diagnosis 8" DX9 LENGTH=$5 LABEL="Diagnosis 9" DX10 LENGTH=$5 LABEL="Diagnosis 10" DX11 LENGTH=$5 LABEL="Diagnosis 11" DX12 LENGTH=$5 LABEL="Diagnosis 12" DX13 LENGTH=$5 LABEL="Diagnosis 13" DX14 LENGTH=$5 LABEL="Diagnosis 14" DX15 LENGTH=$5 LABEL="Diagnosis 15" DX16 LENGTH=$5 LABEL="Diagnosis 16" DX17 LENGTH=$5 LABEL="Diagnosis 17" DX18 LENGTH=$5 LABEL="Diagnosis 18" DX19 LENGTH=$5 LABEL="Diagnosis 19" DX20 LENGTH=$5 LABEL="Diagnosis 20" DX21 LENGTH=$5 LABEL="Diagnosis 21" DX22 LENGTH=$5 LABEL="Diagnosis 22" DX23 LENGTH=$5 LABEL="Diagnosis 23" DX24 LENGTH=$5 LABEL="Diagnosis 24" DX25 LENGTH=$5 LABEL="Diagnosis 25" DX26 LENGTH=$5 LABEL="Diagnosis 26" DX27 LENGTH=$5 LABEL="Diagnosis 27" DX28 LENGTH=$5 LABEL="Diagnosis 28" DX29 LENGTH=$5 LABEL="Diagnosis 29" DX30 LENGTH=$5 LABEL="Diagnosis 30" DXCCS1 LENGTH=3 LABEL="CCS: diagnosis 1" DXCCS2 LENGTH=3 LABEL="CCS: diagnosis 2" DXCCS3 LENGTH=3 LABEL="CCS: diagnosis 3" DXCCS4 LENGTH=3 LABEL="CCS: diagnosis 4" DXCCS5 LENGTH=3 LABEL="CCS: diagnosis 5" DXCCS6 LENGTH=3 LABEL="CCS: diagnosis 6" DXCCS7 LENGTH=3 LABEL="CCS: diagnosis 7" DXCCS8 LENGTH=3 LABEL="CCS: diagnosis 8" DXCCS9 LENGTH=3 LABEL="CCS: diagnosis 9" DXCCS10 LENGTH=3 LABEL="CCS: diagnosis 10" DXCCS11 LENGTH=3 LABEL="CCS: diagnosis 11" DXCCS12 LENGTH=3 LABEL="CCS: diagnosis 12" DXCCS13 LENGTH=3 LABEL="CCS: diagnosis 13" DXCCS14 LENGTH=3 LABEL="CCS: diagnosis 14" DXCCS15 LENGTH=3 LABEL="CCS: diagnosis 15" DXCCS16 LENGTH=3 LABEL="CCS: diagnosis 16" DXCCS17 LENGTH=3 LABEL="CCS: diagnosis 17" DXCCS18 LENGTH=3 LABEL="CCS: diagnosis 18" DXCCS19 LENGTH=3 LABEL="CCS: diagnosis 19" DXCCS20 LENGTH=3 LABEL="CCS: diagnosis 20" DXCCS21 LENGTH=3 LABEL="CCS: diagnosis 21" DXCCS22 LENGTH=3 LABEL="CCS: diagnosis 22" DXCCS23 LENGTH=3 LABEL="CCS: diagnosis 23" DXCCS24 LENGTH=3 LABEL="CCS: diagnosis 24" DXCCS25 LENGTH=3 LABEL="CCS: diagnosis 25" DXCCS26 LENGTH=3 LABEL="CCS: diagnosis 26" DXCCS27 LENGTH=3 LABEL="CCS: diagnosis 27" DXCCS28 LENGTH=3 LABEL="CCS: diagnosis 28" DXCCS29 LENGTH=3 LABEL="CCS: diagnosis 29" DXCCS30 LENGTH=3 LABEL="CCS: diagnosis 30" ECODE1 LENGTH=$5 LABEL="E code 1" ECODE2 LENGTH=$5 LABEL="E code 2" ECODE3 LENGTH=$5 LABEL="E code 3" ECODE4 LENGTH=$5 LABEL="E code 4" ELECTIVE LENGTH=3 LABEL="Elective versus non-elective admission" E_CCS1 LENGTH=3 LABEL="CCS: E Code 1" E_CCS2 LENGTH=3 LABEL="CCS: E Code 2" E_CCS3 LENGTH=3 LABEL="CCS: E Code 3" E_CCS4 LENGTH=3 LABEL="CCS: E Code 4" FEMALE LENGTH=3 LABEL="Indicator of sex" HCUP_ED LENGTH=3 LABEL="HCUP Emergency Department service indicator" HOSPBRTH LENGTH=3 LABEL="Indicator of birth in this hospital" HOSP_DIVISION LENGTH=3 FORMAT=2. LABEL="Census Division of hospital" HOSP_NIS LENGTH=4 FORMAT=5. LABEL="NIS hospital number" KEY_NIS LENGTH=5 FORMAT=8. LABEL="NIS record number" LOS LENGTH=4 LABEL="Length of stay (cleaned)" MDC LENGTH=3 LABEL="MDC in effect on discharge date" MDC24 LENGTH=3 LABEL="MDC, version 24" MDC_NoPOA LENGTH=3 LABEL="MDC in use on discharge date, calculated without POA" NCHRONIC LENGTH=3 LABEL="Number of chronic conditions" NDX LENGTH=3 LABEL="Number of diagnoses on this record" NECODE LENGTH=3 LABEL="Number of E codes on this record" NEOMAT LENGTH=3 LABEL="Neonatal and/or maternal DX and/or PR" NIS_STRATUM LENGTH=4 FORMAT=4. LABEL="NIS hospital stratum" NPR LENGTH=3 LABEL="Number of procedures on this record" ORPROC LENGTH=3 LABEL="Major operating room procedure indicator" PAY1 LENGTH=3 LABEL="Primary expected payer (uniform)" PL_NCHS LENGTH=3 LABEL="Patient Location: NCHS Urban-Rural Code" PR1 LENGTH=$4 LABEL="Procedure 1" PR2 LENGTH=$4 LABEL="Procedure 2" PR3 LENGTH=$4 LABEL="Procedure 3" PR4 LENGTH=$4 LABEL="Procedure 4" PR5 LENGTH=$4 LABEL="Procedure 5" PR6 LENGTH=$4 LABEL="Procedure 6" PR7 LENGTH=$4 LABEL="Procedure 7" PR8 LENGTH=$4 LABEL="Procedure 8" PR9 LENGTH=$4 LABEL="Procedure 9" PR10 LENGTH=$4 LABEL="Procedure 10" PR11 LENGTH=$4 LABEL="Procedure 11" PR12 LENGTH=$4 LABEL="Procedure 12" PR13 LENGTH=$4 LABEL="Procedure 13" PR14 LENGTH=$4 LABEL="Procedure 14" PR15 LENGTH=$4 LABEL="Procedure 15" PRCCS1 LENGTH=3 LABEL="CCS: procedure 1" PRCCS2 LENGTH=3 LABEL="CCS: procedure 2" PRCCS3 LENGTH=3 LABEL="CCS: procedure 3" PRCCS4 LENGTH=3 LABEL="CCS: procedure 4" PRCCS5 LENGTH=3 LABEL="CCS: procedure 5" PRCCS6 LENGTH=3 LABEL="CCS: procedure 6" PRCCS7 LENGTH=3 LABEL="CCS: procedure 7" PRCCS8 LENGTH=3 LABEL="CCS: procedure 8" PRCCS9 LENGTH=3 LABEL="CCS: procedure 9" PRCCS10 LENGTH=3 LABEL="CCS: procedure 10" PRCCS11 LENGTH=3 LABEL="CCS: procedure 11" PRCCS12 LENGTH=3 LABEL="CCS: procedure 12" PRCCS13 LENGTH=3 LABEL="CCS: procedure 13" PRCCS14 LENGTH=3 LABEL="CCS: procedure 14" PRCCS15 LENGTH=3 LABEL="CCS: procedure 15" PRDAY1 LENGTH=4 LABEL="Number of days from admission to PR1" PRDAY2 LENGTH=4 LABEL="Number of days from admission to PR2" PRDAY3 LENGTH=4 LABEL="Number of days from admission to PR3" PRDAY4 LENGTH=4 LABEL="Number of days from admission to PR4" PRDAY5 LENGTH=4 LABEL="Number of days from admission to PR5" PRDAY6 LENGTH=4 LABEL="Number of days from admission to PR6" PRDAY7 LENGTH=4 LABEL="Number of days from admission to PR7" PRDAY8 LENGTH=4 LABEL="Number of days from admission to PR8" PRDAY9 LENGTH=4 LABEL="Number of days from admission to PR9" PRDAY10 LENGTH=4 LABEL="Number of days from admission to PR10" PRDAY11 LENGTH=4 LABEL="Number of days from admission to PR11" PRDAY12 LENGTH=4 LABEL="Number of days from admission to PR12" PRDAY13 LENGTH=4 LABEL="Number of days from admission to PR13" PRDAY14 LENGTH=4 LABEL="Number of days from admission to PR14" PRDAY15 LENGTH=4 LABEL="Number of days from admission to PR15" RACE LENGTH=3 LABEL="Race (uniform)" SERVICELINE LENGTH=3 LABEL="Hospital Service Line" TOTCHG LENGTH=6 LABEL="Total charges (cleaned)" TRAN_IN LENGTH=3 LABEL="Transfer in indicator" TRAN_OUT LENGTH=3 LABEL="Transfer out indicator" YEAR LENGTH=3 LABEL="Calendar year" ZIPINC_QRTL LENGTH=3 LABEL="Median household income national quartile for patient ZIP Code" ; INPUT @1 AGE N3PF. @4 AGE_NEONATE N2PF. @6 AMONTH N2PF. @8 AWEEKEND N2PF. @10 DIED N2PF. @12 DISCWT N11P7F. @23 DISPUNIFORM N2PF. @25 DQTR N2PF. @27 DRG N3PF. @30 DRG24 N3PF. @33 DRGVER N2PF. @35 DRG_NoPOA N3PF. @38 DX1 $CHAR5. @43 DX2 $CHAR5. @48 DX3 $CHAR5. @53 DX4 $CHAR5. @58 DX5 $CHAR5. @63 DX6 $CHAR5. @68 DX7 $CHAR5. @73 DX8 $CHAR5. @78 DX9 $CHAR5. @83 DX10 $CHAR5. @88 DX11 $CHAR5. @93 DX12 $CHAR5. @98 DX13 $CHAR5. @103 DX14 $CHAR5. @108 DX15 $CHAR5. @113 DX16 $CHAR5. @118 DX17 $CHAR5. @123 DX18 $CHAR5. @128 DX19 $CHAR5. @133 DX20 $CHAR5. @138 DX21 $CHAR5. @143 DX22 $CHAR5. @148 DX23 $CHAR5. @153 DX24 $CHAR5. @158 DX25 $CHAR5. @163 DX26 $CHAR5. @168 DX27 $CHAR5. @173 DX28 $CHAR5. @178 DX29 $CHAR5. @183 DX30 $CHAR5. @188 DXCCS1 N3PF. @191 DXCCS2 N3PF. @194 DXCCS3 N3PF. @197 DXCCS4 N3PF. @200 DXCCS5 N3PF. @203 DXCCS6 N3PF. @206 DXCCS7 N3PF. @209 DXCCS8 N3PF. @212 DXCCS9 N3PF. @215 DXCCS10 N3PF. @218 DXCCS11 N3PF. @221 DXCCS12 N3PF. @224 DXCCS13 N3PF. @227 DXCCS14 N3PF. @230 DXCCS15 N3PF. @233 DXCCS16 N3PF. @236 DXCCS17 N3PF. @239 DXCCS18 N3PF. @242 DXCCS19 N3PF. @245 DXCCS20 N3PF. @248 DXCCS21 N3PF. @251 DXCCS22 N3PF. @254 DXCCS23 N3PF. @257 DXCCS24 N3PF. @260 DXCCS25 N3PF. @263 DXCCS26 N3PF. @266 DXCCS27 N3PF. @269 DXCCS28 N3PF. @272 DXCCS29 N3PF. @275 DXCCS30 N3PF. @278 ECODE1 $CHAR5. @283 ECODE2 $CHAR5. @288 ECODE3 $CHAR5. @293 ECODE4 $CHAR5. @298 ELECTIVE N2PF. @300 E_CCS1 N4PF. @304 E_CCS2 N4PF. @308 E_CCS3 N4PF. @312 E_CCS4 N4PF. @316 FEMALE N2PF. @318 HCUP_ED N3PF. @321 HOSPBRTH N2PF. @323 HOSP_DIVISION N2PF. @325 HOSP_NIS N5PF. @330 KEY_NIS N10PF. @340 LOS N5PF. @345 MDC N2PF. @347 MDC24 N2PF. @349 MDC_NoPOA N2PF. @351 NCHRONIC N2PF. @353 NDX N2PF. @355 NECODE N3PF. @358 NEOMAT N2PF. @360 NIS_STRATUM N4PF. @364 NPR N2PF. @366 ORPROC N2PF. @368 PAY1 N2PF. @370 PL_NCHS N3PF. @373 PR1 $CHAR4. @377 PR2 $CHAR4. @381 PR3 $CHAR4. @385 PR4 $CHAR4. @389 PR5 $CHAR4. @393 PR6 $CHAR4. @397 PR7 $CHAR4. @401 PR8 $CHAR4. @405 PR9 $CHAR4. @409 PR10 $CHAR4. @413 PR11 $CHAR4. @417 PR12 $CHAR4. @421 PR13 $CHAR4. @425 PR14 $CHAR4. @429 PR15 $CHAR4. @433 PRCCS1 N3PF. @436 PRCCS2 N3PF. @439 PRCCS3 N3PF. @442 PRCCS4 N3PF. @445 PRCCS5 N3PF. @448 PRCCS6 N3PF. @451 PRCCS7 N3PF. @454 PRCCS8 N3PF. @457 PRCCS9 N3PF. @460 PRCCS10 N3PF. @463 PRCCS11 N3PF. @466 PRCCS12 N3PF. @469 PRCCS13 N3PF. @472 PRCCS14 N3PF. @475 PRCCS15 N3PF. @478 PRDAY1 N3PF. @481 PRDAY2 N3PF. @484 PRDAY3 N3PF. @487 PRDAY4 N3PF. @490 PRDAY5 N3PF. @493 PRDAY6 N3PF. @496 PRDAY7 N3PF. @499 PRDAY8 N3PF. @502 PRDAY9 N3PF. @505 PRDAY10 N3PF. @508 PRDAY11 N3PF. @511 PRDAY12 N3PF. @514 PRDAY13 N3PF. @517 PRDAY14 N3PF. @520 PRDAY15 N3PF. @523 RACE N2PF. @525 SERVICELINE N3PF. @528 TOTCHG N10PF. @538 TRAN_IN N2PF. @540 TRAN_OUT N2PF. @542 YEAR N4PF. @546 ZIPINC_QRTL N2PF. ; RUN;

 

 

Ok, so that's the code I've tried now and I'm getting the original error message (I haven't gotten an error on the data yanglab.NIS_2014_Core.ASC yet though...).  And like I said, you'll have to excuse me since I'm not quite up to date on the syntax- I thought a log was what you taught me in your first reply (the thingy typing in the {i})  sorry about the misunderstanding and thank you for teaching me that. 

 

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
61
62 libname yanglab "/folders/myfolders";
NOTE: Libref YANGLAB was successfully assigned as follows:
Engine: V9
Physical Name: /folders/myfolders
63
64 DATA yanglab.NIS_2014_Core;
65 INFILE "/folders/myfolders/All NIS extracted data/NIS 2014/NIS_2014_Core.ASC" LRECL = 547;
66 run;
 
ERROR: Physical file does not exist, /folders/myfolders/All NIS extracted data/NIS 2014/NIS_2014_Core.ASC.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set YANGLAB.NIS_2014_CORE may be incomplete. When this step was stopped there were 0 observations and 0
variables.
WARNING: Data set YANGLAB.NIS_2014_CORE was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
 
 
 
Ask a Question
Discussion stats
  • 18 replies
  • 242 views
  • 0 likes
  • 4 in conversation