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: 
Nimish_Vaddiparti
‎01-26-2016
  • 18 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Reading a csv file

by Calcite | Level 5 in SAS Programming
‎01-26-2016 11:01 AM
‎01-26-2016 11:01 AM
Hi,   I'm trying to use the in-file statement to read a csv file.   the code I've written is : data NV; infile 'path\NVM_Data.csv' dsd firstobs =2 ; input Item_Id Market_Id $ date mmddyy10. Sales Season XX YY ZZZ Age PlugIn D DM Scrap FPR RPR CP EP GP FP ST LC; format date mmddyy10.; run;   But when I run the above program, the data doesn't get read properly. I've attached the input data (test.csv) and the output (output.csv) for your reference. The output clearly shows that SAS isn't reading the data correctly. Can you help? Thanks, Nimish   PS - the files that I'm trying to read are in csv format. But since, I'm unable to upload them, I've saved them in excel format. ... View more

Re: Merging Issue

by Calcite | Level 5 in SAS Procedures
‎06-09-2015 04:20 PM
‎06-09-2015 04:20 PM
Okay. Let me spell out the issue again. 1) I need to merge two data sets by using the date as a reference 2) When I did merge them, I noticed duplicate entries (selected distinct date & plc using proc sql). 3) Ideally for each date, there should only be one PLC value. But when i looked into dataset, there were two PLC values assigned for each date. e.g: Date,PLC 06/27/2014,1 06/27/2014,    1 06/28/2014,1 06/28/2014,    1 5) I've tried converting all the PLC values to text (&all numeric as well), but it hasn't helped. 6) I then tried formatting the dates, but it hasn't helped either My merged dataset needs to have one PLC value for each date. Do let me know if its still not clear. Thanks, Nimish ... View more

Re: Merging Issue

by Calcite | Level 5 in SAS Procedures
‎06-09-2015 03:21 PM
‎06-09-2015 03:21 PM
Hi, That's original problem I was referring to. When I didn't format the dates and tried merging them, it led to duplicate values (please refer to the example in my original post). I tried formatting the dates etc. but it hasn't helped. Can you think of any other solution? Cheers, Nimish ... View more

Re: Merging Issue

by Calcite | Level 5 in SAS Procedures
‎06-09-2015 01:22 PM
‎06-09-2015 01:22 PM
PS - you've understood the problem correctly. ... View more

Re: Merging Issue

by Calcite | Level 5 in SAS Procedures
‎06-09-2015 01:22 PM
‎06-09-2015 01:22 PM
hi, so, i used the input suggestion. i get the following Warning 'Variable Date has already been defined as numeric'. I also additionally see this statement in the log: NOTE: Invalid argument to function INPUT at line 24 column 11. Date=02/20/2013 N=1 Match=0 Holiday=0 Monday=0 Dum_Var=0 launch=0 plc=0 new_date=. _ERROR_=1 _N_=1 Do you know whats causing the issue? Thanks, Nimish ... View more

Re: Merging Issue

by Calcite | Level 5 in SAS Procedures
‎06-09-2015 11:33 AM
‎06-09-2015 11:33 AM
Hi, I've attached two csv files for your reference. I'm trying to merge these files by using the date column for reference. Regards, Nimish ... View more

Merging Issue

by Calcite | Level 5 in SAS Procedures
‎06-09-2015 09:51 AM
‎06-09-2015 09:51 AM
Hi, I'm trying to merge two datasets. The reference column lists the dates. I've tried formatting the dates in both the columns i.e. to ensure that formats in both the data sets are the same. I've tried date9., mmddyy10., mmddyy. When I look at the distinct dates, to cross check if the merging was correct, I see the following situation: Date,PLC 06/27/2014,1 06/27/2014,    1 06/28/2014,1 06/28/2014,    1 This is just a sample of the output. I see a number of duplicate rows. My code: data data.hm1; set data.hm1; format date mmddyy10.; run; proc sort data=data.hm1; by date; run; data data.S5_LTE; set data.S5_LTE; format date mmddyy10.; run; data data.hm1; set data.hm1; plc1 = put(plc,6.); drop plc; rename plc1 = plc; run; proc sort data=data.S5_LTE; by date; run; data data.S5_LTE; merge data.S5_LTE ( in=a)  data.hm1(in=b) ; by date ; if a and b; run; Can you please suggest a way out? Thanks, Nimish ... View more

Re: Treating negative values

by Calcite | Level 5 in SAS Programming
‎03-04-2015 03:26 AM
‎03-04-2015 03:26 AM
Yes, Reeza ... View more

Treating negative values

by Calcite | Level 5 in SAS Programming
‎03-03-2015 07:17 PM
‎03-03-2015 07:17 PM
Hi, I have a few negative observations in my data and I want to replace them by the average of the pre & post values. I cannot use proc expand and hence, can you please suggest an alternate route? Its urgent and hence, can you please get back asap? E.g. of data: Market,Product,Date,Price X,ZZZ,12/10/2020,15 X,ZZZ,13/10/2020,17 X,ZZZ,14/10/2020,-15 X,ZZZ,15/10/2020,25 Regards, Nimish ... View more

Re: Proc transpose

by Calcite | Level 5 in SAS Procedures
‎07-28-2014 09:19 PM
‎07-28-2014 09:19 PM
Hi Tom, I did try proc transpose, but it hasn't helped. I also added the by variable, but it hasn't helped. Can you use the data set at your end and test the transpose? Thanks and Regards, Nimish ... View more

Proc transpose

by Calcite | Level 5 in SAS Procedures
‎07-28-2014 07:13 PM
‎07-28-2014 07:13 PM
Hi, I'm looking to transpose my data. I've attached the file for reference. There are around 17 odd columns & 171974 rows. I need to transpose this information, such that my rows end up in the columns & my columns in my rows. Can someone please help me with the syntax? I need this urgently and hence, it would be great if you can share it asap. Cheers, Nimish ... View more

Re: Freezing variables in regression

by Calcite | Level 5 in Statistical Procedures
‎06-24-2014 03:52 AM
‎06-24-2014 03:52 AM
Hi Naeem, I'm looking to use the regression output to build a new model. Lets say i have 10 variables in my initial model. And out of the 10, 2 have a high p -value. Now, I want to rerun my regression equation, after excluding these two variables, without having to manually write the code. Is this possible? If yes, can you suggest the best way forward. Regards, Nimish ... View more

Re: Freezing variables in regression

by Calcite | Level 5 in Statistical Procedures
‎06-19-2014 12:05 PM
‎06-19-2014 12:05 PM
Hi, Can you help with the statement? As in where should i add the include option? Cheers, Nimish ... View more

Freezing variables in regression

by Calcite | Level 5 in Statistical Procedures
‎05-30-2014 08:57 AM
‎05-30-2014 08:57 AM
Hi, I'm using proc regression and i want to freeze a few variables. In other words, i dont want a few variables to get dropped. I'm trying to build a code, which can be used going forward. And where the user does not need to keep manually force including these variables. Any ideas how i can take this forward? Regards, Nimish ... View more

Re: Changing the format of the data

by Calcite | Level 5 in SAS Procedures
‎12-10-2012 01:31 PM
‎12-10-2012 01:31 PM
@Tom additionally you also mentioned Proc datasets. Could you elaborate on this? As in, how do I go about using this? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-26-2016 11:32 AM
Likes given to
View All
Quick links