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: 
kajal_30
‎10-24-2024
  • 191 Posts
  • 6 Likes Given
  • 3 Solutions
  • 4 Likes Received

Running macro using call execute

by Quartz | Level 8 in SAS Programming
‎06-23-2022 11:09 AM
‎06-23-2022 11:09 AM
I have a working macro %  (yrmt = 202004); I have 5 values for &yrmt  = 202007,202006,202004,202009.202010 ; I want to run this macro for all these yrmt .can anyone please help. Here is the code I have tried so far. data dtmt; Do i= 1 to countw("&yrmt."); dttemp = scan("&yrmt.",i); call execute(%history_data(yrmt = dttemp)); output; end; run;  Please advise   Thanks Kajal  ... View more

Re: Date column has inconsistencies across values

by Quartz | Level 8 in SAS Programming
‎06-22-2022 01:26 PM
‎06-22-2022 01:26 PM
Hi Tom the values showing 1/1/1960 are actually not null values in the source they have valid date value. ... View more

Re: Getting Error: ERROR: CLI execute error: Operation canceled : ERRO...

by Quartz | Level 8 in SAS Programming
‎06-22-2022 12:49 PM
‎06-22-2022 12:49 PM
I was able to get a closer look and found the faulty records    Thanks for your help.   Kajal ... View more

Date column has inconsistencies across values

by Quartz | Level 8 in SAS Programming
‎06-22-2022 12:48 PM
‎06-22-2022 12:48 PM
Hi Team,   I have a date column which is showing correct values in all the rows in a SAS dataset. But when I am loading the same dataset to Netezza database just few say 20 out of 200 values are showing date of 1/1/1960 rest column shows same dates as we have in the SAS dataset. we are using the same format of the column in SAS and Netezza. please advise    Regards kajal ... View more

Re: SAS is reading but not loading Boolean values

by Quartz | Level 8 in SAS Programming
‎06-22-2022 09:46 AM
‎06-22-2022 09:46 AM
Hi @Tom    I am loading it to Netezza database. I am using base sas to load it. Yeah I also read the same and now I am creating the database table column type as char so that I can store values 'Y' or 'N' . so changed the type from Boolean to char worked fine.  Thanks Kajal ... View more

SAS is reading but not loading Boolean values

by Quartz | Level 8 in SAS Programming
‎06-22-2022 08:49 AM
‎06-22-2022 08:49 AM
Hi Team , In the database table I have a column qr_sac which is defined as Boolean while creation.In sas table I have values for this column like 'N','Y','N','N' ...... I am appending sas table to the database table. I am not seeing any errors while appending but the final database table is showing values like screenshot below.Can anyone please help. I am expecting to see same values like SAS 'Y' or 'N'.  Regards Kajal   ... View more

Getting Error: ERROR: CLI execute error: Operation canceled : ERROR: ...

by Quartz | Level 8 in SAS Programming
‎06-21-2022 06:24 PM
‎06-21-2022 06:24 PM
getting error: ERROR: CLI execute error: Operation canceled : ERROR: External Table : count of bad input rows reached maxerrors limit but I don't see any notifications above shows or printing any bad records or type mismatches in the logs. Please advise me of the possible reasons.    Regards Kajal ... View more

Re: Not able to read the date accurately

by Quartz | Level 8 in SAS Programming
‎06-21-2022 06:22 PM
‎06-21-2022 06:22 PM
Thank you everyone. It worked fine after converting the type. ... View more

Not able to read the date accurately

by Quartz | Level 8 in SAS Programming
‎06-21-2022 10:18 AM
‎06-21-2022 10:18 AM
I have one column having values like 20201022, 20200123, 20220410 I have tried almost all informats  to read the value. Can anyone please suggest the informat to read these values? I am expecting to read it as date and output value in the format of date9.   Thanks Kajal ... View more

Re: creating a new column while reading the csv file

by Quartz | Level 8 in SAS Programming
‎06-20-2022 01:31 PM
‎06-20-2022 01:31 PM
Thanks @Reeza  also is there a way if we can change the type of column cust_id in the same program ? or I need to write another step to modify the dataset?  ... View more

creating a new column while reading the csv file

by Quartz | Level 8 in SAS Programming
‎06-20-2022 12:30 PM
‎06-20-2022 12:30 PM
Hi team,  I am creating a new variable during reading the csv file but somehow not getting any idea to do so .so I need to create 2 variables one is the date_Curr which will get the current datetime() second column is yrmnt value will be &ymt. can you please help. Kajal libname work2 '/work/sas/data'; data work2.sample; infile "/work/sas/sample.csv" delimiter = "," dsd truncover missover firstobs=2; Length cust_id cust_name ; informat cust_id 8.; informat cust_name $5.; format cust_id 8.; format cust_name $5.; input cust_id cust_name ; run;   ... View more

Re: Proc import reading numeric values as char

by Quartz | Level 8 in SAS Programming
‎06-17-2022 01:32 PM
‎06-17-2022 01:32 PM
Hi @Tom , I tried all the options suggested but still getting some errors like one value is getting into another column  also missing values for some of the column. May concern is even if values in the columns are undefined but at least they should not get into another column. Can you please suggest some more options  Regards Kajal ... View more

Re: Proc import reading numeric values as char

by Quartz | Level 8 in SAS Programming
‎06-17-2022 12:39 PM
‎06-17-2022 12:39 PM
sorry missing ; was just a typo while pasting the code here. Actual code has ; after input statement and yes I printed 10 lines and they have comma separated values   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-24-2024 04:14 PM
Likes from
View All
Quick links