Hi, is there a way I can just update an Excel (2010) worksheet (while leaving the other worksheets untouched), and also bring over the formats form SAS to Excel.. for example percentages, numbers, dollars.. etc. Thanks
... View more
Thanks Arthur, your code works fine, the data is just so big and so much that it takes too long to run.. I went back to the source provider and asked them to chop it up as per only the fields I needed. Thanks to all for your help.
... View more
Actually checking the data in Notepad.. it's continuous.. eg : Date,MAR10000001,MAR10000002,MAR10000003,MAR10156052,2001.01,3,18,11,4535,2001.02,7,2,15,895,2001.03,9,0,0,0, 2013.09,34,1,56,5646
... View more
The code that Tom suggested kinda worked, but it did not take the first column which is the row's name (date).. Eg. the first column is the dates of each row... Looks something like this (this just a made up sample) Date MAR10000001 MAR10000002 MAR10000003 ...... MAR10156052 2001.01 3 18 11 4535 2001.02 7 2 15 895 2001.03 9 0 0 0 ... 2013.09 34 1 56 5646
... View more
I'm trying to import a huge (156,052 columns) dataset in csv format. The rows are small (maybe 100 rows). But the isses here is that once I do my proc import the data splits the column variables into Text and Numerc, when they should all be numeric. The first 2978 columns keeps the right column names but turns it text, the rest of the columns get named as VAR's but stay numeric... I checked the initial source in notepad and partially in excel and it seems all fine there. I don't know what the problem could be. Thanks. Here is my code (but I tried many different options too): PROC IMPORT Datafile = 'C:\ABC\Unit_Monthly.csv' OUT=DATA.CREA_M DBMS = dlm REPLACE; GuessingROWS=2; Delimiter = ','; getnames=yes; run;
... View more
The options could be either Option 1 : Field_B is 1 value and then the other (eg. T's and then C's or vice versa) OR Option 2 : T's then C's and then T's again or C's then T's and then C's again... so if there is only one switch in Feild_B then don't keep . if there is more than one switch in Field_B then keep (sorted by date and groupped by Field_A)
... View more
I have a large dataset grouped by Field_A and dates for each rows within the groups. There is also another Field_B that may or may not be intermittent within each group.. I need to pick only the groupings that have Field_B intermittent.. here's what I mean: HAVE: Field_A Date Field_B A 2001.01 T A 2001.02 C A 2001.03 C A 2001.04 T ---------------------------------------------------- B 2001.01 T B 2001.02 T B 2001.03 C B 2001.04 C ----------------------------------------------------- C 2001.01 C C 2001.02 T C 2001.03 C C 2001.04 T ----------------------------------------------------- D 2001.01 C D 2001.02 C D 2001.03 T D 2001.04 T WANT: Field_A Date Field_B A 2001.01 T A 2001.02 C A 2001.03 C A 2001.04 T ----------------------------------------------------- C 2001.01 T C 2001.02 C C 2001.03 T C 2001.04 C WANT tables shows that Field_B has values that are mixed within it, not arranged as seen in Field_A = B or D in the HAVE table.
... View more
I'm doing a sgplot and the Date formet (on the x-axis) is in a YYMMP7. format (eg. 2005.04) over a period of 10 years or so.. I wish it to see the x-interval from May2010 to Aug2013, bi-annual, but instead all the values show up.. and it looks like a black block. Thanks Here is my code: proc sgplot data = MS.Centract_ALL4; where City= 'Toronto'; vbar date / response=Counts; vline date / response=Price y2axis; vline date / response=Orig_Price y2axis; xaxis Values = ("01May2010"d to "01Aug2013"d by 2) Label = 'Date'; run;
... View more
that is correct, and since theer are about 30 fields, I don't want to type each one.. a dup may occur though in another field, my example only shows date, but it could happen for any other of the 30 fields... I may have to comprimise.
... View more
no it doesn't matter, as long as I get only one by Acct_No and jpstats, the data is from a server, and it's large that I have to use proc sql (rsubmit)
... View more
