About soham_sas

soham_sas · ‎05-08-2018

Hi you can try like this data date; input patient$ date; cards; Obs_1 2162016 Obs_2 21122016 ; run; data date1; set date; date1=input(date,8.); format date1 ddmmyy10.; run;

soham_sas · ‎04-27-2018

@Astounding i tried the code , its giving the output like below , but we need the 5th observation only for Id 3 (i.e 3 bang,bbsr,hyd) please suggest also as there are many datasets so i am appendeing all the datsets , then sort it by Id and then i am applying the code 1 del 2 mum 3 bang 3 bang,bbsr 3 bang,bbsr,hyd 4 cal 5 pun 6 che

soham_sas · ‎04-26-2018

Hi i have 3 tables called one two and three (in realtime i have around 40 to 50 different tables) i have to summarize these tables based on the ID as the key variable , like ID 3 is in all the table with different dept name, so in the final summarized table the dept for Id 3 should be all the 3 dept separated by a comma (,) data i have below data one; input id dept$; cards; 1 del 2 mum 3 bang ; run; data two; input id dept$; cards; 3 bbsr 4 cal ; run; data three; input id dept$; cards; 5 pun 3 hyd 6 che ; run; data i want : id dept 1 del 2 mum 3 bang ,Hyd ,bbsr 4 cal 5 pun 6 che

soham_sas · ‎04-05-2018

HI , i have data set like below , where the employee id is repeating and the salary for the repeated id is also same i want to take top 3 salary from the table , and if the id is repeated then i want all the repeated rows also e.g emp 1 and 2 is repeated in original table so in result also they are repeated . data emp; input id sal; cards; 1 10000 2 20000 3 30000 1 10000 2 20000 4 5000 5 4000 ; run; data want ID SAL 1 10000 1 10000 2 20000 2 20000 3 30000

soham_sas · ‎02-09-2018

DSN is your hadoop/hive server name , and schema is your folder name inside the hadoop/hive for better clarification , it will be a good option to check with your hadoop/hive admin they will tell you exactly what will be the DSN and Schema for the table which you want to access

soham_sas · ‎02-09-2018

You can Create a library using the ODBC , or you can directly access the table also by connect to odbc option libname syntax will be like below libname name odbc dsn = " " schema=" "; ODBC connection syntax will be like below proc sql inobs=10; CONNECT TO ODBC (noprompt= " enter your DSN ; schema= ;"); create table dsn as select * from connection to odbc ( SELECT varnames from table name ); quit; NOTE : accessing the data through ODBC connection is more faster than a Libname

soham_sas · ‎02-09-2018

I guess you are trying to append all the datasets , but while appending the dataset in a set statement you don't need to give a comma between 2 datasets name so change your macro value (it should resolve to test_1 (space) Test_2) and then run the code , it will work

soham_sas · ‎02-09-2018

@scb you can do it like below data sensitive; input type1 $ type2 $ var1 $ var2 $ var3 $ var4 $; cards; t1 ta custid custname m mobile ; run; proc transpose data=sensitive out=want(drop=_name_ rename=(col1=var_need)); var var1-var4; run;

soham_sas · ‎02-08-2018

HI , i have a data set like below , i have to check which road is there in all the city , for example "a" is there in all the city so we want the output to be like city road delhi a mumbai a chennai a bangalore a the data is like below data dsn; infile cards dlm='09'x; input city$ road$; cards; delhi a delhi b delhi c mumbai d mumbai a chennai e chennai f chennai a chennai g bangalore i bangalore j bangalore k bangalore a ; run;

soham_sas · ‎02-07-2018

@Reeza i didi it like below proc sql; create table one as select distinct sex from sashelp.classfit order by sex; quit; data two; set one end=eof; if eof then sex_1 = cat("'",sex,"'"); else sex_1= cat("'",sex,"'",','); run; proc sql noprint; select sex_1 into: var_list separated by " " from two; quit; %put &var_list;

soham_sas · ‎02-06-2018

@Reeza thanks for the solutions , but can you please suggest something like i have mentioned in the want column i.e single qoute with comma separated (like 'f','m')

soham_sas · ‎02-06-2018

Hi i have a data set which contains some value (lets say a,b,c e.t.c) , now i have to create a macro for those values and that macro i have to use in a sql like (where name in (&macro) so i am trying to concatenate the observations by single cotes and a comma but its not working for example i am trying the sashelp.class HAVE WANT F 'F', M 'M' also please note that in the last observation we don't need the comma to be there in the result proc sql; create table test1 as select distinct sex from sashelp.classfit order by sex; quit; data test2; set test1; by sex; if last.sex = 1 then sex1=cat("'",sex,"'"); else sex1 = cat("'",sex,"'",","); run;

soham_sas · ‎02-06-2018

hi , you can do it using a do loop also , please refer the below code data dat; _date=mdy(1,1,&year); output; do until (_date=mdy(12,31,&year)); _date+1; output; end; format _date date9.; run;

soham_sas · ‎02-02-2018

Hi you can try the below code , but it will give you texte1 and texte2 value with some blank (missing) observations , you have to write one more step to remove the blank and keep only the unique value can any one suggest how to do that in a single step proc sql; create table want as select texte1 , texte2 from t1 full join t2 on texte1 = texte2 where texte1 in (select texte1 from t1 left join t2 on texte1=texte2 where texte2 is null) or texte2 in (select texte2 from t2 left join t1 on texte2=texte1 where texte1 is null); quit;

soham_sas · ‎01-30-2018

HI i am trying to write a code to calculate the below scenario , lets say i started investing with Rs1 , and i will double the money every day , i.e 1st day=Rs1 2nd day = Rs2 3rd day = Rs4 . . . so on.. i want to know how many days it will take to make my investment in to Rs100000 i am trying the below code but some how not getting the logic to do so , please help... DATA investthree; DO until (value >= 100000); value+1; _value=value*2; day + 1; OUTPUT; END; RUN;

Online Status	Offline
Date Last Visited	‎08-02-2020 10:02 AM

Re: job code Tenure

job code Tenure

create a summary table

Re: Number of records in for each dataset available in a metadata sas ...

Re: format

Re: Replace string with another string

Re: Group the data

Re: Number of records in for each dataset available in a metadata sas ...

Re: select all the value from the highest value

select all the value from the highest value

Re: SAS access to hadoop

Re: Top 20% and Bottom 10% of observations?

Re: Reading one date from two numeric formats

Re: summarize data

summarize data

Select top 3 records

Re: SAS access to hadoop

Re: SAS access to hadoop

Re: Macro error

Re: Proc transpose query

road name in all the city

Re: concatenating variable names

Re: concatenating variable names

concatenating variable names

Re: Loop a valid calendar date

Re: Retrieve unique observations

%Do %while loop