cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
San_rise
‎01-13-2022
  • 10 Posts
  • 1 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: SAS Array with If Condition is not working while migrating from 9....

by Fluorite | Level 6 in SAS Programming
‎01-03-2022 12:26 PM
‎01-03-2022 12:26 PM
Condition 1: (max(HRA) = missing  and min(HRA) = missing) and HRA_prev_yr is not missing   OR   Condition 2: max(hra) = min(HRA) and HRA_prev_yr is not missing and HRA_prev_yr = max(HRA) and intck('day',hra_prev_yr,disenrollment_date) <365   So it is A OR B.   Note: HRA here is macros with arrays ranging from 1 to 41 and is in date format. ... View more

Re: SAS Array with If Condition is not working while migrating from 9....

by Fluorite | Level 6 in SAS Programming
‎01-03-2022 11:50 AM
‎01-03-2022 11:50 AM
Thank you for spacing the code. Here is the Log   ... View more

Re: SAS Array with If Condition is not working while migrating from 9....

by Fluorite | Level 6 in SAS Programming
‎01-03-2022 11:34 AM
‎01-03-2022 11:34 AM
Hey I am getting the output, but the value in the Variable EXCLUDE is not coming as "XYZ". Suspecting that the IF condition has some error. EXCLUDE = "XYZ" is a command given to create variable EXCLUDE with value as "XYZ". ... View more

SAS Array with If Condition is not working while migrating from 9.3 to...

by Fluorite | Level 6 in SAS Programming
‎01-03-2022 11:21 AM
‎01-03-2022 11:21 AM
Please help in validating this code. In 9.4 I am not able to get correct value of EXCLUDE in the output. Seems like there is some error around 'and not missing'.   data test; set test1; array hra_ (*) &hras.; array d_(&ct.);   do i=1 to &ct.; if (((max(of hra_ (*)) = .  and min(of hra_(*)) = .) and not missing(HRA_previous_yr)) or ((max(of hra_ (*)) = min(of hra_ (*))) and not missing(HRA_previous_yr) and (HRA_previous_yr) = max((of hra_ (*)))) and intck('day', HRA_previous_yr, disenrollment_date) < 365 then do; EXCLUDE = "XYZ"; END; END; run; ... View more

Re: Reading a date format 2020-07-14 11:00 EDT from a text file

by Fluorite | Level 6 in SAS Programming
‎11-12-2020 04:18 AM
‎11-12-2020 04:18 AM
Please help by specifying the format and informat for the date value 2020-07-14 11:00 EDT (YYYY-MM-DD HH:MM ZONE) ... View more

Reading a date format 2020-07-14 11:00 EDT from a text file

by Fluorite | Level 6 in SAS Programming
‎11-12-2020 03:32 AM
‎11-12-2020 03:32 AM
I am trying to import a pipe '|' delimited text file in SAS using PROC IMPORT. Though I am able to get most of the variable values except the date variable having value as '2020-07-14 11:00 EDT'. Please guide on how to handle this data.   Also please guide on various must use options while importing a text file so that no variables or values get missed out.   Thanks ... View more

Re: Save a file in external file in sas7bdat format

by Fluorite | Level 6 in SAS Programming
‎11-12-2020 01:46 AM
‎11-12-2020 01:46 AM
Thank you Amir. This does the work I was looking for. ... View more

Re: Save a file in external file in sas7bdat format

by Fluorite | Level 6 in SAS Programming
‎10-23-2020 11:59 AM
‎10-23-2020 11:59 AM
Any %macro %mend that can involve this diversity and just punching in the different paths and filenames. Any suggestion if I want to proceed with that how the syntax need to be framed.   Example: Location 1 --> File1.xlsx, File2.csv, File3.xlsb Location 2 --> File4.csv Location 3 --> File5.xlsx Any best way wherein I can automate this in terms of importing them in SAS. ... View more

Re: Save a file in external file in sas7bdat format

by Fluorite | Level 6 in SAS Programming
‎10-23-2020 11:56 AM
‎10-23-2020 11:56 AM
This was the first thought that I had but due to different file types from multiple system paths I need to assign multiple libraries and then read each individual files and move them to the created library. It is a time taking job. ... View more

Save a file in external file in sas7bdat format

by Fluorite | Level 6 in SAS Programming
‎10-23-2020 07:57 AM
‎10-23-2020 07:57 AM
An excel file - 'ABC.xlsx' already exists in an external folder. Requirement is to save the same file in the same location but in sas7bdat format. I dont want to use the PROC IMPORT process as it will be lengthy process.   Please guide how effectively this can be done in SAS for multiple files stored in different locations. Thanks ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-13-2022 07:16 PM
Likes given to
View All
Quick links