PROC FORMAT IN SAS | SAS GLOBAL OPTIONS SAS TUTORIAL FOR BEGINNERS VIDEO 4

Sdílet
Vložit
  • čas přidán 25. 05. 2020
  • Informats and formats tell SAS the data's type (character or numeric) and form (such as how many bytes it occupies; decimal placement for numbers; how to handle leading, trailing, or embedded blanks and zeros; and so on). SAS provides informats and formats for reading and writing variables. For a thorough description of informats and formats that SAS provides, see SAS Formats and Informats: Reference.
    With informats, you can do the following:
    Convert a number to a character string (for example, convert 1 to YES).
    Convert a character string to a different character string (for example, convert 'YES' to 'OUI').
    Convert a character string to a number (for example, convert YES to 1).
    Convert a number to another number (for example, convert 0-9 to 1, 10-100 to 2, and so on).
    Note: User-defined informats read-only character data. They can convert character values into real numeric values, but they cannot convert real numbers into characters.
    With formats, you can do the following:
    Print numeric values as character values (for example, print 1 as MALE and 2 as FEMALE).
    Print one character string as a different character string (for example, print YES as OUI).
    Print numeric values using a template (for example, print 9458763450 as 945-876-3450).

Komentáře • 29

  • @BHARATHEEYUDU.
    @BHARATHEEYUDU. Před 3 lety

    YOUR TEACHING IS SUPERB MADAM
    PLEASE TELL MAKE A DETAIL VIDEO ON DICTIONARY .TABLES AND INDEXES VIEWS
    if permanent libarary how to deactivate global options
    and how delete or remove lable statements in datastep and proc sql

  • @rameshkannan1075
    @rameshkannan1075 Před rokem

    Mam do u provide training on credit risk modelling retail loans and ifrs 9 cecl implementation

  • @user-hu6db1nb8y
    @user-hu6db1nb8y Před rokem

    medam yours teaching is super how can i reach u for u r live classes

  • @RajatMadaanmaddy
    @RajatMadaanmaddy Před 3 lety

    Can you create a playlist according to lecture 1 -2 and so on

    • @Trenovision
      @Trenovision  Před 3 lety

      Dear Rajat it's already there SAS Programming Tutorials: czcams.com/play/PLCKKfofE2XYGPF9i2vkAgzY1fOwDMyK20.html

    • @RajatMadaanmaddy
      @RajatMadaanmaddy Před 3 lety

      okk ,, thank you

  • @MeDFreeTelugu
    @MeDFreeTelugu Před rokem

    Hii mam what is the use of var function and how to use

    • @Trenovision
      @Trenovision  Před rokem

      It helps you to compute the variance.

    • @MeDFreeTelugu
      @MeDFreeTelugu Před rokem

      Are you discuss the var function in any class

  • @harishkumar396
    @harishkumar396 Před 2 lety

    Mam instead of format we can use if conditions?

    • @Trenovision
      @Trenovision  Před 2 lety

      Format and if both are having different use case.

  • @Sk87_13
    @Sk87_13 Před rokem

    When I'm using the same format $gender. For sex here it's not converting them and the length of sex is showing only 1... How to do it???

    • @Trenovision
      @Trenovision  Před rokem

      Please share the code snippet to review.

  • @RajatMadaanmaddy
    @RajatMadaanmaddy Před 3 lety

    i have one doubt ,,, how can i set permission for SASUSER library in SAS university edition ? i am getting an error "ERROR: Write access to member SASUSER.FORMATS.CATALOG is denied."

    • @RajatMadaanmaddy
      @RajatMadaanmaddy Před 3 lety

      also i am not able to locate Catalogs in folder section of left side in university edition

    • @RajatMadaanmaddy
      @RajatMadaanmaddy Před 3 lety

      is there any way i can contact you ? i have few more doubts regarding permanent library is disappearing when i restarting sas session.

    • @rajashekar5755
      @rajashekar5755 Před 3 lety

      @@RajatMadaanmaddy bro when you create library by right click in the top right corner you will see one check box jst check it.so that you can view your libraries when you open freshly

    • @RajatMadaanmaddy
      @RajatMadaanmaddy Před 3 lety

      @@rajashekar5755 can you send a screenshot...it will help

    • @rajashekar5755
      @rajashekar5755 Před 3 lety

      @@RajatMadaanmaddy sorry bro, i thought in sas environmental software

  • @rajashekar5755
    @rajashekar5755 Před 3 lety

    Bro can you share sas software

    • @Trenovision
      @Trenovision  Před 3 lety

      Dear Raja
      No need to download any software you can register below and directly access sas via web link
      www.sas.com/en_in/software/on-demand-for-academics.html

  • @mohammedadil672
    @mohammedadil672 Před 3 lety

    HI CAN YOU TELL ME YOUR INSTITUTE NAME ALONG WITH THE WEBSITE PLEASE

  • @saikatde6343
    @saikatde6343 Před rokem

    data missing_data;
    input name : $15. age department : $30. sal;
    cards;
    Saikat 16 Physics 1000
    Debasmita 20 Chemistry 2000
    Maya 23 BiologicalScience 3000
    Razia Math 4000
    Kushal 25 Geography 5000
    ;
    run;
    Can you please help me how to read this data? Here in the row no 4, age is missing, but I am not providing any period(.). I am just making a mistake. is there any way to read?

    • @Trenovision
      @Trenovision  Před rokem

      Here you have to use period while importing data from an external file you can use missover option to handle missing values.

    • @saikatde6343
      @saikatde6343 Před rokem

      @@Trenovision yes correct. If we use missover option, it can handle missing values at the end or consecutive missing values till the end. I am not providing any value in the middle of the data. For that reason, I will have to provide a period? Or is there any option in SAS, we can use?