About User12

User12 · ‎08-31-2017

Hi Guys, I have a quick question can we create macro variables using :INTO clause in subqueries select distinct names into :names1-:names&total from (select names,Count(distinct names) into :total from sample) can we use :into in a subquery as shown above

User12 · ‎05-25-2017

Hi @Shmuel they are from dbms but they have been pulled into sas and stored in sas already so i need to eliminate the unnecessary ones

User12 · ‎05-25-2017

Hi @Oligolas that was an excellent poc that helped me out. But it is comparing table c with table d and e only but i want to compare table c with table a and table b too . And also i have nearly 100 variables in each dataset to compare can you help me out there And another concern is what if there is no common variable in two datasets. Thanks very much

User12 · ‎05-23-2017

Hi @ChrisNZ i have a delimiter set while reading the libname statements into a dataset. i.e., the dlm is set in first data step itself not in WANT Data step. thanks

User12 · ‎05-22-2017

Hi @ChrisNZ i am using dlm while reading the data i.e., in data _null_ in this case. Thanks

User12 · ‎05-22-2017

Hi @Shmuel the answer is a big yes to first three questions there can be all three situations and the id variable will be a unique identifier. i am not clear with the 4th question and fifth question multiple users pulling same dataset from rdbms for different purposes or maybe same purposes has created the duplicates and if i can find the duplicates exactly i just want to delete them Thanks

User12 · ‎05-19-2017

Hi Guys, I have a situation where i have thousands of sas datasets.In which there are duplicates too. I need to find out the top 10 duplicate datasets which are taking most of my sas memory out of them. When i say duplicates if there is a 75-80% match with other datasets, i consider them as duplicates. Any help to solve this situation would be appreciated. Thanks

User12 · ‎05-19-2017

Hi @ChrisNZ that was really good code that helped me out thanks for the help. Have a question for you What if i have situation where i have a dlm=";" option set while reading the inputs.How can i solve that situation. Thanks

User12 · ‎05-17-2017

hi @Sven111 i have multiple files where mt libnames are declared.i want to store all of them in one single dataset to keep track of the locations

User12 · ‎05-17-2017

Hi Guys, I have an input sas program where i have all my libnames declared.I am reading that into a sas dataset.while doing that its reading commented out values too.And i don't want those commented code into my sas dataset. I would like to remove the comments from my dataset whether the comments are made in one single line or multiple lines. the code looks like this: Libname sample1 "XYZ"; Libname sample2 "ABC"; /*Libname sample3 "asdfghjj";*/ Libname sample4 "uxcvdgh"; /*commented out Libname sample5 "XYZasdf"; Libname sample6 "XYZasdfgb";**/ Libname sample7 "XYZdefrgevsdc"; Requirement:Without editing the source file i.e., above sample code i would like the output like this in sas dataset: obs var1 1 Libname sample1 "XYZ" 2 Libname sample2 "ABC" 3 Libname sample4 "uxcvdgh" 4 Libname sample7 "XYZdefrgevsdc"; Thanks For the Help

User12 · ‎01-10-2017

I am taking data from a front end java app its up and running multiple people can submit data at a time over there

User12 · ‎01-09-2017

Hi I have a code which has to take data from exisisting Webservice link and perform operation and create a xml output. For importing data from webservice i am using Proc http. My doubt is how it will handle if multiple webservice requests come in at same time and how is it converted into sas datasets and sent back as separate outputs? I would really appreciate some help in hopefully simple terms! Thanks in Advance

User12 · ‎01-09-2017

Hi I have a code which has to take data from exisisting Webservice link and perform operation and create a xml output. For importing data from webservice i am using Proc http. My doubt is how it will handle if multiple webservice requests come in at same time and how is it converted into sas datasets and sent back as separate outputs? I would really appreciate some help in hopefully simple terms! Thanks in Advance

User12 · ‎01-09-2017

Hi I have a code which has to take data from exisisting Webservice link and perform operation and create a xml output. For importing data from webservice i am using Proc http. My doubt is how it will handle if multiple webservice requests come in at same time and how is it converted into sas datasets and sent back as separate outputs? I would really appreciate some help in hopefully simple terms! Thanks in Advance

User12 · ‎08-27-2016

hi Pamela_JSRCC the calculated variables are created by me and the values are stored in numeric format as all other calculated variables now i have to find out min value of the calculated variable and i have the dataset only in VA.

Online Status	Offline
Date Last Visited	‎12-12-2018 11:29 AM

USING :INTO in SUBQUERIES

Re: Identifying Duplicates datasets

Re: Identifying Duplicates datasets

Re: Removing Comments

Re: Removing Comments

Re: Identifying Duplicates datasets

Identifying Duplicates datasets

Re: Removing Comments

Re: Removing Comments

Removing Comments

Re: Access Volatile Teradata Table

Re: Identifying Duplicates datasets

Re: SAS VA 7.3>> IS there a way to divide my date variable

USING :INTO in SUBQUERIES

Re: Identifying Duplicates datasets

Re: Identifying Duplicates datasets

Re: Removing Comments

Re: Removing Comments

Re: Identifying Duplicates datasets

Identifying Duplicates datasets

Re: Removing Comments

Re: Removing Comments

Removing Comments

Re: Import Data from Web services

Import Data from Web services

Importing Data from Webservices same time

Importing Data from Webservices

Re: Minimum and maximum value of calculated numeric variable