About AlexeyS

AlexeyS · ‎07-26-2018

I want to update a protected table. Assume we have two users, and when I want to update the table, I need that second user will not open this table at the same time as me. Therefore I can use proc datasets. The code looks like this: In the first proc step, I hold dataset_name, to prevent from second user to enter this table. Then I update the table, and after that, I release the table. Can you see a problem with the code? proc datasets lib= library_name; modify dataset_name(pw=password); quit; data dataset_name; set dataset_name dataset_name_new; run; proc datasets lib= library_name; modify dataset_name(pw=password); quit;

AlexeyS · ‎07-15-2018

Hello, if I want to print to the log window the next sentence : %put Today is 15/07/2018; Why I don't need to add %nrbquote function? "/" is one of the special characters in %nrbquote / %bquote / %str / %nrstr http://support.sas.com/documentation/cdl/en/mcrolref/62978/HTML/default/viewer.htm#p06cx7fegzmzpen1m9991yljxiav.htm Thank you

AlexeyS · ‎07-05-2018

you are right, excuse me

AlexeyS · ‎07-05-2018

You want to say, that i cannot read a raw data as i wrote? Why i ask, because i saw a lot of palces, where they write it as me, but it doen't work. for example, https://onlinecourses.science.psu.edu/stat481/node/60/

AlexeyS · ‎07-05-2018

data cars; INFILE DATALINES dlm=','; input Make : $9. Invoice : comma6.; datalines; BMW,35,681 Chevrolet,28,197 ; run; Why I can't read Invoice correctly? What's wrong? Thank you

AlexeyS · ‎06-27-2018

Hello, I have a question, how can I predict using proc panel. Let's take an example : http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_panel_sect049.htm The data years are : 1970–1984 In this example, you run the next code: proc panel data=airline; id i t; model lC = lQ lPF LF / fixone; run; The output you got was : Now the question. How can I predict Total cost for years 1985 - 1988. Can I use parameters?

AlexeyS · ‎06-27-2018

I have a question, how can I predict using proc panel. Let's take an example : http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_panel_sect049.htm The data years are : 1970–1984 In this example, you run the next code: proc panel data=airline; id i t; model lC = lQ lPF LF / fixone; run; The output you got was : Now the question. How can I predict Total cost for years 1985 - 1988. Can I use parameters?

AlexeyS · ‎06-14-2018

Hello, I have a question about creation of app from htmls. When I click the icon, a menu is opened. Then i have a list of different reports, and i can click any report. How can I do it? Which tool I should use? Thank you very much

AlexeyS · ‎06-10-2018

data TEST; call streaminit(123); do i=1 to 20; ranuni=ranuni(123); rand=RAND('UNIFORM'); output; end; run; The question is : I expected to get the same values for ranuni and rand functions.

AlexeyS · ‎05-29-2018

Can you please explain, which way can I run AF command? My steps: 1. I created push button and named it as button1 2. save the button by the same name 3. open scl of button and wrote the code 4. save it 5. compile button , and then click run command Let's assume that my frame I created within library "Test" and Catalog="Development". But as I read, because I added scl code, I can't simple run it, I can do it by two ways : 1. in the command prompt I write : AF Test.Development.Button1.FRAME 2. using proc display There are any other ways to run the scl code? proc display catalog=Test.Development.Button1.FRAME ; run; I have one more problem with proc display: When I run with proc display and I click the button, I have to close frame to get the result. Why?

AlexeyS · ‎05-28-2018

I created a simple push button, and wanted to test, when I click the button dataset test is created. The name of button is button1. After I created a button and added scl code, I did compilation ant then run the code. No errors or warnings. But dataset test not created. My scl code is: init: return; button1: submit continue; data test; x=1; run; endsubmit; return;

AlexeyS · ‎05-15-2018

Hello, I want to convert character to numeric. My data looks like this : 104 104.25 104.35 103 I tried to use input Price_new = input(Price, best12.2); But the result I get as follows: 104 1.04 104.25 104.25 104.35 104.3 103 1.03 As you can see the problem is when the number is without decimal point. Please help me. Thank you

AlexeyS · ‎04-27-2018

%let city = New Orleans; title "Data for &city"; Why when i run these two statements, i still get "Data for &city" and not "Data for New Orleans" ? thank you

AlexeyS · ‎03-22-2018

Unfortunately, I need it in SAS BASE, and not in SAS IML.

AlexeyS · ‎03-22-2018

I am looking for SAS code to calculate the medcouple, has anyone such knowledge? https://en.wikipedia.org/wiki/Medcouple

Online Status	Offline
Date Last Visited	‎11-30-2023 05:57 PM

READ DATE variable from excel xlsx

CUBIC SPLINE - YIELD CURVES

Re: ods excel row-height for full excel

ods excel row-height for full excel

Re: proc report : cancel style

proc report : cancel style

Re: REGRESSION - AUTOMATICALLY CHOOSE THE BEST MODEL

REGRESSION - AUTOMATICALLY CHOOSE THE BEST MODEL

Re: proc model : vector of restrictions

proc model : vector of restrictions

Re: READ DATE variable from excel xlsx

Re: REGRESSION - AUTOMATICALLY CHOOSE THE BEST MODEL

Re: SAS AF still alive

Re: proc report : if/else inside compute statement

Re: Import all excel files with hebrew names from a folder

SAS AF still alive

import excel by defining type of variables

update protected dataset

Mask special character "/"

Re: read raw data

Re: read raw data

read raw data

Prediction using proc panel

Prediction using proc panel

Create app from htmls

generation random numbers

Re: SAS/AF dataset not created

SAS/AF dataset not created

Convert character to numeric

Replacing Text Strings Using Macro Variables

Re: Calculation of medcouple

Calculation of medcouple