I don't think IE is supported for SAS Studio but Chrome certainly is. In the absence of any other responses I think you may be best off opening a track with SAS Support which you can do here -> https://support.sas.com/ctx/supportform/createForm ... View more

I've never seen or heard of this issue before. Could you tell us what browser you're using and whether or not you've tried and experienced the issue with other browsers? ... View more

I'm puzzled - because you have both Formats.TQFormats and SASUser.Formats in your FMTSEARCH path this will automatically happen  as if SAS can't find Formats.TQFormats it should automatically search SASUser.Formats and if the formats are identical there's no problem..... ... View more

Hi @Patelbb - as best as I can tell from the log text the variable VSORRES is character so you cannot read it into the new variable VSORRESX using a numeric informat, it just doesn't make sense hence the invalid argument reference you're seeing in your log. ... View more

If you have a file of any size (both in terms of number of observations and number of variables) you're going to find it much more efficient to use one of the procedures which gives you this statistic. I'd use Proc Means - here's an example using a modified version of SASHELP.CARS   data cars; set sashelp.cars; if type="SUV" then msrp=.; if origin="Asia" then invoice=.; if make="Acura" then origin=""; run; proc means data=cars nmiss n; run; If you run that code you'll see it gives you the total number of missing and non-missing observations for all the numeric variables without you having to specify the variable names. You'll also see that you don't get a figure for the missing values in the character variable ORIGIN which I introduced in the data step. To do that you can use a trick I learnt from Rick Wicklin's Blog post here -> https://blogs.sas.com/content/iml/2011/09/19/count-the-number-of-missing-values-for-each-variable.html   proc format; value $missfmt ' '='Missing' other='Not Missing'; value missfmt . ='Missing' other='Not Missing'; run; proc freq data=cars; format _CHAR_ $missfmt.; /* apply format for the duration of this PROC */ tables _CHAR_ / missing missprint nocum nopercent; format _NUMERIC_ missfmt.; tables _NUMERIC_ / missing missprint nocum nopercent; run; The output looks different to the previous example as it uses Proc Freq but it gives you values for all variables, including the character ones. ... View more

Hi @jaiganesh - this is a huge topic but there are a number of papers available on it (links to a couple below). I've used parallel processing with MP Connect on a number of occasions and under the right conditions it can yield spectacular performance improvements, but conversely if you use It inappropriately it can increase execution time so you need to know what you're doing and understand it thoroughly. Here are the link (one is to a workshop paper but you should be able to follow it)   https://www.lexjansen.com/wuss/2014/43_Final_Paper_PDF.pdf   https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/124-29.pdf   If you could be more specific about your requirement we could steer you in the right direction better ... View more

Hi @rossfo and welcome to the community.   There are several ways of doing this so here's one - read the input into the automatically created variable _infile_ then parse that using a combination of the SCAN and SUBSTR functions (the inclusion of both spaces and commas in the address field is what causes the issues. Here's the code   data want(drop=address); length shipid $5 received 8 shipped 8 city $20 zipcode $5 address $30; format received yymmdd10. shipped yymmdd10.; infile datalines; input; shipid=scan(_infile_,1," "); received=input(scan(_infile_,2," "),yymmdd10.); shipped=input(scan(_infile_,3," "),yymmdd10.); zipcode=scan(_infile_,-1," "); address=substr(_infile_,29); city=scan(address,1,","); zipcode=scan(address,-1,","); datalines; X8742 2018/03/14 2018/03/17 Little River, KS, 67457 R9028 2018/06/12 2018/07/10 Bartlett, KS, 67332 O1800 2018/03/28 2018/03/29 Leawood, KS, 66211 V7235 2018/05/19 2018/05/31 Manter, KS, 67862 H5688 2018/02/05 2018/02/21 Goodland, KS, 67735 G2665 2018/06/16 2018/06/20 Randall, KS, 66963 N2219 2018/11/28 2018/12/24 Neal, KS, 66863 L9312 2018/12/04 2018/12/12 Wichita, KS, 67211 P4220 2018/04/25 2018/05/03 Miltonvale, KS, 67466 W8174 2018/10/10 2018/10/13 Burns, KS, 66840 L6161 2018/08/02 2018/08/26 Milford, KS, 66514 J1873 2018/01/16 2018/01/27 Lindsborg, KS, 67456 G9188 2018/09/13 2018/10/02 Olsburg, KS, 66520 P7794 2018/12/23 2019/01/08 Salina, KS, 67402 T2556 2018/09/03 2018/09/09 Wichita, KS, 67211 H2552 2018/12/23 2019/01/04 Burlingame, KS, 66413 H7170 2018/02/22 2018/03/10 Syracuse, KS, 67878 B5975 2018/03/13 2018/04/06 Wetmore, KS, 66550 I1771 2018/08/10 2018/08/21 Bird City, KS, 67731 Z3670 2018/03/02 2018/03/05 Overland Park, KS, 66225 Q3244 2018/05/10 2018/05/12 Clifton, KS, 66937 Q1765 2018/02/08 2018/02/16 Hazelton, KS, 67061 N9743 2018/11/27 2018/12/01 Geuda Springs, KS, 67051 G3305 2018/12/13 2019/01/10 Norton, KS, 67654 T3424 2018/06/21 2018/07/15 Kansas City, KS, 66101 ; run; ... View more

Unfortunately no - you’ll have to upload the files. That may well be a deal breaker for you unless you can anonymise the data. ... View more

Hi @mattjolley and welcome to the community.   Have you considered SAS OnDemand for Academics? This is entirely cloud based so you could run it from another location and despite its name is available to all lifelong learners. You can find out more about it at this link -> https://www.sas.com/en_gb/software/on-demand-for-academics.html ... View more

You'd most likely use data steps, macros or procedures or a combination of these. The possibilities are endless - there's a short video here on how to write a basic SAS program -> https://video.sas.com/detail/videos/how-to-tutorials/video/4573016765001/writing-a-basic-sas-program?autoStart=true along with other useful resources ... View more

Many thanks for your kind words @deeelle - we're always happy to help ... View more

Hi @deeelle and welcome to the community.   The error you are getting normally means the physical location you are pointing the libname statement at doesn't exist so that's the first thing to check.   The other possibility Its that I notice that you have a dot in the physical location. This may be causing an issue as a dot is usually the precursor to a file extension - try renaming the folder to remove the dot and change your libname statement. ... View more

Do you have the XML Mapper application installed? If you do or can install it then you'll find it normally makes creating an XML Map quite an easy process. If not then you'll have to hand-craft one yourself but you'd need to understand how the XML is structured and how you want it to be represented in your Sas Data Set which is a bit more challenging.   There's a good paper on it here -> https://www.lexjansen.com/nesug/nesug10/ff/ff14.pdf which is from 2010 but I don't think the Mapper application has changed much if at all since then. ... View more