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: 
TB10
‎08-29-2023
  • 7 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

sql transform equivalent in sas

by Fluorite | Level 6 in SAS Programming
‎08-24-2023 01:22 AM
‎08-24-2023 01:22 AM
I have the following type of code in sql: TRANSFORM Max(ConfigValue) SELECT Config_ID FROM TABLE_01 GROUP BY Config_ID PIVOT ConfigField how do i convert it in sas to get the same result ?   @PaigeMiller @Quentin @fja @Tom  ... View more

Re: Multiple then from single if condition

by Fluorite | Level 6 in SAS Programming
‎08-08-2023 10:27 AM
‎08-08-2023 10:27 AM
@PaigeMiller @Quentin  i tried this but i am unable to check the values of a and b when i write put a; put b; out side of the loop. Anyway to check the values. As mentioned i am unable to access the variable values outside the loop. ... View more

Multiple then from single if condition

by Fluorite | Level 6 in SAS Programming
‎08-08-2023 10:12 AM
‎08-08-2023 10:12 AM
@fja @Tom  so i have a scenario as follows: a =intnx('day',today(),-1); b=intnx('day',today(),-2);  we have a variable named flag whose value is set based on other conditions. now what is desired is: suppose flag=1: if flag=1 then a =intnx('day',today(),-1) and b=intnx('day',today(),-2); so the above syntax is desired but looks like we cannot add multiple then conditions through and. i tried with if..do statements but after we end the statement i cannot access the variable a & b after that. can you please help me here. ... View more

Re: Date Format changes while importing into sas from excel

by Fluorite | Level 6 in SAS Programming
‎07-18-2023 07:34 AM
‎07-18-2023 07:34 AM
The type is Date ... View more

Re: Date Format changes while importing into sas from excel

by Fluorite | Level 6 in SAS Programming
‎07-18-2023 05:38 AM
‎07-18-2023 05:38 AM
Yes that's the correct understanding. I have managed to import the file through excelcs but date column format is changing. ... View more

Re: Date Format changes while importing into sas from excel

by Fluorite | Level 6 in SAS Programming
‎07-18-2023 05:08 AM
‎07-18-2023 05:08 AM
Thanks for your reply @Tom and @fja   however i am importing the file from windows shared drive and not from sas grid. Hence xlsx is not  working. I am trying to upload the file from shared drive but still it's not working.(please note port and connectivity is open between sas grid and windows share drive and proc upload through RUWIN is working vice versa when i am trying to copy the file from sas grid to shared drive). ... View more

Date Format changes while importing into sas from excel

by Fluorite | Level 6 in SAS Programming
‎07-17-2023 03:14 PM
‎07-17-2023 03:14 PM
In my excel file i have a column as 'Start Date' (with space in between). and the date format is mm/dd/yyyy hh:mm format. While i am importing the file in sas the format is changing to ddmmmyyyy (eg. 02JUN2023). How do i retain the original format? Code: %let filepath='/user/drive1/file/'; proc import datafile="&filepath.test.xlsx"; out=work.rawdata dbms=excelcs  replace; run; @Tom @fja  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-29-2023 05:44 AM
Likes given to
View All
Quick links