About kajal_30

kajal_30 · ‎06-17-2022

Hi @Reeza , Yeah I am converting EXCEL to csv the same way you suggested saving the excel file as csv. I have also validated the csv file and data is correct but after reading it using the data step I am getting merged columns in the output and empty lines. Is there any option I am missing in the code below? libname work2 '/apps/sas/data'; data work2.XL_OUT; infile "/apps/sas/orig.csv" delimiter = "," missover dsd firstobs=2; Length CUST_ID 8 CUST_REG $10 ; informat CUST_ID BEST.; informat CUST_REG $10.; format CUST_ID BEST.; format CUST_REG $10.; input CUST_ID CUST_REG $ run; proc print data= XL_OUT (obs=6) noobs; run;

kajal_30 · ‎06-16-2022

one more concern while creating the csv file from dataset I can see there are 2 empty lines after every record. but actual excel file doesn't have any empty lines. - importing xlsx as dataset - exporting dataset into a csv file May I know why am I seeing these empty lines. regards Kajal

kajal_30 · ‎06-16-2022

ok I can take it as a fair statement. So while we are doing the import from csv file the imported data without columns will follow the same sequence as we have in the file or it can be different. for eg in csv file we have cust_no region 100 USA so for imported dataset can I put input cust_no region should be ok ? regards Jagdeep

kajal_30 · ‎06-16-2022

Hi Tom, AS I am reimporting the csv to a dataset I can see 0 variables . Is there a way we can retain column names while importing from a csv file ? refraining from using input statement as in future business might change the sequence of the columns in the sheet Regards Kajal

kajal_30 · ‎06-16-2022

Hi Tom, where do we have this dataset template coming from ?

kajal_30 · ‎06-16-2022

Thanks @Kurt_Bremser actually we only base sas available. do we have a base sas code for playing the same role as libre office?

kajal_30 · ‎06-16-2022

Hi Reeza, So it can be different each time we are reading the excel file? is it better for me to convert this file into csv format and then read that file using data step and assign lengths and formats as per the final target dataset to be appended to? Thanks Kajal

kajal_30 · ‎06-16-2022

We will have no control over the excel file as it will be directly be provided by business to the process. so no manual intervention will be allowed.

kajal_30 · ‎06-16-2022

Hi there, I have a dataset and few columns have numeric values but when I reading that excel using the proc import SAS is reading them as character. Is there a way if I can retain the type while proc importing? for eg : sd_id has values as 3,4,5,6,7,8 similarly I have other few columns causing the same issue but sas is reading it as char. so currently we can see the specific columns showing this behavior but when it goes to production environment we are not even sure if other numeric columns are start getting read as char. Is there a way we can handle this issue. Regards Kajal

kajal_30 · ‎06-14-2022

I have a sas program which is using date input and I want to run that program iteratively for collecting historical data on the bases of different dates. May I please know how can I run that program repetitively? data dtmt; length longstr1 $ 200; Do i= 1 to countw("&yearmonth2."); dttemp = scan("&yearmonth2.",i); call symputx (yrmnth,scan("&yearmonth2.",i)); longstr1 = (abc.sas); output; call execute(longstr1); end; run; unable to create it as a macro as there are multiple steps and may need lots of adjustments. preferring to run .sas program again n again. Thanks Kajal

kajal_30 · ‎06-14-2022

Thank you team

kajal_30 · ‎06-13-2022

I have a dataset 'have' and numeric variables 'a' , 'b' ,'c' , 'd' in it and I want to convert them all into character and assign format $3. keeping the variable names same 'a' , 'b' ,'c' , 'd' . thanks Kajal

kajal_30 · ‎06-13-2022

thank you @PaigeMiller

kajal_30 · ‎06-13-2022

Thank you @Reeza @Kurt_Bremser

kajal_30 · ‎06-10-2022

Hi team, I have database table with certain formats and I want to put the same sas format in final sas table so that it can be easily appended to the database table. varchar(20) --> char(20) smallint --> ? decimat(5,2) --> ? boolean --> ? integer --> ? date --> ? Thanks Kajal

Online Status	Offline
Date Last Visited	‎10-24-2024 04:14 PM

Re: Need max value for each group by column

Re: Need max value for each group by column

Need max value for each group by column

Re: need first and last record in the form of sql

Re: need first and last record in the form of sql

Re: need first and last record in the form of sql

Re: need first and last record in the form of sql

Re: need first and last record in the form of sql

need first and last record in the form of sql or datastep

Re: Loop in dates for %macro function

Re: Need help with below statement in one program

Re: Need help with below statement in one program

Re: Error: Attribute Not Found

Re: getting last month from year month date

Re: getting last month from year month date

Re: Macro contain file names to be deleted from location /test/user_id

Re: Macro contain file names to be deleted from location /test/user_id

What this code is doing here?

SAS join

Re: Proc import reading numeric values as char

Re: Proc import reading numeric values as char

Re: Proc import reading numeric values as char

Re: Proc import reading numeric values as char

Re: Proc import reading numeric values as char

Re: Proc import reading numeric values as char

Re: Proc import reading numeric values as char

Re: Proc import reading numeric values as char

Proc import reading numeric values as char

Running SAS program iteratively .

Re: converting same variable name from char to numeric in the same dat...

converting same variable name from char to numeric in the same dataset...

Re: need to get last 4 calendar dates from the date indicated

Re: converting the database formats in sas

converting the database formats in sas