About Satish_Parida

Satish_Parida · ‎02-27-2018

Why do you want to use 20.2? You can use 20. or best12. as well based on the highest length.

Satish_Parida · ‎02-27-2018

data have; input Value:best12. Date_Time:datetime16. Repeat_Flag:best12.; format Date_Time datetime16.; datalines; 20 22JAN18:16:27:29 0 10 22JAN18:16:27:30 0 5 22JAN18:16:27:31 1 20 22JAN18:16:27:33 1 5 22JAN18:16:27:36 0 ; run; data want(drop=i j); set have; retain i; if _N_=1 then i=0; if Repeat_Flag=1 then do; output; i=i+1; do j = 1 to i by 1; Date_Time=Date_Time+1; Repeat_Flag=0; output; end; end; else do; output; end; run; Please let us know if this worked for you.

Satish_Parida · ‎02-21-2018

If the source of the file is different and we can not predict the line breaks Can we use more than one TERMSTR option in one data step. like LF+CR

Satish_Parida · ‎02-20-2018

@GinaRepole Thank you very much. I was missing the carriage return. filename file1 '/u04/dataloader/Satish/App/ZZ/f1.csv' encoding='utf-8'; data xxx.asdf; infile file1 dlm=',' dsd firstobs=2 encoding='utf-8' TERMSTR=CR; /*CR Worked as carriage return*/ input SiteNumber:$10. LabName:$30. AnalyteName:$16. FromDate:$20. ToDate:$20. LowRange:best12. HighRange:best12. Units:$10. Dictionary:$10. Comments$10.; run; Thank you very much

Satish_Parida · ‎02-20-2018

@GinaRepole Can it be done in bash command, or using any utility in base SAS? I am trying to automate a batch process. I am using a UNIX OS, where SAS 9.4 is installed. This is one example file.

Satish_Parida · ‎02-20-2018

Hi All, I am trying to read a utf-8 encoded csv file. In Notepad++ the file looks fine. In notepad the whole file comes as 1 line. I am using a UNIX OS, where SAS 9.4 is installed. So when SAS reads the file, it is only reading 1 record. As I am using firstobs=2 to avoid reading header, the final dataset contains 0 records. I am using the following code. filename file1 '/u04/dataloader/Satish/App/ZZ/f1.csv' encoding='utf-8'; data xxx.asdf; infile file1 dsd dlm=',' firstobs=2 encoding='utf-8'; input SiteNumber:$10. LabName:$30. AnalyteName:$16. FromDate:$20. ToDate:$20. LowRange:best12. HighRange:best12. Units:$10. Dictionary:$10. Comments$10.; run; I am trying to read the data from line2. Thanks in advance.

Satish_Parida · ‎02-16-2018

It can be done as follows. %macro combineYears(Year1, Year2, Year3, Year4, Year5); %do i=1 %to 5; %put year= &&year&i; /*process logic*/ %end; %mend combineYears; %combineYears(2000, 2001, 2010, 2015, 2018); *LOG year= 2000 year= 2001 year= 2010 year= 2015 year= 2018 It will be good if you also pass the number of years you are passing and use to loop control. Please let us know if it helped.

Satish_Parida · ‎02-16-2018

Have you seen the solution provided based on datetime and your requirement?

Satish_Parida · ‎02-15-2018

Runs fine for me. Log for reference. 4 %let startRep=01Nov2017; /*Used Standard SAS Date formats*/ 5 6 %macro sqlloop; 7 %do i=0 %to 3; 8 %let j=%eval(&i+1); 9 %let startRep&j=%sysfunc(intnx(month,"&startRep."d,-&i.)); 10 %put &&startRep&j; 11 %end; 12 %mend sqlloop; 13 %sqlloop; 21124 21093 21063 21032

Satish_Parida · ‎02-15-2018

Please clear us on 1. What your data should look like. 2. What your data looks like now. 3, Source data 4. Codes you have written. Thank you.

Satish_Parida · ‎02-15-2018

This will work data tab1; input id; cards; 1 2 3 ; run; data tab2; input mend:date9.; format mend date9.; cards; 31Jan2018 28Feb2018 31Mar2018 ; run; proc sql; create table want as select * from tab1,tab2 order by id; quit; Let us know if it worked for you.

Satish_Parida · ‎02-15-2018

Data looks like this; start end 20100313 20141231 20101127 20160421 20091021 20160519 and you had tried month= intck('month', start, end); So this can be assumed you need difference in months. And the above did not work so both the variable start and end are not numeric or one of them not numeric. 1. Please identify the non-numeric type data first and change it to numeric data type using format yymmdd8. e.g.1. if start is charecter then do as following start1=input(start,yymmdd8.); e.g.1. if end is charecter then do as following end1=input(end,yymmdd8.); 2. Then try the intck function for the difference. Please note I have used a different variable while changing datatype in the example. Please let us know if it helped you.

Satish_Parida · ‎02-15-2018

In that case this will also work. There is no space timing, it is old school concatenation. I have done the same thing in 2 steps just to demonstrate it works. data have; MEASURES1='cnt_pol_COMBINE sum_pol_COMBINE cnt_pol_QA sum_pol_QA cnt_pol_FO sum_pol_FO cnt_pol_FACNP sum_pol_FACNP cnt_pol_PQS sum_pol_PQS cnt_pol_SURPLUS1 sum_pol_SURPLUS1 cnt_pol_SURPLUS2 sum_pol_SURPLUS2 cnt_'; MEASURES2='pol_FACPROP sum_pol_FACPROP cnt_pol_OTHER sum_pol_OTHER cnt_ins_COMBINE sum_ins_COMBINE cnt_ins_QA sum_ins_QA cnt_ins_FO sum_ins_FO cnt_ins_FACNP sum_ins_FACNP cnt_ins_PQS sum_ins_PQS cnt_ins_SURPLUS1'; MEASURES3=' sum_ins_SURPLUS1 cnt_ins_SURPLUS2 sum_ins_SURPLUS2 cnt_ins_FACPROP sum_ins_FACPROP cnt_ins_OTHER sum_ins_OTHER'; run; data want; set have; MEASURES4=MEASURES1||MEASURES2||MEASURES3; run; For real time, 1. if you know the number of vars you going to concatenate then define the length of final string in advance, 2. Please keep in mind the maximum length of character variables in this case, which is around 32000.

Satish_Parida · ‎02-15-2018

%MACRO UPDATE_MM(MON=,CU_YR=); PROC SQL; create table tmp_&MON as Select DISTINCT * FROM WORK.SOURCE where DATE = "mm_&cu_yr._&mon" ; QUIT; %MEND UPDATE_MM; data _null_; run_date=today(); /*Here you can put your date or programetically pass your date*/ cu_yr=put(year(run_date),z4.); do i=1 to 12; mon=put(i,z2.); execution_cmd='%UPDATE_MM('||mon||','||cu_yr||')'; call execute(execution_cmd); end; run; This will work, and it will be better if you pass the cu_yr macro variable to the macro function.

Satish_Parida · ‎02-15-2018

The following is working, tested. No Leading or trailing blanks removed. data have; MEASURES1='cnt_pol_COMBINE sum_pol_COMBINE cnt_pol_QA sum_pol_QA cnt_pol_FO sum_pol_FO cnt_pol_FACNP sum_pol_FACNP cnt_pol_PQS sum_pol_PQS cnt_pol_SURPLUS1 sum_pol_SURPLUS1 cnt_pol_SURPLUS2 sum_pol_SURPLUS2 cnt_'; MEASURES2='pol_FACPROP sum_pol_FACPROP cnt_pol_OTHER sum_pol_OTHER cnt_ins_COMBINE sum_ins_COMBINE cnt_ins_QA sum_ins_QA cnt_ins_FO sum_ins_FO cnt_ins_FACNP sum_ins_FACNP cnt_ins_PQS sum_ins_PQS cnt_ins_SURPLUS1'; MEASURES3=' sum_ins_SURPLUS1 cnt_ins_SURPLUS2 sum_ins_SURPLUS2 cnt_ins_FACPROP sum_ins_FACPROP cnt_ins_OTHER sum_ins_OTHER'; MEASURES4=MEASURES1||MEASURES2||MEASURES3; run; Please let us know if it worked for you.

Online Status	Offline
Date Last Visited	‎04-17-2023 07:51 AM

Re: Reading CSV file with double quotes, line breaks and spaces

Re: Reading a csv file with records length more than 33,000

Re: Case when multiple conditions to create aggregated value

Re: Case when multiple conditions to create aggregated value

Reading a csv file with records length more than 33,000

Re: Control the Log and Listing Location from Batch Call in SAS Grid S...

Re: Control the Log and Listing Location from Batch Call in SAS Grid S...

Control the Log and Listing Location from Batch Call in SAS Grid Serve...

Re: Using in-format (??) in proc fcmp

Re: Using in-format (??) in proc fcmp

Re: Control the Log and Listing Location from Batch Call in SAS Grid S...

Re: Replace null with value by looking back and ahead a certain number...

Re: break field with -

Re: SAS Programming

Re: Removing postfix (e.g Inc, Limited) in corporate names

Re: Deleting rows with condition

Re: XML LIBNAME reading data from URL

Re: SAS:how to use index to pick out macro array variable

Re: Case when multiple conditions to create aggregated value

Re: break field with -

Re: Converting Character amount values to Numeric for Sort Sum

Re: Insert one or many copies of a row when a condition is meet while ...

Re: Reading UTF-8 Encoded csv File

Re: Reading UTF-8 Encoded csv File

Re: Reading UTF-8 Encoded csv File

Reading UTF-8 Encoded csv File

Re: Is there a way to loop through a series of like parameters?

Re: How to flag the latest date or use group by

Re: macro loop to get next 4 months

Re: Forcing alignment of numeric-turned-character variables

Re: Creating dataset with Unique list of ID's and dates

Re: Difference between two dates YYYYMMDD format date9.

Re: concatenate variables with out removing leading and trailing space...

Re: Creating a variable list to loop through macro

Re: concatenate variables with out removing leading and trailing space...