About jaiganesh

jaiganesh · ‎12-06-2019

it generate the dataset with below result. dir: cannot access C\:\\Users\\rong\\*: No such file or directory dir: cannot access /s: No such file or directory It means SAS couldn't able to read the directory from Windows as it is by default referring the Linux. I would be appreciate if anyone can suggest the way to connect to Windows.

jaiganesh · ‎12-06-2019

I ran %put &=sysscp; I got the log with SYSSCP=LIN X64 Now how i can i change it to the Windows ?

jaiganesh · ‎12-06-2019

I've already created the shared drive, That can be accessed with right permission. Now the challenge is how i can access it through SAS. As SAS can be easily locate linux, It should support for the Windows as well.

jaiganesh · ‎12-05-2019

Hello, I've been using below code to get the list of files from LINUX environment. Filename filelist pipe "dir /mydata/user/*.xlsx"; Data _null_; Infile filelist truncover; Input filename $100.; Put filename=; Run; As SAS is installed in Linux, above code is working fine, However i couldn't able to use above code for Windows. Windows directory C:\files\*.xlsx instead /mydata/user/*.xlsx, Couldn't able to recognize by SAS, As it is installed on Linux. Please suggest how i can allocate the windows directory in FILENAME syntax so list of the files can be seen. Any other approach to achieve list of files from windows directory is also appreciated.

jaiganesh · ‎12-04-2019

MY SAS is running on the Linux, MY DSN is configured on the Windows. Kindly suggest.

jaiganesh · ‎12-03-2019

Hello, I'm trying to get the Microsoft SQL connected to SAS, I've followed the attached document till the page number 13 , from page 4 (libname statement ) , using below code , However couldn't able to get the desired result. Code1: proc sql; connect to odbc as mycon ( Datasrc='*****' USER="******" PASSWORD="*****"); quit; ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Data source name not found and no default driver specified if i change "odbc " to "SQLSVR" then getting below error Code2: proc sql; connect to SQLSVR as mycon ( Datasrc='*****' USER="******" PASSWORD="*****"); quit; ERROR: The SQLSVR engine cannot be found. ERROR: A Connection to the SQLSVR DBMS is not currently supported, or is not installed at your site. Kindly suggest on this...

jaiganesh · ‎11-18-2019

I've tried doing that with Some proc SQL Statement, However couldn't able to get the Robust solutions on this.

jaiganesh · ‎11-18-2019

Ohhh, I'm sorry , That was my mistake , Please consider below one. I've a data like below Part_No Remark kk12 READY TO SELL kk12 Hold in STOCK kk22 READY TO SELL kk22 READY TO SELL kk22 Hold in STOCK kk33 Hold in STOCK kk33 READY TO SELL I need a output like Part_No Remark conclusion kk12 READY TO SELL Hold in STOCK kk12 Hold in STOCK Hold in STOCK kk22 READY TO SELL Hold in STOCK kk22 READY TO SELL Hold in STOCK kk22 Hold in STOCK Hold in STOCK kk33 Hold in STOCK Hold in STOCK kk33 READY TO SELL Hold in STOCK Please suggest on this

jaiganesh · ‎11-18-2019

Ohhh, I'm sorry , That was my mistake , Please consider below onc. I've a data like below Part_No Remark kk12 READY TO SELL kk12 Hold in STOCK kk22 READY TO SELL kk22 READY TO SELL kk22 Hold in STOCK kk33 Hold in STOCK kk33 READY TO SELL I need a output like Part_No Remark conclusion kk12 READY TO SELL Hold in STOCK kk12 Hold in STOCK Hold in STOCK kk22 READY TO SELL Hold in STOCK kk22 READY TO SELL Hold in STOCK kk22 Hold in STOCK Hold in STOCK kk33 Hold in STOCK Hold in STOCK kk33 READY TO SELL Hold in STOCK Please suggest on this

jaiganesh · ‎11-18-2019

Ohhh, I'm sorry , That was my mistake , Please consider below onc. I've a data like below Part_No Remark kk12 READY TO SELL kk12 Hold in STOCK kk22 READY TO SELL kk22 READY TO SELL kk22 Hold in STOCK kk33 Hold in STOCK kk33 READY TO SELL I need a output like Part_No Remark conclusion kk12 READY TO SELL Hold in STOCK kk12 Hold in STOCK Hold in STOCK kk22 READY TO SELL Hold in STOCK kk22 READY TO SELL Hold in STOCK kk22 Hold in STOCK Hold in STOCK kk33 Hold in STOCK Hold in STOCK kk33 READY TO SELL Hold in STOCK

jaiganesh · ‎11-18-2019

This would not help , As we are taking only last Remark for all parts, However my concern is , Which ever part has ANY Remark "HOLD ON STOCK " should come Conclusion as "HOLD ON STOCK " for all line for that parts, Else "Ready to sell" for all Lines. Thanks in Advence

jaiganesh · ‎11-18-2019

What i mean is , If any remark for any part says "Hold in STOCK" then entire conclusion should be shown as "Hold in STOCK" else "Ready to Sell", Actual requirement is different, However this logic could be significant part of it. I would appreciated if you can help to guide in any ways.

jaiganesh · ‎11-18-2019

I think what i ask was, I have the input data set (first ) and need a output like 2nd data set. Where has conclusion column , Which is writing the conclusion on the basis of remark, If any of the remark say "Hold in STOCK " for individual part then , Entire Conclusion should say "Hold in STOCK " (for all individual lines in conclusion) else it should say " READY TO SELL" Let me know if you need any other clarification.

jaiganesh · ‎11-18-2019

Hello , I've a data like below Part_No Remark kk12 READY TO SELL kk12 Hold in STOCK kk22 READY TO SELL kk22 READY TO SELL kk22 Hold in STOCK kk33 Hold in STOCK kk33 Hold in STOCK I need a output like Part_No Remark conclusion kk12 READY TO SELL Hold in STOCK kk12 Hold in STOCK Hold in STOCK kk22 READY TO SELL Hold in STOCK kk22 READY TO SELL Hold in STOCK kk22 Hold in STOCK Hold in STOCK kk33 READY TO SELL READY TO SELL kk33 READY TO SELL READY TO SELL Need a column conclusion , Where the any Part_No has any Remark "Hold in STOCK " , Then conclusion would be all "Hold in STOCK" else conclusion would be "READY TO SELL". Any Remark for the Part_No has "Hold in STOCK" should be given the conclusion as "Hold in STOCK" Kindly respond with SAS Code

jaiganesh · ‎11-17-2019

Hello, I've below set of code to be execute. Data Test; set mock; if count eq 0 then ---> it should go the list line of the program i,e line no 45. All middle line of codes should not be read neither execute. Is there any way to jump directly from one line of Code to other line of Code (irrespective of any data steps) ? I believe , SAS may not allow this , Any suggestion would be appreciated on this.

Online Status	Offline
Date Last Visited	‎12-17-2019 02:25 PM

Re: Accessing windows file list from drive

Re: Accessing windows file list from drive

Re: Accessing windows file list from drive

Accessing windows file list from drive

Re: SQL connection from SAS

SQL connection from SAS

Re: SAS Program

Re: SAS Program

Re: SAS Program

Re: SAS Program

Re: SQL connection from SAS

Re: variable date to week

Re: Missing Entries

Re: Missing Entries

Re: LAG Function

Re: Accessing windows file list from drive

Re: Accessing windows file list from drive

Re: Accessing windows file list from drive

Accessing windows file list from drive

Re: SQL connection from SAS

SQL connection from SAS

Re: SAS Program

Re: SAS Program

Re: SAS Program

Re: SAS Program

Re: SAS Program

Re: SAS Program

Re: SAS Program

How to create a new variable based on value in one column across the g...

SAS Code - conditional execution of code