I have a dataset with two columns v1 and v2. V1 consists of labels such as "Spam" or "Ham" and v2 consists of texts. The error is "Proc hptmine reports ERROR: Unable to load extension: (tkparse) A computational component or a required service component could not be loaded in SAS enterprise miner" when I turn the text parsing node.
... View more
Hello SAS Community, Our team recently transitioned from Base SAS 9.4 to SAS Studio using Viya 4. We're encountering some challenges adapting our existing program that converts .dat files into SAS datasets for further analysis. These .dat files, received quarterly from IT, act as snapshots of our database on specific dates. We use them to generate numerous datasets used across various departments. Previously, in Base SAS 9.4, we successfully used the following code %let tm = sp124; /*update term*/ filename extract "X:\ircensus\scf extracts from ISC\&tm\_syra600ro_cron_gr.dat"; data bgx&tm; attrib bstuid informat=$char9. /* spriden_id */ SEXAPPL informat=$char1. /* spbpers_sex */ ethnic informat=$char33. /* combination of spbpers_ethn_cde & gorprac_race_cde */ byrtmapp informat=$char6. /* saradap_term_code_entry */ bapplnum informat=$char2. /* saradap_appl_num */ RELCODE1 informat=$char2. /* spbpers_lgcy_code=Y */ bhonors informat=$char4. /* saraatt_atts_code=HNRE */ natnbirth informat= $char3. /* sabsupl_natn_code_birth */ firstgen informat =$char1. /* first gen from ug admissions */ . . . . ; infile extract length=linelen delimiter='^' lrecl=1000 ls=1200 firstobs=2 missover; format bstupidm 8. JUNORGPA 5.2 satverb satmath satm satr 3. bbirthdt bdtaprec bdtapent bstactdt badactdt date9. ; input bstuid SEXAPPL ethnic byrtmapp bapplnum. . . . . . ; label bstuid = 'spriden_id' bstutype = 'saradap_styp_code' SEXAPPL = 'spbpers_sex' ethnic = 'spbpers_ethn_cde=NH,2=H,gorprac_race_cde=W,2=B,3=H,4=A,5=N,6=U' satm = 'sortest_test_score, sortest_tesc_code=SATM, SAT Math 2016' satr = 'sortest_test_score, sortest_tesc_code=SATR, SAT Reading 2016' . . . ; run; We'd greatly appreciate any guidance on replicating this functionality or converting the code for use within SAS Studio. Any insights or suggestions would be immensely helpful! Best Regards, Bhaskar
... View more
As I detailed in this post I'm trying to make a "Table 1" summary table and another additional table of descriptive statistics for dozens of variables. Generating the proper results is relatively easy. But rearranging those results for dozens of variables and putting them into a well-organized summary table takes a lot of code. The TableN macro does this extremely well, but it doesn't have a provision to add weights. Likewise, the code I wrote for the secondary table uses Proc Ttest, and there is no "SURVEY" equivalent (like Proc Surveyfreq is the equivalent to Proc Freq). Proc Ttest can use a person weight, but not sampling weights.
I'm supposed to have a meeting this afternoon to review the results. At this point, we just need initial results to start developing a theoretical model. So what kind of error will these results have? As I understand it, the standard error will be underestimated if weights are not used. As a result, some findings may appear to be significant but really aren't. Is that correct, and are there any other issues I should be aware of ?
... View more
I get the error: ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not loadable.. Please make sure Oracle environment is set correctly. Look in the install/Config doc for additional info for your platform. Works fine interactively, but no longer when submitted as a batch file. Worked fine this morning (and for years), but then installed MS Visual Studio and Python. That seems to have changed some path variable SAS version 9.4 TS 1M6, Windows 10 Enterprise In interactive mode (where it continues to work): %sysget(TNS_ADMIN) returns the correct network location. ORACLE_HOME, LD_LIBRARY_PATH not defined as system variables. I've uninstalled Python, MS Visual Studio, and reinstalled SAS. Same errors. First time posting here. Looked at related posts, but couldn't figure it out. Much appreciate any help.
... View more