About srinath3111

srinath3111 · ‎03-12-2018

Hi, The problem is that the data here is non standard data with out delimiter. For the non standard data with out delimiter how can you use column input method.? Why Dsd you have written it is just a space delimiter data? And After the name the data should contain 2 spaces in the data. or you can split the Name variable into two like first name and lastname. Try. data club; infile datalines; input idnumber 1-4 name $&13. team :$ startwi endwi; datalines; 1023 DAVID shaw RED 189 155 1049 AMELIA verna YELLOW 145 125 1219 ALAN ranju red 210 192 1246 RAVI shankar YELLOW 177 177 1078 ASHELY valley RED 127 118 1221 JIM rose YELLOW 220 220 ; run;

srinath3111 · ‎03-08-2018

Hi, Reversing of all the observations in a data set is an easy process, We can do it in many forms.one of the solution. data want; do i=nobs to 1 by -1; set have point=i nobs=nobs; output; end; stop; run;

srinath3111 · ‎02-26-2018

Hi, I am working out in server along with the server path's. Thanks.

srinath3111 · ‎02-26-2018

Hi, When I provide server path's also it wont work?. Thanks.

srinath3111 · ‎02-26-2018

Hi, I have a folder in my local d drive. in that folder i have various Excel, Csv workbooks and Tab files with different names. So here i wanted to just extract the name's and type of the file and size of the file into a data set. Thanks

srinath3111 · ‎02-19-2018

Hi, options missing=0; data want; set have; x=lag(sales); cum_sales+x; drop x; run;

srinath3111 · ‎02-16-2018

Hi, If you sort a data set and in a data step when you specify by variable then sas creates two automatic variables back end they are first.by variable and last.by variable. first.by variable value is=1 for the first observation in a dataset and rest of all the by group will be =0 except last.by variable. that will be one You can observe it by writing example proc sort data=ds; by sex; run; data ds; set sashelp.classfit; by sex; put _all_;' if first.sex and last.x then flag=1; else flag=0; run; Thanks

srinath3111 · ‎02-15-2018

Hi, you can try this proc sql ; create table table .aa_tes as select run_date ,put(amt, comma12.) as NUMVAR from rx_off.MonthlySummary where run_date >= '01feb2018'd ; quit;

srinath3111 · ‎02-13-2018

Hi, you can try proc format; picture 1-2 = 'High' 3-5='Medium' 6-7='Low'; run;

srinath3111 · ‎02-13-2018

Hi, your code looks good but you have to follow some programming rules. Here you are just extracting the data based on your requirements. But when you use else we have to write the then statement after the if. Example: if condition then output/flag; else output/flag; data ques7; set files.bicycles; if (model eq 'Road Bikes' and unitcost gt 2500) or (if model eq 'Hybrids' and unitcost gt 660); run; proc print data=ques7; run;

srinath3111 · ‎02-13-2018

Hi, Data want; Format string $20.; string="Message"; substr(string,5)=repeat(' ',3) || substr(string,5); run;

srinath3111 · ‎02-12-2018

Hi, you can try %let file=DATROCF; %put &file; options mprint; %macro mac; %do i=1 %to 5; proc import datafile="path\&&file.&i..csv" out=test&i dbms=csv replace ; /*sheet="sheet1";*/ run; %end; %mend; %mac;

srinath3111 · ‎02-05-2018

Data Test; Length A $60.; A='20180205092045'; B=input(A,anydtdte14.); run;

srinath3111 · ‎02-01-2018

data have; input (VarA VarB) ($); datalines; XX PP YY MM ZZ XX AA BB BB AA ; run; proc sql; select distinct("varb") into : mac separated by ' ' from have; quit; data want; set have; if vara in (&mac) then new_var='Y'; else new_var='N'; run;

srinath3111 · ‎01-31-2018

proc sql; create table TEST3 as select distinct BB.* from (select mmcor_cd, srv_type_cd, srv_dt, CLAIM_LINE_NUM, claim_class_cd, max(claim_line_num) as max_claim from claim_trans group by tcn) aa, claim_ppv bb where aa.tcn = bb.tcn and bb.claim_line_num = aa.max_claim order by tcn, claim_line_num ; quit;

Online Status	Offline
Date Last Visited	‎06-22-2021 10:14 AM

Re: Best way to "transpose"/make wide this data

Replace string with another string

Re: Got struck Please help.

identifying data gaps in the data

Re: How to know weather the data set contains special characters in ea...

How to know weather the data set contains special characters in each v...

Re: %let from string with multiple values separated by +

Re: Convert character to numeric

Re: I have data set need to count column b values how many times it re...

Re: SAS coding

Re: PROC EXPORT DBMS=EXCEL

Re: %let from string with multiple values separated by +

Re: Multiple records to one observation

Re: How do I create a calculated column in an existing dataset

Re: Syntax error

Re: Issue with Data step import

Re: getting wrong output pls help this code once

Re: How would I Reverse Order of All Variables, Rows, and Columns

Re: Extracting only file names from the folders

Re: Extracting only file names from the folders

Extracting only file names from the folders

Re: How do I create a calculated column in an existing dataset

Re: Last.X and First.X on the same time

Re: Removing $ sign from numeric field and just store numbers

Re: proc format error

Re: What is wrong with these IF and ELSE IF statements?

Re: Inserting number of spaces in between a string

Re: Importing a a .csv file to a SAS dataset

Re: How to read yyyymmddhmmss informat

Re: How to check one variables value in another variable in same datas...

Re: Syntax error