cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
shahsn11
‎09-02-2018
  • 11 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Proc report group issue

by Fluorite | Level 6 in SAS Programming
‎08-29-2018 01:02 PM
‎08-29-2018 01:02 PM
Could you post the solution that work for you.   Thanks. ... View more

Understanding FindC function

by Fluorite | Level 6 in SAS Programming
‎08-12-2018 08:12 AM
‎08-12-2018 08:12 AM
Hi,   I am trying to understand FindC function with the help of the below example   data test; input MEDICARE_ID $ 1-64; datalines; _2E8a X3628970 A2 _N_ _______ 315 _ab12A:5 _error_ abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabc ; run; data test1; set test; whereisit=findc(trim(upcase(MEDICARE_ID)), '2'); run; If you run the above code, i am getting the below output I am fine with all the output except the 3rd one where i was expecting "2" , because 2 is at 2nd location.    So, i would like to know what is wrong in my understanding.   Thanks. ... View more

Libraries not present everytime i open SAS university Edition

by Fluorite | Level 6 in SAS Programming
‎08-04-2018 02:32 PM
‎08-04-2018 02:32 PM
Hi Experts,   I am using SAS University Edition. Every time i open SAS i do not see the the libraries i created before i see the below libraries.   Everytime i need to execute the below code so that i see my Libraries libname Staging '/folders/myfolders/Staging'; After executing i can see my tables intact in the library.   But why does library goes off everytime. Does the same happen with Enterprise edition of SAS ?   Thanks, Shadab.     ... View more

Confirmation about below behaviour of Infile

by Fluorite | Level 6 in SAS Programming
‎08-04-2018 01:50 PM
‎08-04-2018 01:50 PM
I used infile to read a CSV and store its information in a particular table , lets say Table1.   Now i used another CSV file and try to store its information in the same table. Every time the old content in table Table1 is deleted and new one is inserted.   Is there a way i can append the content of 2 different files into same table Tablel1 ?   I know that i can create one more table and then used it to append it to Table1. But do we have a option in Infile like we have in Proc Import (replace is the option i am talking about).   Thanks. ... View more

Understanding SAS lib creation process

by Fluorite | Level 6 in SAS Programming
‎08-02-2018 02:35 PM
‎08-02-2018 02:35 PM
Hi,   I am trying to learn sas programming.   I wrote the below code on University edition of SAS   libname Staging '/folders/myfolders/'; PROC IMPORT DATAFILE='/folders/myfolders/temp2/LoadSomeRandomFile.XLSX' OUT = Staging.RandomTable DBMS = xlsx; sheet='Sheet1'; run; After execution of this code, a lib "Staging" was created. All fine till now   Now, i executed the below code   libname Cleaning '/folders/myfolders/'; Which created another library name Cleaning, but....... why there is "RandomTable" table in cleaning tooo..... when i had not specified to create it. Why does sas creates it by default.   Thanks. ... View more

Re: Inserting data from 1 Lib to another

by Fluorite | Level 6 in SAS Procedures
‎08-02-2018 01:40 PM
‎08-02-2018 01:40 PM
Thanks Kurt and Anil for the solution.   Anil unfortunately the solution propose by you is not working for me. It is giving error message like below. I see that there is no scope to improve the syntax error.   ERROR 22-322: Syntax error, expecting one of the following: ), ','. Kurt yours solution is working fine but i need to apply a where condition on staging.invoice which i cannot apply using proc append. I am looking for something like PROC SQL; INSERT INTO Cleaning.Invoice(SELECT * FROM Staging.Invoice where billto in (select billto from Cleaning.invoice)) ; quit; Thanks. ... View more

Inserting data from one library to another

by Fluorite | Level 6 in SAS Procedures
‎08-02-2018 01:39 AM
‎08-02-2018 01:39 AM
I am trying to insert the data from 1 lib to another using the below SAS code   PROC SQL; INSERT INTO Cleaning.Invoice SELECT * FROM Staging.Invoice; quit; I am getting the below error message     ERROR: You cannot reopen CLEANING.INVOICE.DATA for update access with member-level control because CLEANING.INVOICE.DATA is in use by you in resource environment SQL (2). ERROR: PROC SQL could not undo this statement if an ERROR were to happen as it could not obtain exclusive access to the data set. This statement will not execute as the SQL option UNDO_POLICY=REQUIRED is in effect. Metadata for both Invoice is same ... View more

Inserting data from 1 Lib to another

by Fluorite | Level 6 in SAS Procedures
‎08-02-2018 01:27 AM
‎08-02-2018 01:27 AM
Hi,   I am trying to insert the data from 1 lib to another using the below SAS code   PROC SQL; INSERT INTO Cleaning.Invoice SELECT * FROM Staging.Invoice; quit; I am getting the below error message   ERROR: You cannot reopen CLEANING.INVOICE.DATA for update access with member-level control because CLEANING.INVOICE.DATA is in use by you in resource environment SQL (2). ERROR: PROC SQL could not undo this statement if an ERROR were to happen as it could not obtain exclusive access to the data set. This statement will not execute as the SQL option UNDO_POLICY=REQUIRED is in effect. Metadata for both Invoice is same ... View more

Re: Understanding the output return by the below

by Fluorite | Level 6 in SAS Programming
‎07-25-2018 03:23 AM
‎07-25-2018 03:23 AM
Thanks Chris and Andrea for answering the question ...  It makes complete sense now ...appreciate the help in clearing the doubt. ... View more

Re: Understanding the output return by the below

by Fluorite | Level 6 in SAS Programming
‎07-25-2018 02:16 AM
‎07-25-2018 02:16 AM
Hi Chris,   Thanks for the quick response.   But, If we see both the data step code I have written and value in variable a and b are same. The second one gives me correct answer but the first one does not.   I would like to understand this behavior why the second result is giving me correct answer and first one is not. If I comment the length code in first datastep I get the correct answer , but I am not able to understand the logic behind this.   Thanks. ... View more

Understanding the output return by the below

by Fluorite | Level 6 in SAS Programming
‎07-25-2018 12:36 AM
‎07-25-2018 12:36 AM
Hi Pals,   Below is a peice of code i am trying to understand Index function. according to me both are almost same code and should return the same result, but that is not the case. Could anybody help me understand the working of the code.    data _null_; length a b $14; a='ABC.DEF (X=Y)'; b='X=Y'; q=index(a,b); put q=; run; *proc contents data=test3 ; *run; data _null_; a = 'ABC.DEF (X=Y)'; b = 'X=Y'; x = index(a,b); put x=; run;     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-02-2018 07:38 AM
Likes given to
View All
Quick links